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 vote189 views1 answer
Reset keys in sql
SQL
0 vote195 views1 answer
Running mysql from bash sc
SQL
1 vote180 views1 answer
Show per page table in xampp
SQL
0 vote183 views1 answer
How to to get current date in sql
SQL
0 vote179 views1 answer
Basic structure of sql expression having clause
SQL
0 vote299 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote208 views1 answer
Sql date time query find
SQL
0 vote220 views1 answer
Snowflake drop column
SQL
0 vote222 views1 answer
Jpa generationtype sequence mysql
SQL
3 votes174 views1 answer
Postgres update column with value from another table
SQL