I'm trying to use a INSERT INTO table1 (column1, column2, column3) SELECT 'value', 'value2', table2.value3 FROM table2 WHERE table2.value4='name';
This query fails from C, but if I copy and paste it exactly to the mysql client, it works. If I run mysql_info(), it tells me: Records: 0 Duplicates: 0 Warnings: 1 But I have no idea what the warning is. Is there any way to find out? mysql_error returns '\0' so it's no help. Thanks! ______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca --------------------------------------------------------------------- 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