INTRODUCTION TO MYSQL

MySQL- MySQL is an Open Source RDBMS Software like Oracle, Sybase, DB2, MS SQL Server etc. that uses Structured Query Language. It was developed by Michael Widenius and AKA Monty. Features of MySQL :  Open Source and availableat freeofcost.  Fast and Reliable.  SupportsSQL (Structured Query Language), standardized by ANSI .  Portable and secure.  Can be used with various programming languages and platform.  Data Types in MySQL: -Every column in a table should belong to a unique domain (known as data type). These data types help to describe the kind of information a particular column holds. MySQL supports the ANSI SQL data types. Some of the commonly used data types along with their characteristics are as follows:  Numeric Data Types: INTEGER or INT – up to 11 digit number without decimal. SMALLINT – up to 5 digit number without decimal. DECIMAL(M,D) – Unpacked floating point up to M length and D decimal places.  Date & Time Data Types: DATE -A date in YYYY-MM-DD format. TIME - Stores time in HH:MM:SS format. DATETIME –A date and time format like YYYY-MM-DD HH:MM:SS  String or Text Data Type: CHAR(Size) - A fixed length string up to 255 characters.(default is 1) VARCHAR(Size) – A variable length string up to 255 characters.