467,876 Members | 1,226 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,876 developers. It's quick & easy.

INSERT .... SELECT

I tried that, but i dont work either.

I need to insert a way that mysql doese'nt complain when i copy some
records that have the same id (or that it just gives it an id according
to the AUTO_INCREMENT)

Thanks again

//Lars Rasmussen

-----Oprindelig meddelelse-----
Fra: Jay Blanchard [mailto:ja***********@niicommunications.com]
Sendt: 13. august 2003 19:59
Til: Lars Rasmussen; my***@lists.mysql.com
Emne: RE: INSERT .... SELECT
[snip]
I used this command:
INSERT INTO nye_opskrifter SELECT * FROM opskrifter where id
in($numbers)

But now it gives this error:
Column count doesn't match value count at row 1
[/snip]

* does not return a specific number of columns, the work around is to
specify the columns explicitly

INSERT INTO nye_opskrifter SELECT foo, bar FROM opskrifter where id
in($numbers)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my****************@sprit.dk

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
  • viewed: 2737
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Philip Boonzaaier | last post: by
6 posts views Thread by lenygold via DBMonster.com | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.