Mysql review and Learning (2) create and delete databases and table Structures

Mysql-h localhost-uroot-p123456 // connect to the database

Show databases; // view the database

Create database if not exists db_goods; // create a database

Use db_goods; // use the database

Show tables; // View tables in the database

Create table goods (id int, name varchar (10); // create a table

Desc goods; // view the tag Structure

Insert into goods (id, name) values ('1', 'hangsan'); // insert data into the table

Update goods set name = 'lisi', id = '3' where id = '1'; // update data

Delete from goods where id = '1'; // delete data

Drop table if exists goods; // delete a table

Drop database if exists db_goods; // delete a database

? Contents; // view help

? Create table; // view the help for creating a table