Here we are going to read about the MySQL case sensitivity. The case sensitive is a term that tells you to check lettercase either upper case or lower case.

MySQL Case Sensitive

     

Here we are going to read about the MySQL case sensitivity. The case sensitive is a term that tells you to check lettercase either upper case or lower case. In Windows, database and table names, table aliases are not case sensitive. Operating system also affects the case sensitivity of database and table names. For example, Table names, table aliases are case sensitive in Unix operating system. Column, column aliases, index, and stored routine names are not case sensitive on any platform.

 

 

 

 

 

Table: employee

CREATE TABLE `employee` (  `emp_id` int(11) NOT NULL auto_increment,  `emp_name` varchar(100) character set utf8 NOT NULL,  `emp_salary` int(11) NOT NULL,  `emp_startDate` datetime NOT NULL,  `dep_name` varchar(50) NOT NULL,  PRIMARY KEY (`emp_id`)  )

The queries

and

are same statements in widows.

But employee and EMPLOYEE are treated two different tables in Unix.

Case Sensitivity in data:

If you use the following query then you get result data that starts from 'a' or 'A' character.

Output:

If you want to get case sensitive value then you should use following queries: 

Output:

Output:

Related Tags for MySQL Case Sensitive:
sql,  mysql,  c,  vi,  read,  case,  check,  cas,  to,  e,  it,  ls,  pe,  in,  rm,  as,  m,  out,  ca,  let,  letter,  ad,  ase,  rc,  pp,  wer,  s,  term,  at,  my,  k,  is,  ha,  ll,  iv,  go,  ea,  ar,  tt,  s,  s,  th,  ab,  hat,  either,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement