mysql学习心得（MySQL learning experience）.docVIP

mysql学习心得（MySQL learning experience） MySQL database operations: version 5.1 Installation and uninstall of 1.MySQL: note that the settings font is: utf8 2. start the MySQL service: net, start, MySQL Turn off the MySQL service: net stop MySQL 3. login MySQL server: MySQL, -uroot, -p123 (user name: root, password: 123) Exit: exit Remote connection: MySQL, -h192.168.1.181, -uroot, -p123 Note: the following steps do not follow; 4.show databases looks at the database in MySQL 5. create a database: create database wpj1111; (note the end of a semicolon) DDL: (database definition language) create drop alter for database or table structure DCL: (database control language) grant revoke commit rollback for database permissions, operations, transaction processing DML: (database operating language) insert delete update select for database add, delete, change, check operation 6. using the database: use wpj1111; 7. build table: create, table, EMP (ID, int), Name varchar (20), Age int, Sex char (4), Salary float); Note: char fixed length (provincial space) varchar variable length (slow time) 8. see table structure description: desc emp; 9. insert a statement: insert, into, EMP (ID, name, age, sex, salary), values (1,liuhui, 18,M, 8000); Note: the date format is also quoted in single quotation marks 10. query table data: Select * from emp; 11. modify the data in the table: Update, EMP, set, salary=6666, where, id=1; 12. delete records: Delete from EMP; empty the data in the table Delete from EMP where id=4; deletes a record of ID 4 13. solve Chinese coding: View database status: Status A. find the my.ini file under the MySQL installation directory and find default-character-set=utf8 (to change two places to utf8) B.net, stop, mysql, net, start, MySQL C.set names GBK; (on the client side, modify the encoding mode for GBK) D. a database or table that has been created before modifying the encoding: Alter, database, wpj1111, default, character, set, utf8; Alter, table, EMP, convert, to,