Cannot rename mysql table

Question

I am trying to rename my table using this SQL. I am using MySQL 5.1.41 on Windows XP.

USE 'bobby_tables';

    ALTER TABLE gc_acompte_fournisseur
      RENAME TO GC_Acompte_Fournisseur;

And the request claims that it is executed correctly, but it lies! My table name is still lowercase!

What kind of dirty arcanity did I encounter with this that forbids me to capitalize on my tables?

Answer 1

How MySQL works on Windows:

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_lower_case_table_names

• lower_case_table_names

0, . 1, . 2, . . . 8.2.2, " " .

0, MySQL (, Windows Mac OS X). 0 MyISAM , . Windows - 1. Mac OS X, 2.

InnoDB, 1 , .

( )

Answer 2

/ mysql, :

RENAME TABLE tbl_name TO new_tbl_name

: RENAME TABLE student TO pu_students

: http://dev.mysql.com/doc/refman/5.0/en/rename-table.html

!