Home  >  Article  >  Database  >  MySql不同版本对表名大小写敏感!_MySQL

MySql不同版本对表名大小写敏感!_MySQL

WBOY
WBOYOriginal
2016-06-01 13:48:19900browse

bitsCN.com

本同测试一切正常,将数据库移至服务器后却报错了,看日志居然不存在表名。

复制语句执行后也提示表不存在,表名改成小写后,查询OK。

看了下数据库版本:select version();

本机显示:5.5.20,服务器显示:5.1.52

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn