SQL set Table to Default Values

[Monk3h]

Im currently working on a reset script that will reset every feild in the players table to tthere default Value.

 

My original plan was to use.

 

		mysql_query("update players set feild=defaultvalue");

 

And make one of them for every single feild in the table.

 

 

Is there a faster way too do this? a built in value that sets a table back to its default values maybie?

[.josh]

I'm not anywhere expert in mysql but I suppose you could like, go into phpmyadmin and get the db to dump the query that creates the table (with the defaults), then in your reset script, you could like, drop the table and recreate it with that query. 

 

I'm going to move your thread over to the sql section they would know if there's a better alternative.

[Barand]

You don't need a separate query for each field. EG

UPDATE players SET
    col1 = 0,
    col2 = 0,
    col3 = '',
    col4 = 0