#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    Hi,
    Could you tell me if there is a big difference in commands between SQL and MySql

    Thanks

    Lynne
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Location
    London, England
    Posts
    251
    Rep Power
    15
    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.

Similar Threads

  1. Odd problem with a hash and foreach loop
    By quantumechanix in forum Perl Programming
    Replies: 7
    Last Post: December 15th, 2003, 05:06 PM
  2. not executing commands using Open3
    By othermatty in forum Perl Programming
    Replies: 5
    Last Post: September 9th, 2003, 06:52 PM
  3. Running dos commands from perl (server side script)
    By keeronmodi in forum Perl Programming
    Replies: 8
    Last Post: August 25th, 2003, 04:26 PM

IMN logo majestic logo threadwatch logo seochat tools logo