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

2 votes131 views1 answer
Express api ith mysql data
SQL
3 votes137 views1 answer
Sql multi column index performance
SQL
2 votes140 views2 answers
Mysql does sentence contain word
SQL
1 vote141 views1 answer
Sqlite3 read only
SQL
0 vote138 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
3 votes138 views1 answer
Insert into table from another table mysql
SQL
0 vote187 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote136 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote138 views1 answer
Reset keys in sql
SQL
1 vote117 views1 answer
Set statistics on in ssms
SQL