If it finds duplicate-key conflicts, the rows are not updated. This statement is typically used in conjugation with the WHERE. IGNORE: This modifier allows the statement to do not abort the execution even if errors occurred. The UPDATE statement is used to change or modify the existing records in a database table. It takes effects only for the storage engines that use only table-level locking. LOW_PRIORITY: This modifier instructs the statement to delay the UPDATE command's execution until no other clients reading from the table. The UPDATE command supports these modifiers in MySQL:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |