Dear Kevin,
mysqldump -w
or something like
SELECT * FROM my_table INTO OUTFILE my_dumpfile WHERE my_id BETWEEN 100
AND 500
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# 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 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'
> -or-
> --where='where_clause'.
>
> Of course, 'where_clause' would be something like 'id<200' or
whatever's
> appropriate.
>
> It's on page 620 of 'MySQL' by Paul DuBois (New Riders). Invaluable
book,
> btw.
>
> Jay Fesco
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php