Re: export data as sql inserts

2005-08-01 Thread Peter Brawley 

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?


phpMyAdmin will generate that script for you.

PB


 




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005


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

2005-08-01 Thread Rob Agar 
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.
> 
> Manoj
> 
> - Original Message - 
> From: "Rob Agar" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, August 02, 2005 8:53 AM
> Subject: 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/mysql?> [EMAIL PROTECTED]
> > 
> 


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

2005-08-01 Thread ManojW 
mysqldump is your friend.

Manoj

- Original Message - 
From: "Rob Agar" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, August 02, 2005 8:53 AM
Subject: 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]
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

export data as sql inserts

2005-08-01 Thread Rob Agar 
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]