Hello!

In my GUI for Mysql there is a command "emty" that delete all the rows in current table.

How do I express that in normal syntax?

I dont want to drop the table just delete all the rows.

Regards// D_S

TRUNCATE TABLE TableName

You may also simply do the following:

DELETE FROM [tablename];

Hello,

If I do "DELETE" I will also delete the preferences of that table or?

Regards // D_S

praveenpr, in mysql truncate actually drops and recreates the table

this is very fast but there is a drop involved, which d_s didn't want, for reasons which are not yet clear

d_s, what do you mean by "preferences"?

Hello,

For example "Alter Table"

DS, you still aren't clear. Do you mean you have used Alter Table on this particular table and are worried you will lose any changes you have made? Or do you mean if you run the delete you won't be able to use Alter table in the future?

If you use

DELETE from tablename;

you will delete all the table data, but the schema will still be there for the table itself. You won't change the table in any way other than dropping what is contained in it. You will still be able to alter the table in the future to add new columns etc.

Hello,

You have to excuse me.... I will explain.
I have a table called TEMP which I store temporary data, this table is "ALTERED BY" "playnr".

When I have used my temporary data I want to delete all data in my table "TEMP" but next time data is stored it will be altered by "playnr" again


Regards// D_S

your last description is very confusing

first of all, if the table hangs around, it isn't really temporary, is it

second, what does altered by "playnr" again mean?

what exactly is being altered? are you adding a "playnr" column that wasn't there before?

Hello,

1) The table is static...the information in that table are used once and then I want to set my table as empty.
2) I have predefined colums and...
3) I have a column called "playnr" in my table TEMP (its my "primary key")

I hope this helps..

Thanks again! // D_S

aha, the primary key

no, you'll be fine

TRUNCATE resets auto_increments, but leaves constraints on the table

Hello,

Ok....

Thank you for your help!

Regards // D_S

Yes..
you must use the "TRUNCATE TableName" query.
I'll delete all the data, reset the autoincrements but the structure will be the same.