[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Uppercase table names
>On Mon, 12 Jul 1999, Dave 'Duke of URL' Weiner wrote:
>
>> mysql> select * from JEWELRY;
> ^^^^^^
Yes...I named the tables in all upper case. Comes from my programming
background ;D
>
>> 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.
I'm aware of it being case sensative, and in my catalog.cfg, I specified the
table names in all uppercase. It appears that minivend or DBI/DBD is
squashing it to all lowercase.
>
>You will probably have to rename the table. It isn't that bad, look up
>the ALTER TABLE command. Very handy.
Yup, that's what it's looking like I'm going to have to do...
>
>Best,
>Kyle
Dave
