# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: "Jay Fesco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:24 PM
Subject: RE: WANTED: Utility to reverse engineer existing database II
> ...Some of my tables
On 07-Aug-2001 Kevin wrote:
>
> Thanks for pointing out mysqldump.
>
> I now need to be able to copy a limited number of data records. I see that
> mysqldump allows data copy by providing the cooresponding INSERT statements.
> However, I don't always want all of the records. Some of my tables
rom: "Kevin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 5:30 PM
Subject: WANTED: Utility to reverse engineer existing database II
>
> Thanks for pointing out mysqldump.
>
> I now need to be able to copy a limited number of data rec
...Some of my tables have thousands of records and I may only want the first
200 or so. I did not see
an option on mysqldump that would limit the number of records. Any ideas
without writing a program?
Kevin
>
Try the WhereClause option in mysqldump.
Syntax is:
-w 'where_clause
emacs
MJM
- Original Message -
From: "Kevin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 11:30 AM
Subject: WANTED: Utility to reverse engineer existing database II
>
> Thanks for pointing out mysqldump.
>
> I now need t
Did you see the -w, --where option? It might be what you're looking
for...
"Dump only selected records."
--http://www.mysql.com/doc/m/y/mysqldump.html
If you have a more complicated query and you are using Windows, you can
use urSQL + MyODBC to accomplish this as urSQL
(http://www.urbanres
> Thanks for pointing out mysqldump.
>
> I now need to be able to copy a limited number of data records.
> I see that
> mysqldump allows data copy by providing the cooresponding INSERT
> statements.
mysqldump -w
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL
Thanks for pointing out mysqldump.
I now need to be able to copy a limited number of data records. I see that
mysqldump allows data copy by providing the cooresponding INSERT statements.
However, I don't always want all of the records. Some of my tables have
thousands of records and I may only
