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 vote310 views1 answer
Assign value to var in SQL
SQL
8 votes302 views1 answer
Oracle all_source package body
SQL
0 vote313 views1 answer
Mysql make date from 2 column
SQL
0 vote308 views1 answer
Linebreak sql
SQL
0 vote320 views1 answer
Copy data from one postgres container to another
SQL
0 vote313 views1 answer
Mysql sql.gz
SQL
2 votes329 views2 answers
Get all tables using like
SQL
-1 vote313 views5 answers
Online sql to linq generator
SQL
1 vote292 views1 answer
Sql myisam vs innodb
SQL
16 votes313 views2 answers
Add column if not exists mysql
SQL