Question - What are the features of MySQL
Answer -
1) Internals and Portability
Written in C and C++, Works on different platforms, Fully multi-threaded, SQL functions are implemented
2) Column Types
signed/unsigned integers, FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types
3) Statements and Functions
Full operator and function support in the SELECT and WHERE clauses of queries
Full support for SQL GROUP BY and ORDER BY clauses. Support for group functions (COUNT(), COUNT(DISTINCT ...), AVG(), STD(), SUM(), MAX(), MIN(), and GROUP_CONCAT()).
Support for LEFT OUTER JOIN and RIGHT OUTER JOIN
Support for aliases on tables and columns as required by standard SQL
DELETE, INSERT, REPLACE, and UPDATE return the number of rows that were changed (affected)
SHOW command can be used to retrieve information about databases, database engines, tables, and indexes
EXPLAIN command can be used to determine how the optimizer resolves a query.
Function names do not clash with table or column names
4) Security
A privilege and password system that is very flexible and secure, because all password traffic is encrypted
5) Scalability and Limits
Databases can contain 50 million records, 60,000 tables and about 5,000,000,000 rows
64 indexes per table are allowed and Each index may consist of 1 to 16 columns or parts of columns, maximum index width is 1000 bytes (CHAR, VARCHAR, BLOB, or TEXT )
6) Connectivity
Clients can connect to the MySQL server using TCP/IP sockets on any platform
Windows systems in the NT family (NT, 2000, XP, or 2003)
On Unix systems, clients can connect using Unix domain socket files.
7) Localization
&nb