MySQL is a widely used open source database software.Several paid editions are available with additional functionality for commercial use.
Mysql storage engine is the underlying software component. Mysql uses engines to create, read, update and delete (CRUD) data from a database.
MySQL uses all the standard ANSI SQL numeric data types. MySQL uses following datatypes.
MySQL Alter Command is used to change the structure of existing table . we can use Alter Command add or drop column, change column attribute, add primary key, rename table,etc.
List Of important MySQL function are given below.
MySQL JOIN keyword is used to query data from two or more related tables. We can use JOINS in SELECT, UPDATE and DELETE statements to JOIN MySQL tables.
MySQL View is virtual table that allow us to query the data in it. Contents of the view are the result-set of a base table.If data is changed in the base tables, the same change is reflected in the view .