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 votes119 views1 answer
Oracle percentage
SQL
3 votes102 views2 answers
Plsql print
SQL
0 vote115 views1 answer
USING THE NOT CONDITION IN SQL
SQL
1 vote97 views1 answer
Mysql get character set
SQL
0 vote92 views1 answer
Sqlite to csv statement
SQL
0 vote92 views1 answer
Import sql mysql ubuntu
SQL
0 vote110 views1 answer
Mysql changer nom table
SQL
0 vote94 views2 answers
Soql last year
SQL
0 vote59 views1 answer
How to get last client id sql
SQL
0 vote101 views1 answer
Postgres populate table from another table
SQL