vendredi 8 mai 2015

MySQL dump --where="1 limit 2, 3", 1 means what?

mysqldump -uroot --opt --where="1 limit 2, 3" dbname --no-create-info > bk.sql

I use this command to dump partial data of database or dump large database to multiple files and it works well.

As I tested,

2 means skip first 2 recoreds,

and 3 means dump 3 records,

but I don't understand 1 means what in --where="1 limit 2, 3"?

Aucun commentaire:

Enregistrer un commentaire