MYSQL

How to allow case sensitive names in Mysql on Windows

waytocode_mysql

Have you ever faced problem related to keep table Name as Capital ? On most of the Windows OS and Server OS, if you ...

How to convert All tables from MyIsam to innoDB in Mysql

Suppose you have 1 database, in which you have n number of tables.You want to fire such a Query so that will convert ...

Write update query using subquery in MSSQL MYSQL

Everybody knows about SQL update Query. Even its way easy to update some columns based on some condition. Suppose you ...

How to select update dates with some interval day/month duration in mysql

This article focuses on following points If you have 1 or more date field in your mysql database and you want to write ...

Import Export mysql database using command prompt

Its for Developer who are using Mysql. Basically this article is meant for situation where you have complete access of ...

How to enable and execute stored procedures in mysql

Incase you want to execute a stored procedure , you will face problems like root access needed. To over come that ...