Linux new library and new table in MySQL

To create a library:

Create DATABASE test;

drop database test;

show databases;

To create a table:

Use test;

CREATE TABLE tabtest (id int,name nvarchar (255));

Insert Table Tabtest VALUES (1234, ' insert content '); Insert content in table

drop table tabtest; Delete a table

Show tables; View a table in the library

SELECT * from Tabtest; View the contents of a table

SELECT * from Tabtest ORDER by ID limit 0,2 View the contents of the first 2 rows in the table Tabtest table

Linux new library and new table in MySQL