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

2 votes399 views3 answers
Mysql pass command from command line
SQL
0 vote360 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote370 views1 answer
Oracle dynamic select into
SQL
1 vote337 views1 answer
Metada in sql
SQL
1 vote359 views1 answer
Float precision in psql
SQL
1 vote373 views1 answer
Sql where last 12 months
SQL
4 votes310 views1 answer
And or sql order of operations
SQL
0 vote349 views1 answer
Oracle procedure teamplate
SQL
0 vote333 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
23 votes405 views5 answers
Sql substring
SQL