quick links

RECENT TOPICS

Traits is look like of class. it contain group of methods you want to use in another class.

Like abstract class we can't create object of traits but we can use it in another class.

So it's solve multiple inheritance problem in PHP.

It's lot of look like interface, but diffrent is in interface we can only define method/function but we can't implement but in traits we can do it.

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))

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.
  • 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

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

CASE, IF, IFNULL is control flow operators

GROUP BY, HAVING is sorting data operators

ORDER BY is sorting data operators

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

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

 

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