2wsxdr5 <[EMAIL PROTECTED]> wrote on 03/02/2006 12:30:17 PM: > Is there a way with mysqldump to instead of dumping the contents of a > table dump the contents of a select so if you import that sql back in > you will get a new table that looks like the select? > > -- > Chris W > KE5GIX > > Gift Giving Made Easy > Get the gifts you want & > give the gifts they want > One stop wish list for any gift, > from anywhere, for any occasion! > http://thewishzone.com > >
I don't think so but if all you wanted to do was to create a new table out of the results you could say CREATE TABLE newtable SELECT ... I use it all the time to great effect. Documentation is near the bottom of this page: http://dev.mysql.com/doc/refman/4.1/en/create-table.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine