On Mon, 20 Aug 2001, Michiel Leegwater wrote:
> insert into table1 select Startnr, Tijd, Afstand, Slag, Datum, Opmerking,
> CRvan,CRtot,PR,Categorie from table2;
>
> This doesn't work, it says "Column count doesn't match value count at row 1"
> I understand the problem. But I can't use my ID column in the select query
> because both tables have an AUTO INCREMENT ID. Does someone have any
> suggestions how to work around this??
What if you do: SELECT NULL, Startnr, Tijd, ... FROM table2
Put NULL in place of the AUTO INCREMENT id. That might work.
---------------------------------------------------------------------
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