export data as sql inserts

hi list I was just wondering - does anyone have or know of a sql or php script for exporting a table's data as a whole bunch of INSERT statements? cheers Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED

RE: export data as sql inserts

perfect! thanks Manoj > -Original Message- > From: ManojW [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 2 August 2005 10:01 AM > To: Rob Agar; mysql@lists.mysql.com > Subject: Re: export data as sql inserts > > > mysqldump is your friend. > > Man

RE: Can't figure out how to get it running

hi Joe, You might be more comfortable using a GUI admin tool - look for MySql Administrator under Graphical Clients here http://dev.mysql.com/downloads/ Also, I *believe* php no longer ships with mysql support enabled. Make sure your php.ini file contains this line: extension=php_mysql.dll

RE: MySQL Query Browser

hi Scott > How do I run more than 1 queries in MySQL Query Browser? The only way I've found is to put the queries in a .sql file and load it via File > Open Script. It doesn't accept multiple typed in queries, even if they are separated by semicolons. hth Rob -- MySQL General Mailing List

does show create table work?

hi! Does SHOW CREATE TABLE x actually work? When I try it I just get error 1064 (you have an error in your sql syntax near 'CREATE TABLE x') (version 3.22.32 on linux) ta, Rob Agar - Before posting, please chec

Re: does show create table work?

fair enough. thanks! Rob - Original Message - From: "Andrew Schmidt" <[EMAIL PROTECTED]> To: "Rob Agar" <[EMAIL PROTECTED]>; "Mailinglist MySQL COM" <[EMAIL PROTECTED]> Sent: Wednesday, June 06, 2001 7:02 PM Subject: Re: does show create