SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Guru
    Join Date
    Apr 2001
    Location
    BC, Canada
    Posts
    630
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was looking at some books, some said SQL and some said MYSQL is there a dif??

  2. #2
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MySQL is a database program - an application.

    SQL - Structured Query Language is a development language used in varying degrees on all database applications.
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  3. #3
    What's HTML?
    Join Date
    May 2001
    Location
    San Diego, CA
    Posts
    1,701
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Anyone know what the "My" stands for in MySQL?
    Ryan Kuhle - A Proud Advisor - Got Questions? Just Ask!
    Get your website started for less than $20! Click Here

  4. #4
    SitePoint Wizard
    Join Date
    Mar 2001
    Posts
    3,537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    uhhhh...."My"

  5. #5
    SitePoint Wizard
    Join Date
    Mar 2001
    Posts
    3,537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    In an SQL book you are not going to find a command like mysql_num_rows() or mysql_fetch_array(). However, you need to know SQL to make SELECT statments, INSERT statements, etc. for mysql queries. The SQL wizards can get a mysql SELECT to do anything, but that takes a combination of SQL knowledge, and a knowledge of all the various mysql functions. Go to www.mysql.com and take a look at all the mysql functions.

  6. #6
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    An analogy of sorts would be that SQL is to MySQL as C++ is to VC++ (or Borland C++ Builder or Metrowerks Code Warrior).

    C++ is a programming language defined by ANSI and ISO (International Standards Organisation) standards. VC++ or Borland C++ Builder are integrated development environments (applications) that use the C++ language and add various class libraries (the MFC and the OWL) that allow you to create applications specific to the Win32 platform.

    Similarly, SQL (structured query language) is considered a data definition and data query language and is also defined by ANSI and ISO standards. MySQL is a database application which impliments the SQL. MySQL also has a whole host of features and settings which the developer may need to know. Other relational databases such as Oracle or SQL Server also impliment SQL (with slight variations) but also offer a raft of additional features, options, configurations and behaviours.

  7. #7
    SitePoint Evangelist AlexC's Avatar
    Join Date
    Oct 2000
    Location
    Sheffield, UK
    Posts
    437
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the analogy i would make (and this is probably wrong) is that

    SQL = Bread
    MySQL = Bread and Butter

    SQL can be used with anything

    however, mysql is different in a way
    Nearly 7 years old!

  8. #8
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Actually, I was just thinking about adding another point to this discussion and read your post AlexC. So I will make my point by extending your analogy

    SQL = Leavened Bread (bread made with yeast)
    MySQL = Unleavened Bread and Butter



    My point being that MySQL really only impliments a light weight version of SQL. There are some very fundamental things that MySQL does not support that can be very frustrating. Thus someone who learns ANSI SQL92 is going to find that a lot of things do not work with MySQL. I'm not going to go over what these deficiencies are as they have been discussed on the forums many times now..


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •