CodingForums.com - View Single Post

Old Pedant · 11-14-2012, 07:37 PM

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.

11-14-2012, 07:37 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,249 Thanks: 59 Thanked 3,999 Times in 3,968 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. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.