Category Archives: Mysql

Case Sensitive Mysql Query

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

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