MySQL Interview Questions and Answers

It is a table that points to a table in another MySQL database instance. It can be seen as a view of this remote database. Other RDBMS have the same concepts for example database links.

The maximum size of the HEAP table can be controlled by the MySQL config variable called max_heap_table_size.

It is a language but not a Programming Language. It is a relational database management system.

• Data Security
• It is used to retrieve large amounts of records from a database quickly and efficiently.
• On-Demand Scalability
• High Performance
• Excellent Uptime
• Reduced Total Cost of Ownership

Storage engines are Mysql components, that can handle the operations for different table types to store and manage information in a database.

• InnoDB
• MyISAM
• MEMORY
• MERGE
• EXAMPLE
• CSV
• ARCHIVE etc

ALTER TABLE EnterTableName ENGINE = EnterEngineName;

InnoDB

SELECT id, GROUP_CONCAT(department SEPARATOR ' ') AS department FROM employee group by id;

Between operator is used to select a range of data between two values. It can be texts, numbers, and dates, etc.

Syntax: Select * from TABLENAME where FIELDNAME between VALUE1 and VALUE2

IN operator is used to check for a value in the given set of values.

Syntax: Select * from TABLENAME where FIELDNAME IN ('VALUE1','VALUE2',...)

You can use this query in your PHPMyAdmin SELECT version();