[請益] 有關insert的問題

看板PHP作者ocst (new student)時間16年前 (2009/03/24 02:36)推噓5(5推 0噓 2→)

留言7則, 3人參與討論串1/1

我在資料庫建立一個susers的table ============================================= CREATE TABLE `susers` ( `id` int(11) NOT NULL auto_increment, `tname` varchar(25) character set utf8 NOT NULL default '', `tsex` int(11) NOT NULL default '0', `tnumber` varchar(25) character set utf8 NOT NULL default '', `tbirthday` date NOT NULL default '0000-00-00', `tcountry` varchar(25) character set utf8 NOT NULL default '', `tschool` varchar(25) character set utf8 NOT NULL default '', `tjob` varchar(25) character set utf8 NOT NULL default '', `tteach1` varchar(25) character set utf8 NOT NULL default '', `tteach2` varchar(25) character set utf8 NOT NULL default '', `tphone` varchar(25) character set utf8 NOT NULL default '', `tpasswd` varchar(10) character set utf8 NOT NULL default '', `temail` varchar(25) character set utf8 NOT NULL default '', `tgid` varchar(25) character set utf8 NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM; =============================================================== 但是我在phpadmin下以下的指令一直出現錯誤，實在不太曉得自己的問題在哪可否請各位高手指點感激<(_ _)> INSERT INTO susers ('tname','tsex','tnumber','tbirthday','tcountry' ,'tschool','tjob','tteach1','tteach2','tphone','tpasswd','temail') VALUES ('aaa',1,'42042','1958-12-12','aaa','aaa','aaa','aaa','aaa','147', '$md5pass','$_POST[email]') 錯誤訊息 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 ''tname','tsex','tnumber','tbirthday','tcountry' ,'tschool','tjob','tteach1','tte' at line 2 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 118.169.197.17