[請問] 一個phpmyadmin的問題

[badbadook ( 嗨浪)]

  #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://www.ptt.cc/bbs/ask/M.1453975542.A.BC1.html
推 yzfr6: 從伊莉問到這來？
→ badbadook:  沒再依例問
推 lingpxs: 可以table每個欄位另訂字集嗎？?