SQL and other databases

Peter Haworth pete at mollysrevenge.com
Mon Mar 21 11:34:34 CDT 2011

I'm about to make the leap from sqlite to mySQL so I'm very interested in the differences you mentioned.  I think I've seen some of them in posts on the list here but any chance you could summarise them?  I guess I am expecting some functional improvements in mySQL over sqlite since sqlite advertises itself as a subset of the sql standards but it sounds like you've found some syntactical differences as well.

Pete Haworth

On Mar 21, 2011, at 9:19 AM, Bob Sneidar wrote:

> I have encountered a number of differences in different engines relating to syntax, when to use regular quotes, when to use sequel quotes, what column types can or cannot be enumerated, etc. 

More information about the use-livecode mailing list