Insert a date field in MySQL

In queries in the SQL language for MySQL, the dates in date type fields must be expressed in quotes. This is: insert into table (date) values ​​(‘1995-01-29’) The date field in the above SQL query is assumed to be a MySQL date field. You could also have expressed the date in double quotes.

See also  Operators and Operands
Loading Facebook Comments ...
Loading Disqus Comments ...