MySQL INSERT problem

[Caversham]

I am trying to insert data into the fields id and term of the table
key. id is an auto-incrementing field.

Each of the following forms fails:-

INSERT INTO key (id, term) VALUES (0, 'dog')

INSERT INTO key ('id', 'term') VALUES (0, 'dog')

INSERT INTO 'key' ('id', 'term') VALUES (0, 'dog')

INSERT INTO 'key' (id, term) VALUES (0, 'dog')

mysql_error() returns messages of the following form:-

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 'key (id,
term) VALUES (0, 'dog')' at line 1

What is wrong with the syntax?

Caversham

[Malcolm Dew-Jones]

Caversham (ac******@yahoo .com) wrote:
: I am trying to insert data into the fields id and term of the table
: key. id is an auto-incrementing field.

: Each of the following forms fails:-

: INSERT INTO key (id, term) VALUES (0, 'dog')

: INSERT INTO key ('id', 'term') VALUES (0, 'dog')

: INSERT INTO 'key' ('id', 'term') VALUES (0, 'dog')

: INSERT INTO 'key' (id, term) VALUES (0, 'dog')

: mysql_error() returns messages of the following form:-

: 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 'key (id,
: term) VALUES (0, 'dog')' at line 1

: What is wrong with the syntax?

Guessing, but is key a keyword? You might need to use a different name
for the table.
--

This space not for rent.

[Nicholas Sherlock]

Malcolm Dew-Jones wrote:

Caversham (ac******@yahoo .com) wrote:
: I am trying to insert data into the fields id and term of the table
: key. id is an auto-incrementing field.

: Each of the following forms fails:-

: INSERT INTO key (id, term) VALUES (0, 'dog')

: INSERT INTO key ('id', 'term') VALUES (0, 'dog')

: INSERT INTO 'key' ('id', 'term') VALUES (0, 'dog')

: INSERT INTO 'key' (id, term) VALUES (0, 'dog')

: mysql_error() returns messages of the following form:-

: 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 'key (id,
: term) VALUES (0, 'dog')' at line 1

: What is wrong with the syntax?

Guessing, but is key a keyword? You might need to use a different name
for the table.

If this is so, he should be able to use backticks ' ` ' to do the job:

INSERT INTO `key` (id, term) VALUES (0, 'dog')

Cheers,
Nicholas Sherlock

[Ken Robinson]

Caversham wrote:

I am trying to insert data into the fields id and term of the table
key. id is an auto-incrementing field.

Each of the following forms fails:-

INSERT INTO key (id, term) VALUES (0, 'dog')

INSERT INTO key ('id', 'term') VALUES (0, 'dog')

INSERT INTO 'key' ('id', 'term') VALUES (0, 'dog')

INSERT INTO 'key' (id, term) VALUES (0, 'dog')

mysql_error() returns messages of the following form:-

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 'key (id,
term) VALUES (0, 'dog')' at line 1

Use the following syntax:

insert into `key` set term='dog';

If you don't specify the auto increment field, it will "do the right
thing", autoincrement. Any other fields you don't specify will take
their default values.

Ken

[Tom Thackrey]

On 17-Jun-2005, "Caversham" <ac******@yahoo .com> wrote:

INSERT INTO key (id, term) VALUES (0, 'dog')

INSERT INTO key ('id', 'term') VALUES (0, 'dog')

INSERT INTO 'key' ('id', 'term') VALUES (0, 'dog')

INSERT INTO 'key' (id, term) VALUES (0, 'dog')

mysql_error() returns messages of the following form:-

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 'key (id,
term) VALUES (0, 'dog')' at line 1

What is wrong with the syntax?

"key" is a mysql keyword and needs to be enclosed in backticks: `key`

http://dev.mysql.com/doc/mysql/en/reserved-words.html

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to ja*********@wil lglen.net (it's reserved for spammers)