Mysql - Dump sql table from specified value, Dump Particular range of values from table in Sql

Dump sql table from specified value

Normally we would have dumped entire mysql table whenever required, sometime we might have a need to take a backup or copy the specified range of vales from one mysql table to other using table, In such case here is simple sql to dump particular range of values into a sql file

 
 SELECT * FROM techbluff LIMIT 1001, 10000 INTO OUTFILE '/home/techbluff/dump_range.sql'

will result a file named dump_range.sql in the given path with values from 1001 to 10000 from table techbluff

The topic on Mysql - Dump sql table from specified value is posted by - Math

Hope you have enjoyed, Mysql - Dump sql table from specified valueThanks for your time