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

11 votes205 views3 answers
How to get last row of table in sql
SQL
13 votes208 views3 answers
Change data type postgresql
SQL
0 vote206 views1 answer
Sql find record cannot cast date
SQL
7 votes196 views4 answers
What is my mysql version
SQL
0 vote194 views1 answer
Sql tabelle erstellen
SQL
0 vote189 views1 answer
Sql with example
SQL
2 votes337 views1 answer
Tsql copy table
SQL
2 votes212 views2 answers
Sqlalchemy return id after insert
SQL
0 vote227 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote214 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL