On Saturday 02 March 2002 16:13, DL Neil wrote: > Ken, > > Check out DAYOFMONTH() and MONTH() and a wealth of other useful date > functions. RTFM: 6.3.4 Date and Time Functions
There's a few interesting items here OK, Thanks for the pointer. > The answer to your question about AUTO_INCREMENT 'reset' can be found at > 6.5.3 CREATE TABLE Syntax under "table_options". ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ EH? It says what?? I'm so green that this makes NO sense at all. Regards,table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM } or AUTO_INCREMENT = # > =dn -- Ken Thompson, North West Antique Autos Payette, Idaho Email: [EMAIL PROTECTED] http://www.nwaa.com Sales and brokering of antique autos and parts. Linux- Coming Soon To A Desktop Near You Registered Linux User #183936 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php