June 9th, 2000, 07:37 AM
|
|
Contributing User
|
|
Join Date: May 2000
Location: London, England
Posts: 251
Time spent in forums: < 1 sec
Reputation Power: 9
|
|
|
MySQL is a product that manages databases, not a language or standard in itself. It is based on the SQL2 standard.
MySQL is a "lightweight" implementation of SQL designed to run fast on relatively slim systems. As such, it doesn't use all the SQL commands and functions. By lightweight, I mean it is designed to handle around 1000 tables of up to a million records per table. These things are relative!
All SQL-based systems have their own quirks regarding syntax, data types etc., and MySQL is no exception. However, the underlying concepts of relational database design and the vast majority of the command set are common to all.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
