Mysql Interview Questions

Mysql Interview Questions

MySql is a multi-threading, multi-user open source SQL database management system. It is typically used for web application development, and often accessed using PHP.

Read Best MySql Interview Question and answers

Download Mysql Interview Questions PDF

Mysql Interview Questions

If you have to store the short piece of data like password hashes then it is advised to store it in VARCHAR.

If you need to store arbitrary chunks of binary data then BLOB is the desired product to store the data.

Run below command on the terminal to import a MySQL database from the file

mysql -u username -p database_name < file.sql 

mysqladmin -u root -p password “newpassword”

mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql

Tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by command note.

mysqlcheck is a client program that check the integrity of database tables.

mysqldump is a client program that creates logical backups of database.