What is wrong with this insert.

[sn1per]

I'm sick, i'm at work, my head's killing me and i can't debug this. Do you see anything wrong?





INSERT INTO tracker(primary, email, ip, date, offer, network) VALUES ('', 'sniper@aol.com', '192.168.1.108', '20080327','dating','flux')

[awol]

What error are you getting?

[rmk]

is primary autoincrement or anything? what error are you getting

[awol]

is primary autoincrement or anything? what error are you getting

Exactly what I was wondering.

If it's a PK or an auto_increment/identity, you can't insert into it.

[Repins]

primary is auto. Error is thus:


#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 'primary, email, ip, date, offer, network) VALUES ('', 'sniper@aol.com', '192.168' at line 1

[Repins]

g'damn i'm rusty

[doolbman]

try
INSERT INTO tracker(`primary`, `email`,` ip`, `date`,` offer`, `network`) VALUES ('', 'sniper@aol.com', '192.168.1.108', '20080327','dating','flux')
also you shouldn't use date as a row name since it is also a function in mysql

[Repins]

try
INSERT INTO tracker(`primary`, `email`,` ip`, `date`,` offer`, `network`) VALUES ('', 'sniper@aol.com', '192.168.1.108', '20080327','dating','flux')also you shouldn't use date as a row name since it is also a function in mysql


Thank you sir. Your 2 suggestions fixed it.

INSERT INTO tracker(`primary`, `email`,`ip`, `when`,`offer`, `network`) VALUES ('', 'sniper@aol.com', '192.168.1.108', '20080327','dating','flux')

[mcbain]

just out of curiousity, since i dont use mysql that much. mostly oracle, sql server, sybase, db2.

when doing da insert statement

insert into table('these','fieldnames','need','to','be','enclo sed','in','quotes?') values ('bla','bla','bla','bla','bla','bla','bla','bla')

thats a question. do they need field names need to be enclosed in quotes?

[awol]

just out of curiousity, since i dont use mysql that much. mostly oracle, sql server, sybase, db2.

when doing da insert statement

insert into table('these','fieldnames','need','to','be','enclo sed','in','quotes?') values ('bla','bla','bla','bla','bla','bla','bla','bla')

thats a question. do they need field names need to be enclosed in quotes?

They aren't single-quotes, they are backticks.

Which indicates the error was in the keywords PRIMARY and DATE being used as column names w/o backticks (akin to using [column_name] in SQL Server)