Several ways to add timestamps in MySQL tables
|
Scenario: The data in a table needs to be synchronized to other databases using a synchronization tool, and the update_time timestamp field is required for incremental synchronization. Solution: alter table quant_stk_calc_d_wxcp add update_time timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: Implementation of webpack-dev-server to build a local server
>>: Tutorial on installing DAMO database on Centos7
Recommend
LinkedIn revamps to simplify website browsing
Business social networking site LinkedIn recently...
HTML meta viewport attribute detailed description
What is a Viewport Mobile browsers place web pages...
MySQL import and export backup details
Table of contents 1. Detailed explanation of MySQ...
Detailed explanation of the practice of installing the Permeate range system using VMware
1. Background We do some internal training from t...
Promise encapsulation wx.request method
The previous article introduced the implementatio...
How to use docker+devpi to build local pypi source
Some time ago, I needed to use pip downloads freq...
Introduction to ApplicationHost.config (IIS storage configuration area file)
For a newly created website, take ASP.NET MVC5 as...
A complete guide to the Docker command line (18 things you have to know)
Preface A Docker image consists of a Dockerfile a...
Win32 MySQL 5.7.27 installation and configuration method graphic tutorial
The installation tutorial of MySQL 5.7.27 is reco...
Web front-end development CSS related team collaboration
The front-end development department is growing, ...
Detailed explanation of the simple use of MySQL query cache
Table of contents 1. Implementation process of qu...
The latest mysql-5.7.21 installation and configuration method
1. Unzip the downloaded MySQL compressed package ...
JavaScript method to detect the type of file
Table of contents 1. How to view the binary data ...
Detailed explanation of the English names corresponding to the font-family of Chinese fonts in CSS styles
Songti: SimSun Bold: SimHei Microsoft YaHei: Micr...
Detailed explanation of the order of JS object traversal
Some of you may have heard that the order of trav...