web123456

Setting mysql's datetime default to CURRENT_TIMESTAMP with Navicat

Read a lot, tried a lot of methods finally succeeded here. I will talk about the operation process below:

1. New table:

2、After entering your database tables.Tap the SQL preview in the upper right corner to copy its SQL statement

 

3. Don't save, close

 

4, select the database you want to query, click on the query, the new query

 

5. Put the one you just copiedSQL statementpaste (as in "copy and paste")go in

6. The final modified results are as follows

 

7. Click Run in the upper left corner.The modification was successful.

I hope this blog helps someone who needs it!