1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category
MySQL Interview Questions
Questions Answers Views Company eMail

What are the advantages and disadvantages of MySQL?

Satyam,

3148

What is the difference between GROUP BY and ORDER BY in Sql?

Creative, Renault Nissan, Trikon Networks,

12 74537

What is the difference between char and varchar data types?

 6 46132

How to load data from a text file into a table?

Sasaa,

7 13342

How can we know the number of days between two given dates using MySQL?

Base2 Infotech, Webworks,

2 6700

How can we change the name of a column of a table?

 7 8833

How can we change the name and data type of a column of a table?

Google,

9 23758

What are the differences between drop a table and truncate a table?

 10 22624

A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

 5 13138

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

 1 3858

For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

 1 3085

How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?

 4 9421

What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

 2 7350

Explain MySQL optimization?

 1 5319

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

Afixi, GE,

4 8334

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is a storage engine?

551

What is a query in mysql?

472

How many columns can you create for an index?

478

How to create trigger in mysql workbench?

536

What is pdo in php mysql?

491




How do I rename a mysql database?

485

How to drop an existing index in mysql?

546

What do I do if I forgot my mysql root password?

472

Write a query to fetch common records between two tables using mysql?

530

What is regex in mysql?

527

What is ntext?

604

Explain about reporting services of MYSQL?

606

How to use sum function in where clause in mysql?

438

What is a crosstab query?

503

How can you import tables from a sql file into a database by using the mysql client?

534

For More Un-Answered { MySQL } Questions Click Here