Mysql笔记

 常用语句：

1. mysql -uSID -pPWD
2. show databases;
3. show tables;
4. use dbname;
5. create database dbname;
6. drop database dbname;
7. mysqladmin -uSID -pPWD drop dbname
8. mysqladmin -uSID -pPWD create dbname
9. ALTER TABLE tablename ADD colname varchar(20)
10. alter tablename checks change column `check` `id` numeric(6)
11. desc tablename    describe Tablename    show columns from Tablename    show create table Tablename
12. show character set 
13. SHOW VARIABLES LIKE 'character_set_%'
14. SHOW VARIABLES LIKE 'collation_%'
15. SET character_set_client='utf-8'
16. SET character_set_connection='gbk'
17. SET character_set_results='utf-8'
18. 查看数据库的编码是什么 然后在页面中设置mysql_query("set names 'utf8'"); 编码要和数据库一直
19. select * from table limit 0,10
20. create database if not exists dbname;
21. dorp database if exists dbname;