Thursday, September 4, 2008

General info in PHP, MySQL

Do you know this?

- E.F. Codd released his Codd's rule in 1970 at the time of working in IBM's San Jose Research Laboratory

- Structured Query Language (SQL), developed by Donald D. Chamberlin and Raymond F. Boyce, for expressing queries at IBM's San Jose Research Laboratory in early 1970's

- Raymond F. Boyce also worked with Codd to develop the Boyce-Codd Normal Form for efficiently designing relational database tables so information was not needlessly duplicated in different tables.

- SQL was initially called as SEQUEL, was designed to manipulate and retrieve data stored in IBM's San Jose Research Laboratory original relational database product, System R.

- SQL language was standardized by the American National Standards Institute (ANSI) in 1986 and ISO in 1987

- MySQL as maintained by Sun Microsystems and it as first public release in November 1996

- MySQL supported in Windows, Mac OS X, Linux, BSD, UNIX operating systems

- MySQL maximum size of DB is Unlimited, Max table size is 2 GB (Win32 FAT32) to 16 TB (Solaris), Max row size 64 KB,
Max columns per row is 3398, Max Blob/Clob size 4 GB (longtext, longblob), Max CHAR size is 64 KB (text), Max NUMBER size 64 bits.

- MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems

- The world's most popular open source database is MySQL Database

No comments:

Popular Posts