how to insert date in mysql table
- by mithun1538
Hello everyone,
I have a mysql table called pollOfTheWeek. It has a column "pollDate" of type date. I have two questions regarding this :
1. I declared the column while creating the table as [pollDate date] What I wanted is that this column be set automatically, when the user doesnt enter any value for this column. How do i declare the column to achieve this?
Assuming that I have the same declaration as above, how do I enter an empty value. I mean if the column was of type varchar, I would enter empty value as " ". But since it is of type date, I get error when I enter the value as " ". How do I enter empty value for the pollDate column?
