MySQL Interview Questions and Answers
SELECT SQL_CALC_FOUND_ROWS column_name FROM table_name LIMIT 1,10; SELECT FOUND_ROWS();
The second query (COUNT() is never used) will tell you how many results there are total, so you can display a phrase “Found 20000 results, displaying 1-10”. Note that FOUND_ROWS does not pay attention to the LIMITs you specified and always returns the total number of rows affected by query.
SELECT column_name FROM table_name LIMIT 15, 100.
The first number in LIMIT is the offset, the second is the number.
Using DISTINCT in the query, such as SELECT DISTINCT column_name FROM table_name; You can also ask for a number of distinct values by SELECT COUNT (DISTINCT column_name) FROM table_name;
SQL commands can be divided into three subgroups.
Data Definition Language (DDL) deals with database schema and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL.
Data Manipulation Language (DML) deals with data manipulation, and therefore includes most common SQL statements such SELECT, INSERT, etc.
Data Control Language (DCL) includes commands such as GRANT, and mostly concerns with rights, permissions and other controls of the database system.
MySQL database software is a client or server system which includes
This software can be downloaded as freeware and can be downloaded from the internet. MySQL database server is reliable, fast and very easy to use.
The default port for MySQL server is 3306.