作者badbadook ( 嗨浪)
看板ask
标题[请问] 一个phpmyadmin的问题
时间Thu Jan 28 18:05:39 2016
#1064 - 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
'=utf8 COLLATE utf8_general_ci NOT NULL , `a_email` TEXT CHARSET=utf8 COLLATE
ut' at line 1
要加入一个新的资料表然後显示这样的错误
预览sql 为以下
CREATE TABLE `book`.`data` ( `id` SMALLINT NULL AUTO_INCREMENT , `a_name`
TEXT CHARSET=utf8 COLLATE utf8_general_ci NOT NULL , `a_email` TEXT
CHARSET=utf8 COLLATE utf8_general_ci NOT NULL , `a_data` TEXT CHARSET=utf8
COLLATE utf8_general_ci NOT NULL , `daytime` TIMESTAMP NOT NULL , PRIMARY KEY
(`id`)) ENGINE = InnoDB;
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 114.43.149.224
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/ask/M.1453975542.A.BC1.html
1F：推 yzfr6: 从伊莉问到这来？ 01/28 18:24
2F：→ badbadook: 没再依例问 01/28 18:28
3F：推 lingpxs: 可以table每个栏位另订字集吗？? 01/29 22:18