Thank you. It worked. Rinku --- Jonathan Haddad <jhaddad@xxxxxxxxxxxxxxxxx> wrote: > I believe the data type needs to be int - unless > mysql interprets > auto_increment as a int automatically. > > Here's an example from mysql.com > > > CREATE TABLE animals ( > id MEDIUMINT NOT NULL AUTO_INCREMENT, > name CHAR(30) NOT NULL, > PRIMARY KEY (id) > ); > Enjoy. > > Jon > > On Jun 27, 2004, at 8:25 AM, Daniel Clark wrote: > > > Yes there is an auto increment field in mySQL and > most other databases. > > > >>> Can any of you guide me how to do auto > increament in a field? > >>> I think there is one datatype for auto > increament. > >>> But I dont know how to do it ? > >>> > >>> Rinku > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > > > > > > __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php