How do I set a default value for ENUM fields in PHP?

You do this the same way as you would set a default for any field, here is what you need to write in your code for the field definition when creating your table:

myfieldname ENUM('option1','option2') default 'option2'

Comment on this Question and Answer >>>

ASK A QUESTION

More mysql PHP Questions

I am unable to make pages for my search result.Below I am giving the code that I am using. Career Search result Yami says

How do I return a random row from the database?

the code is running well without errors but y is it that three of the columns in the table do not insert data?

How do I access the current time with mysql?

How do I group the results of a mysql query?