cancer10 47 Posting Whiz in Training

Hello,

If you have used phpmyadmin, you might have noticed while creating a table there are few optional fields asked by phpmyadmin along with the table name

like

tablename | Datatype | Length | Default etc etc


Not my question is how do you make use of this Default field?

I know it puts a value when inserting a data into the mysql database, but suppose I have a table with some values into it, can I restore the default value in my table with the current values?

if yes how?

Plz Help,

Thanx