HTML5 Attributes
HTML5 Attributes can be used on any element. HTML elements may contain attributes that are used to set various properties of an element.All attributes have its a name and a value....
HTML5 Syntax
HTML5 is a latest and next version of HTML. The HTML 5 language has a custom HTML syntax. The HTML 5 have some elements like
HTML5 Introduction
HTML is called as Hyper Text Markup Language. HTML is the standard markup language for creating Web pages.HTML5 is the latest version and next major revision of the HTML standard. HTML5 is a standard for structuring and presenting content on the World Wide Web....
PHP Exception Handling
An exception is an event that occurs during the execution of a program that disrupts the normal flow of execution of the application. An exception can be handled by keywords like try,catch,throw, finally in php...
MYSQL CREATE INDEX
Index is used to make data search faster in table. We use index to get the record quickly without searching each row in a database table whenever the table is accessed. We can create an index by using one or more columns of the table for accessing the records....
MySQL DROP Database
MySQL DROP Database query is used to delete database from mysql. It removes database with all the tables, indexes and constraints permanently....
MYSQL DROP TABLE Query
The DROP TABLE Query is used to drop an existing table in a database. We cannot recover the lost data after droping table....
MySQL ALTER Table Query
The ALTER TABLE query is used to add, delete, rename or modify any table field in an existing table. The ALTER TABLE query is also used to add and drop various constraints on an existing table....
How to import large Dump mysql database file for mysql?
How to import large database file for mysql? Big Dump MYSQL file using php....
How to integrate simple PHP CAPTCHA script?
How to integrate simple PHP CAPTCHA script?Many times public form will spam data. We can prevent spamming data using PHP CAPTCHA script....
MYSQL GROUP BY Clause
The GROUP BY statement is often used with aggregate functions like COUNT, MAX, MIN, SUM, AVG to group the result-set by one or more columns. The MYSQL GROUP BY Clause is used to collect data from multiple records and group the result by one or more column. It is generally used in a SELECT statement....
MYSQL - CROSS JOIN Query
MySQL CROSS JOIN is used to combine all possibilities of the two or more tables and returns the result that contains every row from all contributing tables. The CROSS JOIN clause returns the Cartesian product of rows from the joined tables. The CROSS JOIN is also known as CARTESIAN JOIN, which provides the Cartesian product of all associated tables. if each table has n and m rows respectively, the result set will have n x m rows....
MYSQL - RIGHT JOIN Query
RIGHT JOIN Query in mysql is used to join multiple tables which return all the records from the second (right side) table even no matching records found from the first (left-side) table. If it will not find any matches record from the left side first table, then returns null....
MYSQL - LEFT JOIN Query
LEFT JOIN Query in mysql is used to join multiple tables which return all the records from the first (left-side) table even no matching records found from the second (right side) table. If it will not find any matches record from the right side table, then returns null....
MYSQL - INNER JOIN Query
INNER JOIN keyword is used to join two tables and selects records that have matching values in both tables....
MYSQL - SELECT Query
MYSQL SELECT Query is used to fetch existing records from database....
MYSQL - DELETE Query
MYSQL DELETE Query is used to delete existing records in a table....
MYSQL - UPDATE Query
MYSQL UPDATE Query is used to update existing records in a table....
MySQL - insert into
MySQL - insert into statement is used to insert new records in a table. Insert query doesn't have WHERE clause....
MySQL - Create Table
The CREATE TABLE statement is used to create a new table in MYSQL database....