mysql数据库建立表总是出错_mysql数据库在创建表的时候出错

mysql>createtabledev_log(indexintlogtypeintlevelintmoduleintmessgaechar(80)logtime_fromdatelogtime_todate);ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualth...

mysql> create table dev_log(index int logtype int level int module int messgae char(80) logtime_from date logtime_to date);

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 'int logtype int level int module int messgae char(80) logtime_from date logtime_' at line 1

mysql> create table dev_log(index int, logtype int, level int, module int, message char(80), logtime_from date ,logtime_to date);

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 'int, logtype int, level int, module int, message char(80), logtime_from date ,lo' at line 1

展开