UPDATE

[mforan]

is there a way to UPDATE table name SET then default value in the database? like name = the default value in db?

[Mchl]

I guess it is... you'd have to get the default value from table definition first using DESCRIBE `table`

 

http://dev.mysql.com/doc/refman/5.1/en/describe.html

[mforan]

so theres no way to just update the database without first selecting the database default values in a prior mysql command?

that seems kinda stupid really, what if you have 100's of columns?

[Mchl]

Why would you want to update 100s of columns to default values?

 

Why would you HAVE 100s of columns in the first place?

[mforan]

lol i have 108 columns in my database and growing.

 

as for this, belive it or not, this works:

UPDATE tablename SET name ='DEFAULT';

 

 

somethings are so simple minded >_< lolz

[Mchl]

I think it should be without qoutes. With qoutes it sets the value to literal string.

 

UPDATE tablename SET name = DEFAULT;

 

Other than that: cool! Didn't know that.

 

Having 100 or more columns within one table suggests that your database design is not normalised. Maybe you should review it?