Poonam Bhatt Poonam Bhatt - 7 months ago 13
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

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

Answer

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.

Examples:

--where="user='jimf'"
-w"userid>1"
-w"userid<1"