MySQL

This tutorial provides a step-by-step installation guide for MySQL 5.5 on Windows. Download MySQL Depending on your operating system download the proper version of MySQL from the following link. [...]

1. Relational Database Management System (RDBMS) Software application that control the creation, maintenance, and use of a database. Based on the relational model. Data is stored in tables and [...]

MySQL supports various table types or storage engines to allow you to optimize your database. The table types are available in MySQL are: ISAM MyISAM InnoDB BerkeleyDB (BDB) MERGE HEAP The most [...]

The sample databases used in this tutorial are, Employees Sample Database BIRT Sample Database Please refer those links on how to download and import into your database.

Aggregate Functions SQL aggregate functions return a single value, calculated from values in a column. Useful aggregate functions: Function Description AVG() Returns the average value COUNT() [...]

Information Functions CONNECTION_ID() Returns the connection ID (thread ID) for the connection. Every connection has an ID that is unique among the set of currently connected clients. [...]

Date and Time Functions CURDATE(),CURRENT_DATE, CURRENT_DATE() Returns the current date as a value in ‘YYYY-MM-DD’ or YYYYMMDD format, depending on whether the function is used in a [...]

MySQL String functions UPPER(), UCASE() Returns the string with all characters changed to uppercase. LOWER(), LCASE() Returns the string with all characters changed to lowercase. CHAR_LENGTH(str) [...]

INSERT statement allows you to insert one or more rows to the table. In MySQL, the INSERT statement form is listed as follows: INSERT INTO Syntax INSERT INTO table_name VALUES (value1, value2, [...]

UPDATE statement is used to update existing data in database tables. It can be used to change values of single row, group of rows or even all rows in a table. In MySQL, the SQL UPDATE statement [...]