Explicit Insert

dbchip2000

Hi,
I am using MySQL and I am having problems inserting into a database from a PHP script. I have a table with ID as the primary key, but when I add something like INSERT INTO test VALUES (2,"test") and IDs before it haven't been added, it will set it to 1 even though I said two. I am sure there is a way around it. Thanks for helping

Daggeth

You have to put the "2" in quotes.. me thinks.

dbchip2000

It is in quotes, my mistake above

WinterDragon

hehe you need to declare where you're going to actually insert the values...

So it NEEDS to know what columns to put the values into...

INSERT INTO test (number, otherField) VALUES ("2","test");

There... that should fix it... dunno exactly what your column names are...

Daggeth

I dont believe it NEEDS to know the tables.. for example, if your table is like this:

Names:
+-----------------------------------------+
| ID | Name |
+-----------------------------------------+

mysql> INSERT INTO Names VALUES ('2', 'Bob');

would work!

Now if the table was:

Jobs:
+-----------------------------------------+
| ID | Name | Jobs |
+-----------------------------------------+

mysql> INSERT INTO Jobs (ID, Name) VALUES ('2', Steve);

would work and the first one wouldnt. You only need to declare it if its only certain fields of the table youre filling.

me thinks..