본문 바로가기
카테고리 없음

sql timestamp create

by yenua 2022. 12. 4.
반응형

https://stackoverflow.com/questions/34418077/how-to-create-mysql-table-with-column-timestamp-default-current-date

 

How to create mysql table with column timestamp default current_date?

I need to create mysql table with default value on column CURRENT_DATE() I try DROP TABLE IF EXISTS `visitors`; CREATE TABLE `visitors` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `ip`

stackoverflow.com

 

 `date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP

 

반응형