Hi,
yes it makes a huge difference,
as the tables are stored in files and therefore if
the filesystem is case-insensitive (Windows) you can
use either case in your queries, while on a case-sensitive
filesystem (linux etc) you can't.
See: http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.htm
Hello,
I am using MySql-5.0.21 on Suse-Linux-10, i created tables using
lowercase names
for example ;
mysql> create table a (id int);
Query OK, 0 rows affected (0.04 sec)
mysql> select * from A;
ERROR 1146 (42S02): Table 'mysql.A' doesn't exist
mysql> select * from a;
Empty set (0.01 sec)
I hav
Hello,
I am using MySql-5.0.21 on Suse-Linux-10, i created tables using
lowercase names
for example ;
mysql> create table a (id int);
Query OK, 0 rows affected (0.04 sec)
mysql> select * from A;
ERROR 1146 (42S02): Table 'mysql.A' doesn't exist
mysql> select * from a;
Empty set (0.01 sec)
I hav
