Mysql Interview Question and Answers
1. |
What’s MySQL? |
|
MySQL the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers, that builds its business by providing services around the MySQL database management system. |
2. |
Why use the MySQL Database Server? |
|
The MySQL Database Server is very fast, reliable, and easy to use. it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. |
3. |
What is the technical features of MySQL Server? |
|
The MySQL Database Software is a client/server system that consists of a multi-threaded SQL server that supports different backends, several different client programs and libraries, administrative tools, and a wide range of application programming interfaces (APIs). |
4. |
What are the column comparisons operators? |
|
The = , ‹›, ‹=, ‹, ›=, ›,‹‹,››, ‹=›, AND, OR, or LIKE operators may be used in column comparisons to the left of the FROM in SELECT statements. |
5. |
How do you get the number of rows affected by query? |
|
SELECT COUNT (user_id) FROM users; |