[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Uppercase table names
It's actually case insensitive... but... it could be a setable option in
mysql... I'm pretty sure it's case insensitive though =)
Kyle Hayes wrote:
> ****** message to minivend-users from Kyle Hayes <kyle540@quicknet.net> ******
>
> On Mon, 12 Jul 1999, Dave 'Duke of URL' Weiner wrote:
>
> > mysql> select * from JEWELRY;
> ^^^^^^
>
> > mysql> select * from jewelry;
> > ERROR 1146: Table 'mmall.jewelry' doesn't exist
>
> Yep. It can't find it because the table is mmall.JEWELRY. The case
> _does_ matter in MySQL because the tables are kept as files and under
> Unix, file names are case-sensitive.
>
> You will probably have to rename the table. It isn't that bad, look up
> the ALTER TABLE command. Very handy.
>
> Best,
> Kyle
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
