Subscribe

MySQL Update Table Limit Rows

Dec 9, 2008
Examples

Updating a block of rows in MySQL can be accompished by using the “limit” function:

update TABLE_NAME set COLUMN_NAME=VALUE limit MAX;

E.g.

update products set state=false limit 10;
No Comments
Tags

Leave a Reply

Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>