MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: INSERT INTO TABLE
Posted by: Adwait Joshi
Date: July 22, 2005 11:07AM

I tried the suggestion but I get a error message, called

MySQL said: Documentation
#1062 - Duplicate entry '0' for key 1

my SQL looks lke

INSERT INTO A( CATEGORY, GROUPID, GROUPTITLE, ALBUMID, ALBUMTITLE, DEFAULTTHUMB, TFILE,
FILE , BFILE, TITLE, DESCR, PIC_LOCK )
SELECT 'Nature', 'buf', 'In and Around Buffalo', 'letchworth', 'Letchworth Park', '', TFILE,
FILE , BFILE, TITLE, DESCR, PIC_LOCK
FROM B

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
INSERT INTO TABLE
Adwait Joshi
July 18, 2005 11:14AM
Re: INSERT INTO TABLE
Kanwal Khipple
July 18, 2005 12:47PM
Re: INSERT INTO TABLE
Felix Geerinckx
July 19, 2005 12:37AM
Re: INSERT INTO TABLE
Adwait Joshi
July 22, 2005 11:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.