[Q] about AUTO_INCREMENT...

When using AUTO_INCREMENT, is there a way to set the starting value. Thanks, Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FW: Relationships in Mysql

I am a newbie to db. I have a few tables, one that I define the primary key. CREATE TABLE member ( memid INT(6) UNSIGNED ZEROFILL DEFAULT '002000' NOT NULL AUTO_INCREMENT, last VARCHAR(20) DEFAULT '' NOT NULL, first VARCHAR(20) DEFAULT '

Re: FW: Relationships in Mysql

n one go. > > Best regards > > Nils Valentin > Tokyo/Japan > > > 2003年 7月 26日 土曜日 05:20、Write a Friend さんは書きました: > > I am a newbie to db. > > > > I have a few tables, one that I define the primary key. > > > > CREATE TABLE member ( > >

Re: [Q] about AUTO_INCREMENT...

Thanks, Carlos > > Write a Friend said: > > When using AUTO_INCREMENT, is there a way to set the starting > > value. > > > > Thanks, > > Carlos > Alter Table TABLENAME AUTO_INCREMENT=1 > > where TABLENAME is your table. > > Of course th