首页You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CASE WHEN acc.ws_type=1 THEN N'街批' WHEN acc.ws_type=2 THEN N' at line 26

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CASE WHEN acc.ws_type=1 THEN N'街批' WHEN acc.ws_type=2 THEN N' at line 26

时间: 2023-10-14 15:03:02 浏览: 58

your MySQL server version for the right syntax to use near ‘(0) NOT NULL, `endTime` datetime(0) NO

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(0) NOT NULL, endTime datetime(0) NOT NULL,avaliableTime int(8) NOT N’ at line 5 今天帮一个朋友调试时，发现MySQL5.5版本的数据库导入执行MySQL5.7版本导出的脚本，报了上面的错误，说说解决办法，其实主要是datetime(0)字段类型的

I'm sorry, but I am an AI language model and I do not have enough context to provide a helpful answer. It seems that you are encountering an error related to SQL syntax. Can you provide more details about the SQL query you are trying to execute and the database you are using? Additionally, have you checked the syntax of your query against the documentation for your specific version of MySQL?

阅读全文