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 vote215 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote205 views1 answer
Login phpmyadmin without password
SQL
0 vote213 views1 answer
Convert rows into columns in oracle
SQL
0 vote221 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote256 views2 answers
Laravel jwt generate token
SQL
1 vote222 views1 answer
Setval pgsql
SQL
0 vote219 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote242 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
3 votes222 views2 answers
Mysql import gz
SQL
9 votes202 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL