mysqldump has a -w option: -w, --where= dump only selected records; QUOTES mandatory!
-- George > -----Original Message----- > From: 2wsxdr5 [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 02, 2006 12:30 PM > To: 'MySQL general mailing list' > Subject: dumping results of a select > > 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 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
