MySQL Command Common commands

/*Load data from TXT file*/LOADDATA LOCAL INFILE "D:/Data.txt " into TABLETname;/*Load. sql command File*/SOURCE D:/Mysql.sql;/*Change passowrd*/UPDATEMysql.User SETPassword=PASSWORD ('123456')WHERE User = 'Root';/*Show Current Database*/SELECT DATABASE();/*Show Current User*/SELECT USER();/*Create the database*/CREATE DATABASEdbname;/*Choose the database*/ Usedbname;/*Delete the database*/DROPdbname;/*Show the Tables*/SHOW TABLES;/*Describe the table*/DESCRIBE Tname;/*Create the table*/CREATE TABLETname (IDINT, nameVARCHAR( -));/*Delete the table*/DROP TABLETname;/*Delete the date in table*/TRUNCATE TABLETname;/*Insert the table*/INSERT  intoTnameVALUES(1,'Hello');/*Search the table*/SELECTID, name fromTnameWHEREId= 1 ORDER  by DESC;/*Update the table*/UPDATETnameSETName= ' World' WHEREId= 1;/*Display the table*/SELECT *  fromTname;

More information Check:

http://blog.csdn.net/ithomer/article/details/5131863

MySQL Command Common commands