This has to be something silly, but I can not see it. Any help greatly
appreciated:
use newshop;
insert into products set storeid=2, deptid=5, groupid=66, prodid='C2BUWS1028',
prodtitle='<b>Antique Circle 6/20; 1/2inches-lg Pearl Buttons & Novelty
Buttons</b>',
proddesc1='3 buttons per card; 1/2 inches', price=3.75,
imgsml=C2BUWS1028.jpg, imgsmlwidth=105, imgsmlheight=105, discid=12;
gets
ERROR 1109 at line 2: Unknown table 'C2BUWS1028' in field list
mysql> explain products;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| storeid | varchar(50) | | PRI | | |
| deptid | varchar(50) | | PRI | | |
| groupid | varchar(50) | | PRI | | |
| prodid | varchar(50) | | PRI | | |
:
:
If I put all the col=value entries on one line it seems to work. I am generating a
bunch of these so I can format them in any manner that works. It seems that
set col1=value1, col2=value2, ...
can not be continued> Is this correct?
Thanks for any pointers
_____
Douglas Denault
[EMAIL PROTECTED]
Voice: 301-469-8766
Fax: 301-469-0601
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
