"Notes" MySQL Starter Statement 8 article

1. Connect to the database server

Mysql-h host-uroot-pxxxx

2. View all libraries

show databases;

3. Select Library

Use library name

4. View the table below the library

Show tables;

5. Build a table

CREATE table msg (ID int auto_increment primary key,content varchar ($), pubtime int) charset UTF8;

Tell the server your character set: set names gdb/utf8/...;

6. Add Data

INSERT into MSG (id,content,pubtime) VALUES (' 1 ', ' dd ', ' 2 ');

7. Query all data

SELECT * from MSG;

8. Data emptying

Truncate MSG;

"Notes" MySQL Starter Statement 8 article