Answers for "add date column in mysql"

SQL
1

how to add timestamp column in mysql

ALTER TABLE `table1` ADD `lastUpdated` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ;
Posted by: Guest on September-24-2020
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

Code answers related to "SQL"

Browse Popular Code Answers by Language