#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