Update a all instanced of a field to default value.

[crimsonmoon]

Is there a statement or way in MySQL to update a several fields in a database to the default value? Basically reseting the value with out deleting it.

I can go through an manually do that by looking at the number and manually setting it to that but it would be easier to just say:

Update table set field=default

That didn't work but that's what I'm trying to do.

While at it is there any easy way to do it with PHPMYADMIN which is what I manage my DB's with.

Thx

[fenway]

You can simply issue a MODIFY COLUMN as part of an alter statement, and change the default that way.