Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: SQL Help

  1. #1
    New to the CF scene
    Join Date
    Feb 2012
    Thanked 0 Times in 0 Posts

    SQL Help

    Just wondering if any of you could provide me with any help to the following statement.
    "SQL has a well defined standard that enables portability between different database environments”.
    I understand SQL is used across all the major RDBMS but in different flavours, for want of a better word.

  2. #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Thanked 4,947 Times in 4,908 Posts
    Ummm...and what "help" do you want?

    Yes, in theory ANSI SQL is portable. In practice every DB indeed has its own "flavor", particularly when it comes to DATETIME data type (no two of the major DBs store DATETIME the same or use the same functions) and to functions in support of string manipulation.

    MySQL is especially egregious in doing things in its own way. For example, its support for GROUP BY is not the same as that of any other DB that I know of.
    Be yourself. No one else is as qualified.


Posting Permissions

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