sql question...

firewire2001

macrumors 6502a
Original poster
Apr 2, 2002
718
0
Hong Kong
hey..

i was wondering if anyone knew if it is possible to reset an auto_incrementing variable in an sql table..

and if so, how...?

your help would be greatly appreciated...

-f
 

firewire2001

macrumors 6502a
Original poster
Apr 2, 2002
718
0
Hong Kong
Originally posted by cleo
From the MySQL manual user-contributed notes:

ALTER TABLE tbl_name AUTO_INCREMENT = 1

Lemme know if it works.

http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
funny you say that... i found that right after i made my post.. perhaps i should have deleted it.. :-/

thanks a lot anyways.. do you do much php stuff..?

i was like really daunted by it a few weeks ago and decided to take it up again about a week ago.. and ive learned probably 3/4 of it now.. its really a great language.. it seems like a lot of the stuff on the web has come together for me since learning it..
 

jelloshotsrule

macrumors G3
Feb 7, 2002
9,591
3
serendipity
hey cleo- i really like that greens site... not just cause it's green either... the design is really good (speaking more graphically than web design, though that seems good too!)

word up