Re: dumping results of a select

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 > > Gif

RE: dumping results of a select

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: du

RE: dumping results of a select

[snip] 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? [/snip] I don't think so, but you could use INTO OUTFILE -- MySQL General Mailing List For lis

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 w