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 vote178 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote171 views1 answer
Oracle locked objects
SQL
0 vote189 views1 answer
Mysql workbench procedure
SQL
0 vote200 views1 answer
Reindex mssql table
SQL
0 vote213 views1 answer
MySQL get all previous date record
SQL
0 vote189 views1 answer
Mysql check if lowercase
SQL
0 vote177 views1 answer
Mysql where don't have string
SQL
0 vote188 views2 answers
Postgresql gset
SQL
0 vote175 views1 answer
Postgresql like
SQL
11 votes195 views5 answers
Sql server reset identity
SQL