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 vote354 views1 answer
Convert excel into sqllite db using python
SQL
0 vote320 views1 answer
Backup a table in sql
SQL
3 votes374 views3 answers
Mysql declare variable
SQL
6 votes353 views1 answer
Oracle pl sql source
SQL
0 vote334 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote342 views1 answer
What is between keyword used for
SQL
1 vote344 views1 answer
Convert varchar to int in sqlite
SQL
8 votes380 views1 answer
See all users mysql
SQL
10 votes345 views4 answers
How to alter table name in mysql
SQL
0 vote347 views1 answer
Sql alchemy escape ; in insert statement
SQL