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 vote241 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote146 views1 answer
Oracle select invalid views
SQL
3 votes151 views1 answer
Create a table with an id in mysql
SQL
0 vote140 views1 answer
Is numeric in sql
SQL
0 vote146 views1 answer
Oracle gather table statistics
SQL
0 vote150 views1 answer
Sql pivot without aggregate
SQL
0 vote145 views1 answer
Mysql create table columns with spaces
SQL
0 vote142 views1 answer
Oracle for loop on list
SQL
6 votes170 views2 answers
Difference between join vs union
SQL
0 vote158 views1 answer
Mysql page segment
SQL