auto_increment by group

by

For MyISAM and BDB tables you can have an auto_increment field as a secondary part of key, e.g.

CREATE TABLE foo (
   id          INT AUTO_INCREMENT NOT NULL,
   group_field INT NOT NULL,
   name        VARCHAR(128),

   PRIMARY KEY(group_field, id)
);

Here’s what the manual says about this

In this case, the generated value for
the AUTO_INCREMENT column is
calculated as
MAX(auto_increment_column) + 1 WHERE
prefix=given-prefix. This is useful
when you want to put data into ordered
groups.

More Related Contents:

  1. How to reset AUTO_INCREMENT in MySQL
  2. How to make MySQL table primary key auto increment with some prefix
  3. How to set initial value and auto increment in MySQL?
  4. Get the new record primary key ID from MySQL insert query?
  5. MySQL AUTO_INCREMENT does not ROLLBACK
  6. Get current AUTO_INCREMENT value for any table
  7. SQL: Creating a Relational table with 2 different auto_increment
  8. How to handle fragmentation of auto_increment ID column in MySQL
  9. Prevent auto increment on MySQL duplicate insert
  10. Add Auto-Increment ID to existing table?
  11. How to fill in the “holes” in auto-increment fields?
  12. How to insert data to MySQL with auto-incremented column(field)?
  13. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  14. How does MySQL Auto Increment work?
  15. Why does MySQL autoincrement increase on failed inserts?
  16. How to force MySQL to take 0 as a valid auto-increment value
  17. Defining Composite Key with Auto Increment in MySQL
  18. mysql Failed to read auto-increment value from storage engine
  19. Too many auto increments with ON DUPLICATE KEY UPDATE
  20. How to reuse auto_increment values? [duplicate]
  21. make an ID in a mysql table auto_increment (after the fact)
  22. Change MySQL default character set to UTF-8 in my.cnf?
  23. MySQL offset infinite rows
  24. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  25. How do write IF ELSE statement in a MySQL query
  26. How do you uninstall MySQL from Mac OS X?
  27. use a variable for table name in mysql sproc
  28. What is the best way to do incremental backups in MySQL?
  29. For homebrew mysql installs, where’s my.cnf?
  30. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?

Leave a Comment