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

1 vote246 views1 answer
Oracle enable job
SQL
1 vote246 views1 answer
Sql server list locks
SQL
1 vote230 views1 answer
Oracle explain plan
SQL
3 votes256 views2 answers
Sqlite show table structure
SQL
0 vote250 views1 answer
Selecting all columns from table sql database
SQL
56 votes413 views5 answers
Psql create user
SQL
0 vote249 views1 answer
Alter table change default
SQL
0 vote290 views1 answer
How to check foreign key constraint in sql
SQL
0 vote233 views1 answer
Mysql terminal list table
SQL
0 vote232 views1 answer
How to connect postgresql database with java
SQL