This article will introduce to you the solution to the problem of "check the manual that" when running a SQL file. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.
#I will use "MySQL workspace workspace8.0" later. Run the SQL file. If you encounter an error, there will be a red underline prompt. It is found: (There is a problem with the time of the SQL file)
It is not the insert statement that is wrong, nor the create There is a problem with the creation, but there is a problem with the time type. Whether it is datetime or time, the Navicat premium tool dumps the structure of the data table, and the time will be followed by "(0)"!!!
Change:
Replace all datetime(0) with datetime or time(0) [As shown in the figure, manually modify in xx.sql]:
Related recommendations: "
mysql tutorial"
The above is the detailed content of Why does "check the manual that" appear when MySQL runs a SQL file?. For more information, please follow other related articles on the PHP Chinese website!
