Articles

  What are the advantages of MySQL when compared with Oracle?

MySQL is open source software which is available at any time and has no cost involved.MySQL is...

 How can you see all indexes defined for a table?

Indexes are defined for the table by:SHOW INDEX FROM <tablename>;

 How do I manage MySQL databases in the Plesk control panel?

The Plesk Control Panel has the ability to create multiple MySQL and PostgreSQL databases as well...

 How do you login to MySql using Unix shell?

We can login through this command: # [mysql dir]/bin/mysql -h hostname -u <UserName> -p...

 How many TRIGGERS are allowed in MySql table?

SIX triggers are allowed in MySql table. They are as follows: BEFORE INSERT AFTER INSERT...

 How MySQL Optimizes DISTINCT?

    SELECT DISTINCT t1.a FROM t1,t2 where t1.a=t2.a;

 How to display top 50 rows?

In MySql, top 50 rows are displayed by using this following query: SELECT * FROMLIMIT 0,50;

 How to enter Characters as HEX Numbers?

If you want to enter characters as HEX numbers, you can enter HEX numbers with single quotes and...

 How to export/import a MySQL database via SSH ?

In this article we will show you how to export and import a MySQL database via SSH. Managing your...

 I am unable to access the MySQL database remotely on different machine. What should I do?

By default, all IPs are blocked and they must be added to an access list in order to access the...

 Is Mysql query is case sensitive?

No.   SELECT VERSION(), CURRENT_DATE; SeLect version(), current_date; seleCt vErSiOn(),...

 What are all the Common SQL Function?

CONCAT(A, B) – Concatenates two string values to create a single string output. Often used to...

 What are the drivers in MySQL?

PHP Driver JDBC Driver ODBC Driver C WRAPPER PYTHON Driver PERL Driver RUBY Driver...

 What are the objects can be created using CREATE statement?

Following objects are created using CREATE statement: DATABASE EVENT FUNCTION INDEX...

 What is the default port for MySQL Server?

The default port for MySQL server is 3306.

 What is the difference between BLOB AND TEXT?

A BLOB is a binary large object that can hold a variable amount of data. There are four types of...

 What is the different between NOW() and CURRENT_DATE()?

NOW () command is used to show current year,month,date with hours,minutes and seconds....

 What storage engines are used in MySQL?

Technique involves: Storage mechanism Locking levels Indexing Capabilities and functions.