Insert current date in mysql

Mysql insert value date

UPDATE personal set birthday = STR_TO_DATE('1-01-2012', '%d-%m-%Y') where birthday IS NULL;

Source: stackoverflow.com

Insert current date in mysql

INSERT INTO my_table (last_updated) VALUES(NOW());
INSERT INTO my_table (last_updated) VALUES(sysdate);	-- Oracle
INSERT INTO my_table (last_updated) VALUES(getdate());	-- SQL Server

Similar codes

0 vote126 views1 answer
Clone table structure mysql
SQL
0 vote141 views1 answer
Get server date mysql
SQL
-1 vote165 views1 answer
Search all sql tables for a value
SQL
0 vote251 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
2 votes127 views2 answers
Oracle create table if not exists
SQL
0 vote141 views1 answer
How to save data in database in mysql node
SQL
0 vote143 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
11 votes129 views1 answer
Oracle view ddl
SQL
3 votes160 views1 answer
Define REGEXP?
SQL
0 vote129 views2 answers
Sqlite
SQL