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

22 votes135 views3 answers
Sql cheat sheet
SQL
0 vote141 views1 answer
Multiple like values for single column postgres
SQL
2 votes109 views1 answer
Sql server case sensitive search
SQL
3 votes97 views2 answers
Mysql add 2 hours
SQL
0 vote124 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
4 votes100 views2 answers
Sql server date now
SQL
5 votes123 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote136 views1 answer
Get total and distict row diff in sql
SQL
0 vote107 views1 answer
Xampp increame mysql speed
SQL
0 vote102 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL