MySQL Common command characters

Collect in Network!!!!

Solve character garbled problem: Display Chinese instead of garbled: set names UTF8;

Modify New Password: Update user set Password=password (' New password ') where user= ' username ';

Update permissions: Flush privileges;

Add New User: Grant Select on database. * To User name @ Login host identified by ' password ';

Delete User: Delect from user where user= ' user name ' and host= ' localhost ';

Delete databases: drop database dbname;

Delete tables: drop TABLE tablename;

View current Usage database: select () db;

Get table structure: DESC tablename;

Show columns from TableName;

Decribe TableName;

Insert data: INSERT INTO tablename values (), ();

Query the first few rows of data: SELECT * FROM tablename ORDER by ID limit 0, 2;

Change table name: Rename table name to new table name;

Data import: Source *sql (direct path);

Data export: Mysqldump-u root-p database name > exported file name (direct path, available in this directory)

MySQL Common command characters