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 vote135 views1 answer
Insert or update sql query
SQL
0 vote135 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote162 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote144 views1 answer
Recover deleted data from mysql database
SQL
0 vote187 views1 answer
Store case result sql
SQL
0 vote161 views1 answer
Connecting mySQL to STS
SQL
15 votes140 views1 answer
Mysql int range
SQL
5 votes178 views2 answers
Add days in oracle sql
SQL
0 vote146 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote138 views1 answer
See the structure of a table mysql
SQL