Tag: mysql

A database view is a virtual table which is defined as a SQL select query with JOIN statement. Same as database table it consists of rows and columns. When any data of a tables changes, […]

MySQL supports different data types while creating columns i.e. what type of value is using for the column or fixed/variable length etc. It has different types of data types i.e. Numeric: TINYINT, SMALLINT, MEDIUMINT, INT, […]

In a table there may be data available i.e. duplicate. Each time you querying and get all the duplicate data. Use DISTINCT to avoid it. Suppose in a coountry table there are two same country […]

MySQL LEFT JOIN allows you to get result set from two or more tables for certain matches. Suppose you have two tables i.e. A and B. So if you join A to B using left […]

It is relational database concept in which multiple tables shares consistent relationship based on the data stored on tables. For example, a school X has 2 tables, a student table, and a student fee table. […]

Using MySQL UPDATE statement you can update existing data in a table. it can be a single column or multiple rows. Here is a simple example of MySQL UPDATE: UPDATE users SET user_address = ‘Kolkata, […]

When you create a database you have to choose the storage engine for storing data into the database. MySQL supports various types of storage engines i.e. MyISAM, InnoDB, MERGE, MEMORY (HEAP), ARCHIVE, CSV, FEDERATED. Each […]

Using MySQL INNER JOIN you can match rows in one table with another table and get result set that contain columns from both tables. Suppose we have two tables user and order. So Using this […]

A primary key is a column or multiple columns that uniquely identify each row in a table.Basic key of primary key:– This must contain unique values– For multiple columns, the combination of values must be […]

To sort a table columns in ascending or descending order you use ORDER BY clause. Using ASC and DESC you can get the result in ascending or descending order. You can also apply both order […]