作者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