Shulou(Shulou.com)05/31 Report--

Editor to share with you the solution to "check the manual that" when MySQL runs SQL files. I hope you will get something after reading this article. Let's discuss it together.

This article introduces you to the solution to "check the manual that" when running SQL files. There is a certain reference value, friends in need can refer to, hope to help you.

Later, I use "MySQL's workbench workspace8.0" to run the SQL file. If I encounter an error, there will be a red underscore prompt, and I will find that: (there is a problem with the time of the SQL file)

It is not that there is a problem with the insert statement or the creation of create, but that there is a problem with the time type. Whether it is the datetime or time,Navicat premium tool that dumps the structure of the data table, there will be "(0)" after the time!

Change:

Replace all datetime (0) with datetime or time (0) [as shown in xx.sql, manually modify]:

After reading this article, I believe you have a certain understanding of "the solution to" check the manual that "when MySQL runs SQL files. If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.