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

3 votes328 views6 answers
DB::table('users')->get();
SQL
2 votes285 views1 answer
Mysql query unique column
SQL
0 vote315 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote278 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote279 views1 answer
Sql string contains case sensitive
SQL
1 vote289 views2 answers
How to check if sql query is correct online
SQL
0 vote294 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote271 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote287 views1 answer
Exec procedure oracle
SQL
0 vote284 views1 answer
Sql server port 1434
SQL