johnsmith153 Posted July 8, 2011 Share Posted July 8, 2011 DELETE FROM $table WHERE a=1 LIMIT 3 ... or something like this where it deletes a maximum number of records (3 in this case). Thanks. Link to comment https://forums.phpfreaks.com/topic/241427-so-simple-can-i-do-this-delete-from-table-where-a1-limit-3/ Share on other sites More sharing options...
The Little Guy Posted July 8, 2011 Share Posted July 8, 2011 Yes you can. http://dev.mysql.com/doc/refman/5.0/en/delete.html Link to comment https://forums.phpfreaks.com/topic/241427-so-simple-can-i-do-this-delete-from-table-where-a1-limit-3/#findComment-1240176 Share on other sites More sharing options...
fenway Posted July 10, 2011 Share Posted July 10, 2011 But truthfully, using a LIMIT with an ORDER BY is not likely what you mean. Link to comment https://forums.phpfreaks.com/topic/241427-so-simple-can-i-do-this-delete-from-table-where-a1-limit-3/#findComment-1240841 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.