Shulou(Shulou.com)06/01 Report--

This article mainly introduces the Python operation MySQL how to create time, update time, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Creation time, update time

DEFAULT CURRENT_TIMESTAMP-- means that when data is inserted, the default value of the field is the current time ON UPDATE CURRENT_TIMESTAMP-- means that every time the data is updated, the field will be updated to the current time

These two operations are maintained by the mysql database itself, and the creation time and update time fields can be generated based on this feature, and no code is required to maintain them.

CREATE TABLE `test` (`update_ time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'creation time', `update_ time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time') ENGINE=InnoDB DEFAULT CHARSET=utf8 Thank you for reading this article carefully. I hope the article "how to create time and update time for Python operation MySQL" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.