Tag Archives: Mysql

Case Sensitive Mysql Query

Posted on September 16, 2010 by Kapil Chugh

By default Mysql queries are case insensitive.If we want to make it case sensitive then syntax will be SELECT *  FROM  table  WHERE  BINARY column = ‘value’ We just need to add keyword Binary.

Posted in Mysql | Tagged , | 2 Comments

mysql database commands

Posted on May 3, 2010 by Kapil Chugh

To login: mysql -u root -p To List all databases show databases; to create new database create database [databasename]; Switch to a database. use [db name]; To see all the tables in the db. show tables; To delete a db. … Continue reading →

Posted in Mysql | Tagged | Leave a comment