How to use mysqldump for a SELECT statement?

How to use mysqldump for a SELECT statement?

am 14.07.2006 19:02:01 von laredotornado

Hi,

I have a table but I only want to export rows subject to certain
criteria. The table is

ACCOUNTS
___________
USER_ID
USERNAME
PASSWORD
COMPANY_ID

I only want to export rows with COMPANY_ID = 5. By "export rows", I
mean dump the proper SQL INSERT statements containing the data.

Thanks for any help, - Dave