MySQL常用命令(国外英文资料).docVIP

MySQL常用命令(国外英文资料) Start: Net start mySql; Enter the -u root -p/mysql -h: MySQL localhost -u root -p databaseName; List database: show databases; Select the database: use databaseName; List table: show tables; Display table column attributes: Show columns from tableName; Establish a database: source fileName.txt; Character: you can use wildcards _ on behalf of any character, any string representing%; A: alter table tabelName add column field fieldName dateType; Increase the number of alter table tabelName add column field: fieldName1 dateType, add columns fieldName2 dateType; Multi line command: be careful not to break the word; when the insertion or change data, can not be expanded to multi line string field, otherwise the hard return will be stored in the data; Add an administrator account: grant all on to user@localhost identified by password ; Each statement after the input at the end to add a semicolon ;, or add\gcan; Query time: select now (); The current user query: Select (user); Query the database version: Select (version); The use of query database: Select (database); 1, delete the students table in the student_course database: RM -f student_course/students.* 2, backup database (database backup: Test) Mysqldump -u root -p testc:\test.txt Backup table: (backup test database under the mytable form) Mysqldump -u root -p test mytablec:\test.txt The backup data into the database: (back to the test database) MySQL -u root -p testc:\test.txt 3, create a temporary table: (a temporary table Zengchao) Create temporary table Zengchao (name varchar (10)); 4, when you create a table to determine whether the table exists Create table if not exists (students...... ); 5, from the structure has some table copy table Create table table2 select table1 where 11 * from; 6, copy table Create table table2 select * from table1; 7, table rename Alter table table1 rename as table2; 8, modify the column types Alter table table1 modify id int unsigned; / / modify column ID of type in