Author: admin

What is a database? When an amount of data is stored in an organized way, that is called a database.In computers, a database is managed by a software called Database Management System. What is a table? A table is a set of data values. These values are organized using vertical columns and horizontal rows. Columns…

Connecting to MySQL Before you perform any operations, you need to connect to MySQL server and select a MySQL database. Connecting to MySQL server from command line Command:MySQL -h HostName -u UserName -p Parameters: Name Description -h Keyword, followed by HOSTNAME. HostName MySQL server name -u Keyword, followed by USERNAME. UserName MySQL user name -p…

What is data type 1. A data type specifies a particular type of data, such as integer, floating-point, Boolean etc. 2. A data type also specifies the possible values for that type, the operations that can be performed on that type and the way the values of that type are stored. MySQL data types MySQL…

Language Structure This page discusses the syntactical and structural rules for writing the following elements of MySQL statements. Content: Literal values (string, numbers etc.) The terms literal refer to a fixed data value. MySQL evaluates seven types of literal values numeric, character string, date and time, hexadecimal, boolean, bit-field, and NULL Values Numeric Literals Numeric…

Storage Engines Storage engines (underlying software component) are MySQL components, that can handle the SQL operations for different table types to store and manage information in a database. InnoDB is mostly used general-purpose storage engine and as of MySQL 5.5 and later it is the default engine. There are many storage engines available in MySQL…

Connectors and APIs MySQL Connectors provide connectivity to the MySQL server for client programs and APIs provide low-level access to the MySQL protocol and resources. You can connect and execute MySQL statements from another language or environment, including ODBC, Python, Perl, Ruby, PHP, Java (JDBC), and native C and embedded MySQL instances through connectors and…

MySQL Workbench is GUI based tool to work with MySQL Servers. You may use this for Server Administration, for creating Entity Relationship Diagrams and for SQL Development (run queries etc). This tutorial discusses how to perform basic MySQL Administration tasks using MySQL Workbench. Installing MySQL workbench To install MySQL Workbench on Linux (we used Ubuntu),…

installation on Linux and Windows In this section we are going to discuss how to install MySQL on windows and Linux machines. Download MySQLYou can download MySQL from http://dev.MySQL.com/downloads/. Install MySQL on Linux (RedHat and its variants) 1. After downloading the required RPM package, you have to run the appropriate package with root privilege. Syntax:…

Introduction MySQL is (as of July 2013) the world’s most widely used open-source relational database management system (RDBMS), enabling the cost-effective delivery of reliable, high-performance and scalable Web-based and embedded database applications. It is widely-used as the database component of LAMP (Linux, Apache, MySQL, Perl/PHP/Python) web application software stack. MySQL was developed by Michael Widenius and David Axmark in 1994. Presently…