Ken,
Check out DAYOFMONTH() and MONTH() and a wealth of other useful date
functions. RTFM: 6.3.4 Date and Time Functions
The answer to your question about AUTO_INCREMENT 'reset' can be found at
6.5.3 CREATE TABLE Syntax under "table_options".
Regards,
=dn
> I have a test table with the ususal customer information in it along
with a
> field for the date of birth. I'm trying to return records of any
customers
> whose birthdates are the same day and month as the current date.
> Here's the query & result:
> mysql> SELECT * FROM Cinfo WHERE BirthDate = "date('m d')";
> Empty set (0.00 sec)
> Here's what is returned with a global query:
> mysql> select * from Cinfo;
>
+-----------+----------+-------------------+---------+-------+--------+-
-------------+--------------+--------------+------------+----+
> | FirstName | LastName | Address | City | State | Zip
|
> HomePhone | WorkPhone | CellPhone | BirthDate | id |
>
+-----------+----------+-------------------+---------+-------+--------+-
-------------+--------------+--------------+------------+----+
> | Joe | Blow | 1200 High St. #12 | St.Looy | UT | 844110
|
> 801-111-2299 | 801-111-3456 | 801-213-8956 | 1959-03-01 | 1 |
> | | | | | |
|
> | | | | 2 |
> | | | | | |
|
> | | | | 3 |
> | | | | | |
|
> | | | | 4 |
>
+-----------+----------+-------------------+---------+-------+--------+-
-------------+--------------+--------------+------------+----+
> 4 rows in set (0.00 sec)
>
> I have a feeling it's the date format in the table. I tried making it
a date
> field but just got the current date. What am I doing wrong?
> Off Topic, I saw something about resetting the auto-increment
counter, but
> now I can't find reference to it. Can some kind soul enlighten me???
> --
>
>
> 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
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
