MySQL Database Utility command set

MySQL Utility commands

(1), starting from the No. 0 row, take 3 lines
SELECT * FROM student limit 0,3

(2), view current database encoding

Show variables like ' character_set_database ';

(3), modify the database code (XXX is the database name)

ALTER DATABASE XXX CHARACTER SET gb2312;

(4), create user name and password (new version 5.7 Mysql)

CREATE user ' username ' @ ' localhost ' identified by ' password ';

(5), statistics the number of records in a table

SELECT COUNT (1) from table name;

MySQL Database Utility command set