service mysqld stop

Question: What is the default port for MySQL Server?

The default port for MySQL server is 3306

Question: What is the difference between MySQL and SQL?

SQL is known as standard query language. It is used to interact with the database like MySQL. MySQL is a database that stores various types of data and keeps it safe.

Question: How will you export tables as an XML file in MySQL?

MYSQL’s query browser has a provision called “Export Result Set” which allows the tables to be exported as XML

Question: Differentiate between FLOAT and DOUBLE in MYSql?

* Floating point numbers are stored in FLOAT with eight place accuracy and it has four bytes.
* Floating point numbers are stored in DOUBLE with accuracy of 18 places and it has eight bytes.

Question: What are the Types of storage engine in MySQL?

Following are the types of storage engine in MYSql
* MyISAM
* Heap
* Merge
* INNO DB
* ISAM

Question: Differentiate CHAR_LENGTH and LENGTH?

CHAR_LENGTH is character count whereas the LENGTH is byte count. The numbers are same for Latin characters but they are different for Unicode and other encodings.

Question: What is the difference between CHAR and VARCHAR?

* CHAR and VARCHAR types are different in storage and retrieval.
* When CHAR values are stored then they are right padded using spaces to specific length. Trailing spaces are removed when CHAR values are retrieved.
* CHAR column length is fixed to the length that is declared while creating table. The length value ranges from 1 and 255.

Question: What is DDL, DML and DCL?

DDL (Data Definition Language) deals with database schemas and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL.
DML (Data Manipulation Language) deals with data manipulation, and therefore includes most common SQL statements such SELECT, INSERT etc.
DCL (Data Control Language) includes commands such as GRANT, and mostly concerns with rights, permissions and other controls of the database system.

Question: How to represent ENUMs and SETs internally?

ENUMs and SETs are used to represent powers of two because of storage optimizations.

Question: What is a trigger in MySQL?

A trigger is a set of codes that executes in response to some events.

Question: How many Triggers are possible in MySQL?

Following are the possible triggers in MYSql.
* Before Insert
* After Insert
* Before Update
* After Update
* Before Delete
* After Delete

Question: What is the usage of ENUMs in MySQL?

ENUM is a string object used to specify set of predefined values and that can be used during table creation.

Question: Define REGEXP?

REGEXP is a pattern match in which matches pattern anywhere in the search value.
See REGEXP eg: How to search for exact matched word using MySql Query

Question: How do you get the number of rows in MYSql?

Question: How do you return the a hundred items starting from 20th position?

SELECT item_name FROM items LIMIT 20, 100.

SELECT VERSION ();

SELECT NOW();
-- Display only current date
SELECT CURRENT_DATE();

mysql ;
mysql mysql.out