作者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/m.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