AD

How to set the mysql database can be case-sensitive query data (not to set a single field)

**wenwen.soso**/z/q112133816.htm

How to set the mysql database can query data, such as case-sensitive
select * from abc whre and
select * from abc whre check out the results are different ways to set a single field would not have said, want is mysql the default settings or set the entire library

**************** Satisfied with the answer ^ ^ ^

 The case-sensitivity and proofing rules for, the default rule is case insensitive  .
show create table If you see the collate is  ci At the end, then it is not the differences  , If the CS or  bin At the end, is the difference between  .
 If the table when selected is case sensitive rules of a query and do not wish to distinguish between  ,
 You can do something like:  
WHERE column_name COLLATE latin1_general_ci = '**'
 Wording change queries that use proofing rules  
标签: column name, mysql database, abc, different ways, query data, default settings, collate, soso, entire library, wenwen
分类: Database
时间: 2010-04-11

相关文章

  1. ubuntu linux mysql database under the case of the problem

    ubuntu linux mysql database under the case of the problem Under the default ubuntu install mysql5, into a tabl ...
  2. Calculate the size of mysql database tables, inaccurate, just about the data

    SHOW TABLE STATUS dbname Returns an array: Name: xxx (table name) Engine: MyISAM (Table engine) Version: 10 (v ...
  3. birt connect mysql database

    birt connect mysql database (1) New Report (2) New Data Source (3) The driver managed to add a new jar file (4 ...
  4. Linux (centos) switch to change the MySQL database directory location

    MySQL data files stored in the default directory is / var / lib / mysql. If the directory should be moved to / ...
  5. Optimization of MySQL database server details

    MySql Server Admin program, in order to use the client program, the program must be running, because the clien ...
  6. MySQL database using the techniques

    MySQL database using the techniques 1. MySQL using the ISAM / MyISAM / InnoDB / HEAP / Berkley DB (BDB) and ot ...
  7. Oracle data into MySQL database method

    Oracle data into MySQL database method 2009-09-15 20:49 # # Oracle data into Mysql # # _______________________ ...
  8. pagination + sorting mysql database

    mysql database paging, paging, and so the data can be sorted sql after writing: 1, Table: student (Student Inf ...
  9. Details of the MySQL database server optimization

    MySql Server Admin program, in order to use the client program, the program must be running, because the clien ...
  10. MySQL database server remote connection

    Mentioned above, "LAN access tomcat server", I mainly want remote access in the conference room tomc ...
  11. MySQL database to optimize the specific method described

    The following article focuses on the practical realization of a simple MySQL database optimization specific me ...
  12. CHAR and VARCHAR in MySQL database dispute

    In the database, character data is the most that can account for more than 80% of the entire database. To do t ...
  13. MYSQL is case sensitive

    1, linux mysql after installation is the default under: distinguish between the case table names do not distin ...
  14. java mysql database backup and restore

    1. The underlying database operations package package com.db; import java.sql.*; import java.util.*; /** * * @ ...
  15. Backup and restore MySQL database using java

    When a recent graduate design need to use backup and restore MySQL database, go online to find a bit code is n ...
  16. MySQL Database Connection Test

    Although he knows how to use, but always remember how to write drivers, here to do a backup, in order to later ...
  17. Twitter users jumped 20-fold wish to abandon the MySQL database

    Twitter's an engineer named Ryan King has revealed to the blog MyNoSQL, the company plans to migrate to Cassan ...
  18. Transfer: achieving the java connect mysql database source

    Java source code to connect mysql database to achieve change: http://www.cnblogs.com/shiyangxt/archive/2008/07 ...
  19. rails mysql database backup

    In # (RAILS_ROOT) / lib / tasks established under db.rake, the mccxj to copy the code into, then press Alt + S ...