Answers for "insert date value in mysql"

SQL
2

mysql insert value date

UPDATE personal set birthday = STR_TO_DATE('1-01-2012', '%d-%m-%Y') where birthday IS NULL;
Posted by: Guest on July-08-2021
2

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
Posted by: Guest on April-05-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language