Is mysql query case sensitive?



Is mysql query case sensitive?..

Answer / Manojeet Goldar

Yes, MySQL is case-sensitive when it comes to identifiers (table names, column names, and object names) and SQL keywords. However, it's not case-sensitive for string literals (i.e., strings enclosed in single quotes or double quotes).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I stop a query in mysql workbench?

1 Answers  


What is timestamp in mysql?

1 Answers  


How to run 'mysql' commands from a batch file?

1 Answers  


What is view in mysql?

1 Answers  


What is the difference between MyISAM Static and MyISAM Dynamic?

1 Answers  


What are the other commands to know the structure of a table using mysql commands except explain command?

1 Answers  


How to rename an existing table in mysql?

1 Answers  


How can a user get the current SQL version?

2 Answers  


Explain advantages of InnoDB over MyISAM?

1 Answers  


Is blocked because of many connection errors mysql?

1 Answers  


How does mysql store dates?

1 Answers  


Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

1 Answers  


Categories