mysql（MySQL）.docVIP

mysql（MySQL） Twenty million one hundred and thirty thousand five hundred and twenty-eight 1. install MySQL 2. start and stop services 3. connect to the Mysql server and exit Connection command: MySQL [-h host address] -u user name -p password (no middle spaces) Exit command: exit or quit 4. display database list Show databases; 5. opens the specified database: Use database name; 6. view the currently open database Select, database (); 7. displays the data tables in the database: Show tables; 8. display version number and system time: Select, Version (); Select, now (), current_date, current_time; 9. view the current user: Select, user (); 10. create database commands Create database name; Create, database, if, not, exists, students; Create, database, students, default, charset=GBK; 11. delete a database: Drop database name; Create, database, if, exists, students; Three main types of 12.Mysql: Numeric, character, date type Numeric: int, float, double... Character type: char (fixed) varchar (variable) 13. create table commands Create table table name, field name, 1 type, 1 length , field name, 2 type, 2 length field name, N type, n length ) 14. look at the command of the table structure Desc table name; show columns from table name; 15. delete tables Drop table table name; 16. add fields to the table Alter, table, table name, add field type, other; 17. modify the field name Alter, table, table name, change, old column name, new column name, paragraph type, length 18. modify the field type Alter table table name modify column name field type (length) Twenty million one hundred and thirty thousand five hundred and twenty-nine 1.insert insert command Insert: insert, into, table name, values (,, , ; Partial insert: insert into table name (field name 1, field name 2..) values (corresponding field 1 type value, corresponding field 2 type value..); 2. modify the command: Update table name, set field name = value, where condition; 3. delete command: Delete from table name w