MySQL Interview Questions
Questions Answers Views Company eMail

What is a storage engine?

551

What is a join? Explain the different types of mysql joins.

1 682

What is the purpose of using a heap table?

525

How can you change the password of a mysql user?

491

How can you calculate the sum of any column of a table?

503

What is meant by decimal (5,2)?

535

What is a trigger? How you can create a trigger in mysql?

479

What is the difference between unix timestamp and mysql timestamp?

510

How can you change the name of any existing table by using the sql statement?

504

What is the purpose of using ifnull() function?

520

How can you add and remove any column of a table?

513

How can you export the table as an xml file in mysql?

494

How can you create and drop view in mysql?

504

What is an index? How can an index be declared in mysql?

477

What are the differences between a primary key and foreign key?

559


Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the data source name for mysql?

473


How can we optimize stored procedure?

480


How do I insert an image into mysql workbench?

472


Is sql and mysql same?

496


How internally data stores in MyISAM and INNODB table types?

2081






What is mysql root?

485


What is root password?

470


How do I change a procedure in mysql?

474


Does mysql need a server?

482


What is information_schema in mysql?

466


What is delimiter $$?

494


How to shut down the server with 'mysqladmin'?

537


What is 1nf 2nf 3nf?

493


What is the maximum number of columns per table?

480


What does mysql_fetch_assoc do?

511