auto increment reset

[ketanco]

Two basic questions:

1-When you delete all the data in a table...Does the auto increment id column start from 1 again?

2-How can you change a column's cell format to be able to contain both text and/or number (and what is it called) from integer only? If so how? And does this affect the data already inside?

Thanks

[skywalker2208]

Two basic questions:

1-When you delete all the data in a table...Does the auto increment id column start from 1 again? I think you can do this by truncating the table. Info on truncate table. (http://dev.mysql.com/doc/refman/5.0/en/truncate.html)

2-How can you change a column's cell format to be able to contain both text and/or number (and what is it called) from integer only? If so how? And does this affect the data already inside?I think you will have to use a text type and you use the alter command to change a columns definition. Alter Info (http://dev.mysql.com/doc/refman/5.0/en/alter-table.html) A text type can have integers or text it, but in the end the number is a text. The type of text type will depend on how large the text or number can be. Data Type List (http://www.htmlite.com/mysql003.php)

Thanks
Answers are above with links also.