Category: Database

MySQL Constraints UNIQUE Constraint PRIMARY KEY Constraint Defining Auto-Increment Referential Integrity Constraints CHECK Constraint DEFAULT Constraint Examples MySQL Constraints MySQL also supports many types of constraints to support data integrity. A constraint can be...

MySQL Index Examples MySQL Index Indexes on data tables speed up searches which cut down the time it takes to execute complex queries. Scanning a sorted index is quicker and more efficient access than...

Using Auto_Increment Downloads Examples Using Auto_Increment The AUTO_INCREMENT attribute can be used to generate a unique identity or ID for newly inserted rows. CREATE TABLE employee ( emp_id MEDIUMINT NOT NULL AUTO_INCREMENT, emp_name CHAR(30)...

MySQL Insert Record MySQL Replace Record MySQL Update Record MySQL Delete Record Downloads Examples MySQL Insert Record The INSERT Command Inserting Data in a MySQL Database Once tables have been created, the database sits...

MySQL SELECT Query MySQL DISTINCT Clause MySQL ORDER BY Clause MySQL LIMIT Clause Downloads Examples MySQL SELECT Query The SELECT Command Whitespace and Semi-colons – Whitespace is ignored in SQL statements. – Multiple statements...

MySQL Where Clause Downloads Examples MySQL Where Clause The WHERE Clause and Basic Operator Symbols The WHERE clause is used to retrieve specific rows from tables. The WHERE clause can contain one or more...

MySQL Order By MySQL Aggregate Functions MySQL Group By Downloads Examples MySQL Order By The order by clause is used to do sorting on the query result sets in either ascending or descending order....

MySQL Procedure Downloads Examples MySQL Procedure Stored procedures Stored procedures (SPs) are an important addition to MySQL 5.0 onwards. These are custom programming scripts with embedded SQL statements that are stored in a compiled...

MySQL Trigger Downloads Examples MySQL Trigger A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. The trigger becomes associated...

MySQL Import MySQL Export Downloads Examples MySQL Import mysqlimport : A Data Import utility The mysqlimport client provides a command-line interface to the LOAD DATA INFILE SQL statement. shell> mysqlimport [options] db_name textfile1 [textfile2...