Category: Database

Dr. E. F. Codd’s 12 rules of RDBMS 0

Dr. E. F. Codd’s 12 rules of RDBMS

Dr. E. F. Codd’s 12 rules for fully RDBMS Note that based on these rules there is no fully relational database management system available today. In particular, rules 6, 9, 10, 11 and 12...

MySQL Server : Open Source Database : MySQL Export / Import 0

MySQL Server : Open Source Database : MySQL Export / Import

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

MySQL Server : Open Source Database : MySQL Trigger 0

MySQL Server : Open Source Database : MySQL Trigger

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 Server : Open Source Database : MySQL Procedure 0

MySQL Server : Open Source Database : MySQL Procedure

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 Server : Order By/Group By/Aggregate functions 0

MySQL Server : Order By/Group By/Aggregate functions

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 Server : Open Source Database : Where Clause 0

MySQL Server : Open Source Database : Where Clause

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 Server : Open Source Database : Select Query 0

MySQL Server : Open Source Database : Select Query

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 Server : Open Source Database : Insert/Update/Delete Record 0

MySQL Server : Open Source Database : Insert/Update/Delete Record

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 Server : Open Source Database : Using Auto_Increment 0

MySQL Server : Open Source Database : Using Auto_Increment

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 Server : Open Source Database : MySQL Index 0

MySQL Server : Open Source Database : MySQL Index

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