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 vote106 views1 answer
Sql server reseed single table
SQL
0 vote125 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote134 views1 answer
Snowflake drop column
SQL
0 vote112 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
9 votes112 views4 answers
Add primary key to existing table sql
SQL
0 vote118 views1 answer
Select last N rows mysql
SQL
0 vote117 views1 answer
Get only one row in mysql
SQL
0 vote123 views1 answer
Mysql page segment
SQL
1 vote131 views1 answer
Sql select max value from multiple rows
SQL
0 vote112 views1 answer
Sql grant select only
SQL