Key points for attention in executing SQL statements in MySQL Database

This article mainly explains the "key points for attention to the execution of SQL statements in MySQL database". The explanation in this article is simple and clear, and is easy to learn and understand. Please follow the editor's train of thought to study and learn "the key points for attention to the execution of SQL statements in MySQL database".

Case problems when executing the lookup command

By default, MySQL does not distinguish the case of letters when performing a lookup. When you use like a% when searching, all column values starting with an or A will be returned by default. To be case-sensitive, you need to use the collate operator. Examples are as follows:

If you want a column to remain case-sensitive when looking up, you need to use case sensitive or binary collation to define the properties of the column.

When performing simple comparison operations, such as > =, >, =