MySQL Interview Questions
Questions Answers Views Company eMail

Differentiate between FLOAT and DOUBLE?

1 857

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

580

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

539

Difference between CHAR and VARCHAR?

595

How to Change a users password from unix shell.

573

What are Heap tables?

1 842

What are the different tables present in MySQL?

566

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

531

What are federated tables?

608

Give string types available for column?

560

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

577

What are the column comparisons operators?

624

How do you login to MySql using Unix shell?

620

How to do login in mysql with unix shell.

547

What are the nonstandard string types?

737


Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the use of mysqli_num_rows?

504


Why should I use mysql?

506


Can mysql scale horizontally?

503


How do you name a table?

493


How do I start mysql in ubuntu?

482






What is difference between oracle and mysql?

502


How to create a new view in mysql?

540


Does mysql use tcp or udp?

528


What is the difference between the primary and unique key in mysql?

469


What is procedural api?

501


How to rename an existing column in a table?

544


What is the difference between a database and a table?

500


How do I run mysql?

493


How do I update a variable in mysql?

499


What is procedure in mysql?

481