INSERT INTO abc
VALUES (
a, b, c, d, e, f
)
SELECT a, b, c, d, e,f
FROM bcd
when i execute this iam getting synatx errors .how do i get rid of the synatx error
views:
71answers:
3
+7
A:
Are you thinking this?
INSERT INTO abc(a,b,c,d,e,f) SELECT a,b,c,d,e,f from bcd;
aehiilrs
2010-07-17 02:30:55
+6
A:
the problem is you don't use the VALUES keyword when using a select statement to populate the values.
INSERT INTO abc (a,b,c,d,e,f) SELECT a, b, c, d, e,f FROM bcd
Here is a reference for the INSERT syntax
northpole
2010-07-17 02:31:37
I win by 42 seconds! :P
aehiilrs
2010-07-17 02:32:32
ya, seems to always be the case, which is a good thing, means there is a lot of knowledgeable people that use this site.
northpole
2010-07-17 02:34:07
Yeah, I love this site for that exact reason. That little bit of competition just adds to the fun.
aehiilrs
2010-07-17 02:35:14
A:
Here a,b,c,d,e,f are values or field names?
if they are values,
It will be: INSERT INTO abc VALUES('a','b','c','d','e','f');
If they are fields, you have to specify values to insert.
SELECT is ok, if they are fields.
Nikhil K
2010-07-17 04:18:28