MySQL Common commands

Login: Mysql-uroot-p-p3306-h----(-u means user name,-p for password, can not lose,-p for port number,-H for Host name)
Show current server version: SELECT version ();
Show current date time: Selectnow ();
Show Current User: SELECT user ();
Create a database: ([] The writable is not writable)
CREATE {DATABASE | SCHEMA} [IF not EXISTS] db_name [DEFAULT] CHARACTER SET [=] Charset_name
To view a list of data tables under the current server:
SHOW {DATABASES | SCHEMAS} [like ' Patter ' | WHERE Expr]
To modify a database:
ALTER {DATABASE | SCHEMA} [Db_name] [DEFAULT] CHARACTER SET [=] Charset_name
To delete a database:
DROP {DATABASE | SCHEMA} [IF EXISTS] Db_name

To create a data table:
CREATE TABLE [IF not EXISTS] table_name (
column_name Data_type,
......
);
Show data table:
SHOW TABLES [from db_name] [like ' Patter ' | WHERE Expr]
Show data table structure:
SHOW COLUMNS from Tbl_name

This article is from the "Computer China" blog, please be sure to keep this source http://wwwdnzgcn.blog.51cto.com/10104823/1651777

MySQL Common commands