restart

[vegnadragon]

OK, what i want to do is insert some tables to my database, however the purpose of the database is to keep creating and deleting some information, i'll set a ID for a key and auto_increment, but how can i restart and tell mysql to restart back from one once it has reached its limit?

[fenway]

TRUNCATE TABLE if you really want to delete everything; otherwise, don't.

[aschk]

What is this "limit" you're planning on imposing on it? Date, number of rows, some other constraint?

Part of the appeal of databases is the ability to record information over time, and hence track how records change, or differ when new ones are added. Why would you want to delete information?

[vegnadragon]

Let's say i have a table with a ID (which contain primary key and auto_increment) and the column is set to have a int of 1 space for example. So the last value would be 9, so after 9 i wanted to return to id 1 and keep going until it reached 9 again, i never went over the value limit so i don't know what happens.

[fenway]

The last value wouldn't be 9... whatever.

 

Why do you want to do this?

[vegnadragon]

i am making a mini web game, and it is heavily influenced by time, i want to have a set amount of slots to implement some values that i can access once the time is gone. I also want to delete the values once the time is reached and insert another value.

[kenchucky]

Is there any reason that TRUNCATE TABLE will not work for you?

[fenway]

i am making a mini web game, and it is heavily influenced by time, i want to have a set amount of slots to implement some values that i can access once the time is gone. I also want to delete the values once the time is reached and insert another value.

You can deal with time-based constraints differently....