Mysql notes

  • insert_id will return 0 after an INSERT IGNORE if there is a collision.
  • MySQL 4 has bad transaction support. For COMMIT/ROLLBACK use MySQL 5 + InnoDB.
  • Limiting queries :
mysql -D edos-debian -u edos-debian -p --select-limit 50 --safe-updates
Version 1.5 last modified by Berke on 21/03/2006 at 16:10

Comments 0

No comments for this document

Attachments 0

No attachments for this document

Creator: Berke on 2006/01/11 11:14
Copyright EDOS Consortium
1.1.1