[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;
^^^^^^
> 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
