Re: Mysql -e "Select" Fields Enclosed By and NULL values

2006-10-27 Thread Ow Mun Heng
On Fri, 2006-10-27 at 11:16 -0500, Gerald L. Clark wrote: > Ow Mun Heng wrote: > > Hi, > > > > I'm trying to load some data from a primary MySQL DB into a VMware image > > for R&D purposes. > > Instead of doing a mysqldump of nearly 10G of data, I would like to just > > select a subset of it and l

Re: Mysql -e "Select" Fields Enclosed By and NULL values

2006-10-27 Thread Gerald L. Clark
Ow Mun Heng wrote: Hi, I'm trying to load some data from a primary MySQL DB into a VMware image for R&D purposes. Instead of doing a mysqldump of nearly 10G of data, I would like to just select a subset of it and load it into the VMware image. man mysqldump You will find it supports a where c

Mysql -e "Select" Fields Enclosed By and NULL values

2006-10-27 Thread Ow Mun Heng
Hi, I'm trying to load some data from a primary MySQL DB into a VMware image for R&D purposes. Instead of doing a mysqldump of nearly 10G of data, I would like to just select a subset of it and load it into the VMware image. I'm facing a snag with regard to NULL values. I've tried doing $mysql