Question

mysql 中 varchar类型,在定义的时候要给长度么?给和没给有什么区别?

Answer 1

varchar要给长度， 不然会报错

Answer 2

mysql> create table testTab(test varchar);
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 1

mysql> create table testTab(test varchar(10));
Query OK, 0 rows affected (0.01 sec)

不给长度， 就要报错误信息。