[snip] I have a table with about 50 fields in it, I want to copy certain records into another identical table...
i.e INSERT INTO mail_inbox (userid, subject, message, blah blah....) (Select userid, subject, message, blah blah... from mail_inboxold where userid = 10) Is there an easy way to do this without having to write all the field names out? [/snip] If the columns are in the same order you can use the following: INSERT INTO mail_inbox (SELECT * FROM mail_inboxold WHERE userid=10); --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
