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

5 votes246 views1 answer
Oracle asynchronous query
SQL
0 vote245 views2 answers
Postgresql get long running queries
SQL
1 vote270 views1 answer
Cross schema query oracle 2 users
SQL
0 vote243 views1 answer
Back up stored procedures mysql
SQL
0 vote259 views2 answers
How to combine diff colmun value using group by postgres
SQL
15 votes271 views2 answers
Select where duplicate mysql
SQL
4 votes262 views1 answer
Id increment ms sql server
SQL
1 vote255 views1 answer
Oracle check table space
SQL
4 votes289 views1 answer
Rename stored procedure in sql server
SQL
0 vote247 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL