MySQL > Table doesn't exist. But it does


#1

mysql> show tables;
±-------------------+
| Tables_in_aldobowi |
±-------------------+
| Section |
| course |
| student |
±-------------------+
3 rows in set (0.00 sec)

mysql> select * from section;
ERROR 1146 (42S02): Table ‘aldobowi.section’ doesn’t exist
Does anyone knows what is it?


#2

There’s not much information to go off of here but it’s tough to tell what’s going on but perhaps you are in the wrong database. Try running show databases to see what databases there are. Then if you find one that looks familiar then do use familiarDatabase and then run your select query once again.


#3

Hello.
Please try with uppercase S.
select * from Section;


https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html

In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Triggers also correspond to files. Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database, table, and trigger names.


#4

HI,

select * from Section; It’s working fine now thanks.