Explore topic-wise InterviewSolutions in .

You can add a User by USING the CREATE command and SPECIFYING the necessary credentials. For EXAMPLE:

BLOB is an acronym that stands for a BINARY large object. It is used to hold a VARIABLE amount of data.
There are FOUR types of BLOB:

• TINYBLOB
• BLOB
• MEDIUMBLOB
• LONGBLOB

A BLOB can hold a very large amount of data. For example - documents, IMAGES, and even videos. You could store your complete novel as a file in a BLOB if needed.

Example: To select the records with an Order Date of "2018-11-11" from a table:

MySQL has numeric data TYPES for integer, fixed-point, floating-point, and BIT values, as shown in the table below. Numeric types can be signed or UNSIGNED, except BIT. A special ATTRIBUTE enables the automatic generation of sequential integer or floating-point COLUMN values, which is useful for applications that require a series of unique identification numbers.

One can view all the databases on the MYSQL server HOST USING the following command:

mysql> SHOW DATABASES;  

In MYSQL, the DELETE STATEMENT is USED to delete RECORDS from a table:

In MYSQL, there are different index types, such as a regular INDEX, a PRIMARY KEY, or a FULLTEXT index. You can achieve fast searches with the help of an index. Indexes speed up performance by either ordering the data on disk so it's quicker to FIND your RESULT or, telling the SQL engine where to go to find your data.

Example: Adding indexes to the history table:

You can remove a COLUMN by USING the DROP keyword:

ALTER TABLE classics DROP PAGES;

The INSERT INTO STATEMENT is used to add new records to a MySQL table:

If we want to add values for all the columns of the table, we do not NEED to SPECIFY the column names in the SQL query. However, the order of the values should be in the same order as the columns in the table. The INSERT INTO syntax WOULD be as follows:

Use the following to create a table using MySQL:

USE the FOLLOWING command to create a new database CALLED ‘BOOKS’:

CREATE DATABASE books;

A query is a SPECIFIC request or a QUESTION. One can query a DATABASE for specific INFORMATION and have a RECORD returned.

There are THREE main WAYS you can interact with MySQL: 

• USING a COMMAND line
• via a web interface
• through a programming language

A MySQL database contains one or more tables, each of which contains RECORDS or rows. Within these rows are VARIOUS COLUMNS or FIELDS that contain the DATA itself.

The SQL in MySQL stands for STRUCTURED Query Language. This language is ALSO used in other databases such as Oracle and Microsoft SQL Server.  One can use COMMANDS such as the following to send requests from a database:

SELECT title FROM publications WHERE author = ' J. K. ROWLING’;

A database is a structured COLLECTION of data stored in a COMPUTER system and ORGANIZED in a WAY to be quickly searched. With databases, information can be rapidly RETRIEVED.

• Flexibility: MYSQL runs on all operating systems
• Power: MySQL focuses on performance
• Enterprise-Level SQL Features: MySQL had for some time been LACKING in advanced features such as subqueries, VIEWS, and stored procedures.
• Full-Text Indexing and Searching
• Query Caching: This helps ENHANCE the speed of MySQL greatly
• Replication: One MySQL server can be duplicated on another, providing numerous advantages
• Configuration and Security

MySQL is a database MANAGEMENT system for web SERVERS. It can GROW with the website as it is highly scalable. Most of the WEBSITES TODAY are powered by MySQL.