Ever wondered why there is a “test” database in the list of tables when you install MySQL.
This is to allow users to practice MySQL commands or execute complex queries on the database.
“test” database is accessible to everyone who has access to MySQL in your localhost and hence is not advisable if you were to use it for your development. (more…)
To start MySQL service from Windows command prompt
c:\mysql\bin> net start mysql
To stop MySQL service from Windows command prompt
c:\mysql\bin> net stop mysql
There had often been talks and some times flame wars when there had been comparison between MySQL and PostgreSQL. Each database has its own strength and weaknesses. As an initiative, I thought to do a little research on this topic and to list down the common points gathered in a tabular format. (more…)
Numeric Data type in MySQL
Choosing the right data type can create significant improvement in application performance.
Many programmers/developers who opt to choose MySQL as the backend for their operations often fail miserably in choosing the most efficient data types. (more…)
phpMyAdmin is a web based interface to MySQL which is written using PHP for Administration of databases. Visual interface provided is intuitive and it saves time for the developers. (ver 3.1.1 is the recommended version as of this writing which runs on PHP 5/MySQL 5)
Step 1: First we need to check MySQL is installed by issuing the following command
[root@user Desktop]# which mysql
If you get …
/usr/bin/mysql
then, it is an indication that MySQL is installed in your machine. (more…)
Copyright ©2008 - 2012. Kurinchilion Inc.
