Get rid of the second "values".
mysql> INSERT into book(
-> isbn,
-> title,
-> authlname,
-> authfname,
-> publisher,
-> pubdate,
-> dewey,
-> lcnum
-> )
-> values (
-> '1-56592-434-7',
-> 'MySQL & mSQL',
-> 'Yarger',
-> 'Randy Jay',
-> "O'Reilly",
-> null,
-> null,
-> null
-> ),
-> (
-> '0-312-25313-3',
-> 'Coup de Grace',
-> 'Borthwick',
-> 'J S',
-> "St Martin's Minotaur",
-> null,
-> '813.54-dc21',
-> 'PS3552.O756 C68 2000'
-> );
----- Original Message -----
From: "Bob Rea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 4:33 PM
Subject: Beginner needs help
I'm getting a syntax error when I try to insert more two
sets of values into a table.
I have looked at the manual on the insert statement, and
don't see what is wrong.
Can someone tell me.
Here's the info.
mysql> describe book;
+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+-----------+-------------+------+-----+---------+----------------+
| booknum | int(20) | | PRI | NULL |
auto_increment |
| isbn | varchar(14) | YES | | NULL |
|
| title | varchar(50) | YES | | NULL |
|
| authlname | varchar(20) | YES | | NULL |
|
| authfname | varchar(20) | YES | | NULL |
|
| publisher | varchar(20) | YES | | NULL |
|
| pubdate | date | YES | | NULL |
|
| dewey | varchar(20) | YES | | NULL |
|
| lcnum | varchar(20) | YES | | NULL |
|
| checkin | date | YES | | NULL |
|
| checkout | date | YES | | NULL |
|
| duedate | date | YES | | NULL |
|
+-----------+-------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)
Here's the attempt:
mysql> INSERT into book(
-> isbn,
-> title,
-> authlname,
-> authfname,
-> publisher,
-> pubdate,
-> dewey,
-> lcnum
-> )
-> values (
-> '1-56592-434-7',
-> 'MySQL & mSQL',
-> 'Yarger',
-> 'Randy Jay',
-> "O'Reilly",
-> null,
-> null,
-> null
-> ),
-> values(
-> '0-312-25313-3',
-> 'Coup de Grace',
-> 'Borthwick',
-> 'J S',
-> "St Martin's Minotaur",
-> null,
-> '813.54-dc21',
-> 'PS3552.O756 C68 2000'
-> );
ERROR 1064: You have an error in your SQL syntax near
'values(
'0-312-25313-3',
'Coup de Grace',
'Borthwick',
'J S',
"St Martin's Minot' at line 21
TIA
--
Bob Rea
**************************************************
"On the side of the box, under 'System
Requirements', it said 'Requires Windows
95 or better'. So I installed Linux."
**************************************************
[EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
