MySQL Interview Questions
Questions Answers Views Company eMail

What are the functions of commit and rollback statements?

550

What is a csv table?

538

How can you count the total number of records of any table?

499

How can you retrieve a particular number of records from a table?

495

How can you find out the version of the installed mysql?

1 685

Which mysql function is used to concatenate string?

1 762

What are the advantages and disadvantages of using mysql?

496

What are the differences between char and varchar data types?

490

What is a storage engine? What are the differences between innodb and myisam engines?

508

Explain the different types of mysql joins.

489

What are the differences between innodb and myisam engines?

459

How can you retrieve a portion of any column value by using a select query?

436

What is the default port number of mysql?

494

Which statement is used in a select query for partial matching?

604

What is the difference between now() and current_date()?

489


Post New MySQL Questions

Un-Answered Questions { MySQL }

How to enter numeric values as hex numbers?

527


How to Join tables on common columns.

633


What is the difference between mysql and oracle?

532


Restore database (or database table) from backup.

551


What is the difference between b-tree and hash indexes?

444






Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

520


In mysql, what is joins? Explain

527


What is InnoDB?

559


What is deterministic in mysql?

499


How to use case expression?

520


What are date and time functions in mysql?

565


What you can use regular expression for in mysql? Support your answer with an example?

476


Explain Access Control Lists.

532


Write command to import an mysql file?

502


What are the 'mysql' command line arguments?

514