#mysql学习课堂笔记

#mysql学习课堂笔记
AUTO_INCREMENT
NOT NULL
1.修改 MySQL 数据表默认字符集（mysql table default character set）

mysql> ALTER DATABASE mysql_test
    -> DEFAULT CHARACTER SET gb2312
    -> DEFAULT COLLATE gb2312_chinese_ci;

2.在编写mysql中，如果创建表的column中，后续没有内容，不能用‘，’隔开，否则会报错

mysql> CREATE TABLE students
    -> (
    -> studentID CHAR(18),
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4

3。在调用ALTER TABLE指令的子句时候，需要先调用子句的原句，例如ALTER TABLE 下有的修修改子句有ADD(添加），CHANGE(修改,PS:和MODIFY，ALTER的区别)，DROP(删除)。否则会报错。
错误示范

mysql> ADD (classNO CHAR(8),brithday CHAR(1));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD (classNO CHAR(8),brithday CHAR(1))' at line 1

正确示范

mysql> ALTER TABLE students
    -> ADD (classNO CHAR(8),brithday CHAR(1));
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

4查看自己已经设置好的表（TABLE