Poonam Bhatt Poonam Bhatt - 2 years ago 72
SQL Question

script to dump single record from table in mysql

I want to dump single record from mysql table named as table1 for id = 5.

What is mysql query for same?

I think we can use

but i have used it with full records of table. But how to use it with single record?

Answer Source

if you check at http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html you will find --where option which is the one you need.

Below follows what is stated in that reference:

--where='where_condition', -w 'where_condition'

Dump only rows selected by the given WHERE condition. Quotes around the condition are mandatory if it contains spaces or other characters that are special to your command interpreter.


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download