CMD under the mysql operation command Daquan detailed

Start: net start mySql;

Enter: Mysql-u root-p/mysql-h localhost-u root-p databaseName;

List databases: show databases;

Select database: Use DatabaseName;

List table: Show tables;

Show table Column properties: Show columns from TableName;

Build database: Source FileName.txt;

Match characters: You can use wildcard characters _ to represent any one character, and% to represent any string;

Add a field: ALTER TABLE tabelname add column FieldName datetype;

Add multiple fields: ALTER TABLE tabelname add column fieldName1 datetype,add columns fieldName2 datetype;

Multi-line command input: Note that you cannot break the word, and when inserting or changing data, you cannot expand the string of the field into multiple lines, or the hard return will be stored in the data;

Add an Administrator account: Grant all on * * to [e-mail protected] identified by "password";

Fill in the end of each statement with a semicolon '; ', or add ' \g ' to it;

Query time: Select Now ();

Query Current User: Select User ();

Querying database version: Select version ();

Querying the database currently in use: s