How to Delete Low Priority in MySQL

Using the Delete Low Priority query in MySQL enables programmers to delete the desired records from a table without consuming much CPU resources. This query can take longer to complete, in comparison with the Delete From query because it deletes rows individually and pauses if other users are reading from the table in which you are executing the query. You can ignore errors during the deletion process by adding additional commands to Delete Low Priority. Proper syntax must be followed.

Instructions

1. Log in to your database system using the proper MySQL user name and password.

2. Enter the following command after allowing for the "mysql>" prompt displays:

   DELETE LOW_PRIORITY FROM table_name

   WHERE where_condition

   LIMIT row_count

3. Enter the following command if you wish to ignore errors during the delete process:

   DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM table_name

   WHERE where_condition

   LIMIT row_count

References

• Programmers Help: Delete Syntax
• MySQL: Delete Syntax
• Java 2s: Using Delete Low_Priority Command