Aargh

Rayman3_tk

Sorry, but it's getting late over here, so I'm coming up with another stupid question.

I'm trying to insert something into my database, but MySQL states

You have an error in your SQL syntax near ' units, buildings SET UID2 = '0', Food = '100', Wood = '25', Stone = '15', I' at line 1

when I'm trying to run this query:

INSERT INTO territory, units, buildings SET UID2 = '0', Food = '100', Wood = '25', Stone = '15', Iron = '5', UID3 = '0', UID4 = '0';

What am I doing wrong?

Tnx.

samueljonasson

I thought the syntax for inserting was more like this:

INSERT INTO TABLE(field1,field2) VALUES(value1, value2)

Sambo

Originally posted by Rayman3.tk
Hi

Sorry, but it's getting late over here, so I'm coming up with another stupid question.

I'm trying to insert something into my database, but MySQL states

You have an error in your SQL syntax near ' units, buildings SET UID2 = '0', Food = '100', Wood = '25', Stone = '15', I' at line 1

when I'm trying to run this query:

INSERT INTO territory, units, buildings SET UID2 = '0', Food = '100', Wood = '25', Stone = '15', Iron = '5', UID3 = '0', UID4 = '0';

What am I doing wrong?

Tnx.

DeltaRho2K

You're right Sambo... The original post is mixing up INSERT and UPDATE queries... Which are you tring to do Rayman?

ahundiak

INSERT INTO territory, units, buildings

I don't think you will have much luck trying to insert into three different table in one statement. Use 3 inserts.

And the SET keyword is ok for INSERT.

DeltaRho2K

I stand corrected. I didn't realize the SET command was cool for INSERT statements. I guess I just follow a certain convention, and this isn't how I learned it. I think I would avoid use SET in INSERTS, for the very reason of avoiding confusion personally...

Rayman3_tk

Hehe, thanks guys, I'll look into it!

chriskl

Avoid it because it's made-up, non-standard MySQL syntax...

Chris