Mysql - Dump sql table from specified value, Dump Particular range of values from table in Sql
Dump sql table from specified valueNormally 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