MySQL 的噩梦
编程和浪费在愚蠢的事情上的时间永远让我感到惊讶。我正在尝试导入一个 .sql 文件，该文件具有我的网站的数据库结构。这只是对开发过程中的内容的更新。
问题是，MySQL 似乎有一种神奇的力量，可以记住已删除的行。下面的最后一行已被删除，但是我从 MySQL 收到一条错误，指出该行的语法错误。我怎样才能得到一条不再存在的行的错误？我什至重新启动以确保内存中没有任何内容，但同样的事情。它神奇地认为这条线仍然存在。
我正在使用类似于 PHPMYADMIN 的程序来输入文件。
`techspecial` text NOT NULL, `statuscode` varchar(25) NOT NULL, `tech` varchar(50) NOT NULL, ) ENGINE=MyISAM DEFAULT CHARSET=latin1
任何帮助都会受到赞赏，因为这只是浪费宝贵的时间。
Programming and the time wasted on stupid things never ceases to amaze me. I am trying to import an .sql file which has the DB structure for my site. This is just an update to what is there while developing.
Problem is, MySQL seem to have a magical power that remembers deleted lines. The last line below has been deleted, however I get an error from MySQL saying the syntax is wrong for this line. How can I get an error for a line that doesn't even exist anymore? I have even rebooted to make sure nothing was hanging around in memory somewhere, but same thing. It magically thinks this line still exists.
I am using a program similar to PHPMYADMIN to input file.
`techspecial` text NOT NULL, `statuscode` varchar(25) NOT NULL, `tech` varchar(50) NOT NULL, ) ENGINE=MyISAM DEFAULT CHARSET=latin1
Any help is appreciated as this is just such a waste of valuable time.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
sql 的语法错误，请注意额外的
,由于缺少行，请添加回缺少的行
或替换为：
the sql is with wrong syntax, take note on an extra
,due to missing the line(s)add back your missing line(s)
OR replace to :
您是否尝试过复制粘贴查询内容并直接将其作为 SQL 查询执行？它应该可以工作..如果你仍然有错误，那么问题不是你的mysql..尝试给我们错误消息和涉及的行。
祝你好运！
have you tried to copy-paste the content of the query and execute it directly as a SQL query?? it should work.. if you still have a error then the problem is not your mysql.. try giving us the error message and the lines involved.
good luck!