作者ghostleader (小居批~)
看板Database
標題[SQL ]
時間Wed Jun 25 17:05:02 2008
我想請問一下這段程式碼哪裡錯誤呢??
insert into register (name,sex,birth,id,school,eat,phone,mobile,add,email)
values=("雷風臨","男生","1992/2/29","A129622821","好保中學","雜食","02-12345678
", "0963080800","科科科科科科科科科科科科科科科科科科科科科科科","
[email protected]"
);
因為她不讓我執行
SQL 語法:
insert into register (name,sex,birth,id,school,eat,phone,mobile,add,email)
values("雷風臨","男生","1992/2/29","A129622821","好保中學","雜食","02-1234567
8", "0963080800","科科科科科科科科科科科科科科科科科科科科科科科","
[email protected]
t");
MySQL 傳回： 說明文件
#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
'add,email) values=("é // 後面亂碼
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 210.71.78.30
1F：推 arrack:error msg? 06/25 17:05
2F：→ ghostleader:抱歉抱歉 忘了打 06/25 17:09
※ 編輯: ghostleader 來自: 210.71.78.30 (06/25 17:11)
3F：推 bcse:VALUES 後面沒有 = 吧？ 06/25 17:24
※ 編輯: ghostleader 來自: 210.71.78.30 (06/25 17:35)
4F：→ ghostleader:感謝 bcse 大大 但是還是不行欸 06/25 17:35
5F：推 KC73:先把中文換成英文試試 (推文怎麼要等三十多秒?) 06/25 18:25
6F：推 adrianshum:通常 SQL 裡都是用 ' 而不是 " 來表示字串 06/25 20:23