Just curious…
so my friend is using WAMP version 2i, and his phpmyadmin unable to create a uppercase table name…
everytime he create, for example, ‘Inventory’ the phpmyadmin will generate ‘inventory’…
why is it??
Just curious…
so my friend is using WAMP version 2i, and his phpmyadmin unable to create a uppercase table name…
everytime he create, for example, ‘Inventory’ the phpmyadmin will generate ‘inventory’…
why is it??
MySQL defaults to lowercase table names in Windows which can be a problem when importing your db on a Linux server.
This can be changed by editing your ‘my.ini’ file found in ‘path-to-mysql\bin\my.ini’ and adding the following line:
lower_case_table_names=0
There are caveats to this approach though so you’re much better sticking to lowercase table names if possible.
Hope this helps.
Ow… I see. Thank you 