sql question...

[firewire2001]

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

[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

[firewire2001]

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..

[cleo]

Did it work?

I do a fair bit of PHP/MySQL, although nothing as intense as the stuff kishba does. My personal blog site is dynamic (http://www.dalqe.com). The first really big site I've done is http://www.pinellasgreens.org .

[jelloshotsrule]

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