RE: [PHP] max unique number
| From: | Philip Hallstrom | Date: | Tue, 07 Mar 2006 17:38:11 +0000 |
| Subject: | RE: [PHP] max unique number | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-231608@lists.php.net to get a copy of this message | ||
[snip] How do i get a unique max number from a mysql table column? [/snip] SELECT MAX(number) FROM table LIMIT 1;That might not be unique though... I'm wondering if the original poster is looking for AUTO_INCREMENT (ie. sequences) to ensure a unique id to use for insertion...?