quick links

MySQL

AVG, COUNT, MIN, MAX, SUM, DISTINCT are aggregate functions

CONCAT, TRIM, UPPER, LOWER, SUBSTRING, INSTR, LENGTH are string functions

WHERE, AND, OR, IN, NOT IN, BETWEEN, LIMIT, LIKE are filter data operators

ORDER BY is sorting data operators

GROUP BY, HAVING is sorting data operators

CASE, IF, IFNULL is control flow operators

JOIN or INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, SELF JOIN, CROSS JOIN, UNION JOIN. These are all

  • Where clause can be applied to a single row, where as Having clause is applied to the whole group.
  • Having clause is used, when we want to use select query to filter data from a table based on a aggregate condition

Primary Key

  • Primary key cannot have a NULL value.
  • Each table can have only one primary key.
  • By default, Primary key is clustered index and data in the database table is physically organized in the sequence of clustered index.

Create Table

  • CREATE TABLE MyGuests(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50))
 

About Us

Joomla Web Solution

We love working with PHP, HTML5, CSS3, jQuery and the most-loved content management framework in the world, Joomla!

LIKE US ON FACEBOOK