When data is moved from one database or server to another, we need to compare two tables to identify if the data is valid to be migrated or not. If we have a legacy database whose data has to be mi...
Sometimes we need to copy a table from MySQL database to another one, whether because of a backup or building another, similar table, or any another reason. When a table has to be cloned for applic...
Storage engines or table types in MySQL are used to define how a database table will store data and each storage engine has advantages and disadvantages. Please note than only two engine types that...
There are four main groups of data types in MySQL. Each of those groups has more than one type or sub-type to choose from and they are all listed below:
Here is the list of data types and s...
In MySQL keys and constraints are used to assign a special index to a column, meaning that this column will be approached somehow different by the MySQL server; or in other terms it will be facilit...
In MySQL statements are used to work with database tables, rows and columns, or in other words to manipulate and query data entries.
Here is the list of MySQL statements:
In MySQL operators are used to further facilitate work with statements and clauses, and help they filter the retrieved values better.
Here is the list of MySQL operators: