Simple MySQL Command

MySQL Command summary:
Open mysql.exe and enter the password
Logon operation
Mysql-u root-P;
Database Operations
Show databases; displays the database
Create Database db_name; Create a database
Use db_name; use the database
Source D:/DB. SQL; import database

Table operations
Show tables; view the tables in the current database
Create Table table_name (name varchar (20), sex char (1 ));
Create a data table
Desc table_name; displays the table structure
Insert into table_name values ("", ""); add a record to the table
Load data local infile "D:/mysql.txt" into Table table_name; load data into database tables in text mode
Drop table table_name; delete a table
Delete from table_name; clear the table
Update table_name set sex = "F" where name = "Lili"; update a data table
Select * From table_name where name = ""; displays table data