Hi, I run mysql on windows as well as linux. table creation and access right are given by java program.
Problem im facing is., i create a table with name TEMP in windows in creates table with name "temp" and linux "TEMP" while giving rights thru GRANTstatement , it fails in windows cause it expect "TEMP" not "temp" How can i create table name with upper case in Windows create table TEMP ( x varchar(6), y varchar(6)) this creates a table with name temp......not TEMP help me with mysql reagrds, Anis --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php