PHP Force [021]mysql table name cannot be capitalized under Mac

2015-08-27 PHP Force 021.mysql table name cannot be capitalized under Mac

Just now the database, phpMyAdmin crazy error.

Some errors has been detected on the server!

Bottom of this window. NoticeIn./libraries/structure.lib.php#1868
Undefined index:rows

BackTrace

./libraries/structure.lib.php#2376:gethtmlforrowstatstable (out of the warning, his grandmother's, the most annoying error, looking for, looking for a long time, waste is the day. Tbl_person error, also:

CREATE TABLE ' tbl_mediaresources ' (
' AA ' VARCHAR (111) NULL,
' BB ' VARCHAR (111) NULL
) ENGINE = InnoDB;

also error.

SQL error, manual build table also error, become a two fields also error, only found, ctlld, grass it Is栲栳栳 Is栲栳栳! Cannot be case-sensitive. A pig.?? Oracle, MSSQLServer more than 10 years is not the same thing AH.

Search Baidu as follows:

Mac OS X MySQL table name case sensitive issues2015-01-06 08:55happyyangyuan | Browse 114 times Mac Software Development Database

How do i modify MySQL's table name to be case insensitive under Mac OS X?  please expert guidance!

WORKAROUND: Add/Modify parameters within/usr/local/mysql-xxx/my.conf file Lower_case_table_names=1



Http://blog.sina.com.cn/s/blog_6826662b010186ks.html

MySQL table name capitalization issues under Windows and Linux(2013-01-08 10:04:28) reproduced

Tags: gossip

Category: Technical Memo

MySQL is case-insensitive under Windows, and the table name is automatically converted to lowercase when the script file is imported into MySQL, resulting in an error when you want to put the database export into use on a Linux server. Because the table names in Linux are case-sensitive and cannot find a table, many of them say that changing the MySQL settings under Linux makes it not case-sensitive, but there is no way to make Windows case-insensitive in turn. In fact the method is the same, the corresponding changes in the Windows MySQL settings on the line.
Specific operation:
Add a line to the MySQL configuration file My.ini:
Lower_case_table_names = 0
Where 0: Case sensitive, 1: Case insensitive Note:After you modify the My.ini configuration file, you need to restart the MySQL service to take effect. (Services and applications, such as calculator, management)
MySQL under Linux database name, table name, column name, alias casing rules are like this:
1, database name and table name are strictly case-sensitive;
2, the table alias is strictly case-sensitive;
3, the column name and the alias of the column in all cases are ignored case;
4. Variable names are also strictly case-sensitive; MySQL is case-insensitive under Windows http://www.cnblogs.com/jifeng/archive/2010/08/29/1811879. HTML causes MySQL to be case insensitive to table names posted on2010-08-29 15:09 Tifeng Read (12531) Comment (1) Edit Collection

Today depressed dead, in the Linux downgrade a program old said can't find the table, but I obviously built a table, under the command line of MySQL can also find, why the program can't find the table?

Later asked a teacher to take care of, the original is the Linux MySQL default is to distinguish the table name case, hey, get so old, killed me.

The way that MySQL does not differentiate between table name capitalization is actually simple:

1. Log in with root, modify/ETC/MY.CNF

2. Add a line under [mysqld]: Lower_case_table_names=1

3. Restart the database to

Undefined index:rows OK, I also don't set the configuration. All lowercase bar. It's Is栲栳栳 Is栲栳栳. Media [Méi tǐ]new the basic interpretation of English translation of media

• Media
• Medium (mediums or media)
• Mediator

We're not writing this: Tbl_mediaresources:tbl_mediaresources.

Let's just lowercase, all right: Tbl_media

La La. I'm a lonely little fart (PHP)

PHP Force [021]mysql table name cannot be capitalized under Mac