Introduction to MYSQL
What is SQL?
Structured Query Language is a third generation language to query Databases. Being a 3G language it is closer to human language than machine language and therefore easier to understand and work with.
* Dr. E. F. Ted Codd who worked for IBM described a relational model for database in 1970.
* In 1992, ANSI (American National Standards Institute), the apex body, standardized most of the basic syntax.
* Its called SQL 92 and most databases (like Oracle, MySQL, Sybase, etc.) implement a subset of the standard (and proprietary extensions that makes them often incompatible).
Why MySQL?
* Cost - Free! (though a for-fee license is required if proprietary software including it is redistributed
outside of the originating organisation).
* Support - Online tutorials, forums, mailing list (lists.mysql.com), paid support contracts.
* Speed - One of the fastest databases available.
* Functionality - support most of ANSI SQL commands.
* Ease of use - less need of training / retraining.
* Portability - easily import / export from Excel and other databases
* Scalable - Useful for both small as well as large databases containing billions of records and terabytes of data in hundreds of thousands of tables.
* Collaboration - selectively grant or revoke permissions to users.
Related items
Only registered users can write comments.
Please login or register.
|
