How to clear data from a certain column without deleting it in mysql

Question

How do I clear data from a column and then set the first value as 1 with auto increment? I do not want to delete the column, merely to reset it.

edit: This is for my mysql database

The easiest is creating a new column that is auto incremented. Why do u not want to do this? — Steven Feldman, Apr 14 '11 at 04:41
Do you want it so that when u remove a row, their is no gap in the data? — Steven Feldman, Apr 14 '11 at 04:43

score 1 · Answer 1 · answered Apr 14 '11 at 04:42

1

Do not do it.
Auto-increment column is untouchable by design.

If you reset it, you will break your application.

answered Apr 14 '11 at 04:42

Your Common Sense

score 1 · Accepted Answer · answered Apr 14 '11 at 04:43

1

answered Apr 14 '11 at 04:43

zerkms

score -1 · Answer 3 · answered Apr 14 '11 at 04:53

-1

UPDATE TABLE SET col=0;

UPDATE Table AS T1 SET T1.col=1+ (SELECT MAX(T2.COL) FROM TABLE AS T2)

That should do it.

answered Apr 14 '11 at 04:53

Steven Feldman

3 Answers3