Skip to content
Advertisement

Records not showing results

The above is the manager table.

& Below is the code I wrote to get records.

The issue is I am not able to get proper input even though I have a row that is a manager who lives in Mumbai City.

What is I am not doing that I am not able to get proper output.

This is the output I am getting

Below are the inputs for the table:

Advertisement

Answer

The table has Mumbai, the select uses mumbai. The case is different. @Littlefoot was right to ask for the INSERT statements, we couldn’t have helped without them.

If you want the SELECT to work, you need to fold both table and query to the same case:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement