Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

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

WBOY
Release： 2016-06-01 13:48:19
Original
903 people have browsed it

bitsCN.com

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

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

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

本机显示：5.5.20，服务器显示：5.1.52

bitsCN.com
Related labels：
server surface
source：php.cn
Previous article：mysql常用的技巧_MySQL Next article：解决The 'InnoDB' feature is disabled; you need MySQL built_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Regular expression to match words I have a script where I am trying to match new job names with existing job names in a data...
From 2024-04-06 21:24:04
0
1
606
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template