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

10 votes200 views4 answers
Inner join in update query mysql
SQL
7 votes275 views2 answers
3rd height salary sql
SQL
13 votes206 views5 answers
Sql default
SQL
2 votes208 views5 answers
Install postgresql 10 centos 7
SQL
0 vote198 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote191 views1 answer
Sqlite referential integrity
SQL
1 vote189 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote203 views1 answer
Clear query cache sql server
SQL
0 vote192 views1 answer
Timestamp(0) postgresql
SQL
0 vote194 views1 answer
Mysql date only no time
SQL