SQL is a language that is based on standards that are modified every so often. So, yes, in general there are SQL statements that you put together will work with Access, MSSQL, Informix, DB2, and Oracle, etc..... But *THE* key issue is that each DBMS application has it's own hooks that are native the vendor's implementation. MySQL's version of SQL doesn't support sub-selects as of yet, for now, but Oracle and SQL Server do. On the flip side, mySQL's version of SQL has better regular expression support than SQL Server. Access' version of SQL is a little bizarre because it requires you to use * instead of % in LIKE clauses, (unless M$ has changed it). I think it's somewhat polluted. Aside from minor adjustments for db connections, you're in decent shape. -----Original Message----- From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:40 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Are all SQL-databases based on the same query-language? SQL itself is not the way the data is stored. SQL stands for Structured Query Language and is a way of retrieving and modifying/adding records. If you write your SQL carefuly, yes you can use it pretty much "as is" on any SQL system. There are little changes and such however that every SQL server makes to the ASNI SQL standards. Somethings will work on one, but not another. Just be careful when writing your syntax and you should be fine. ----- Original Message ----- From: "SED" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 10:26 AM Subject: Are all SQL-databases based on the same query-language? > Hi, > > I have only used MySQL. Today I read that all SQL use the same > query-language, so if you program something, e.g. in PHP, you can also use > is with other SQL-databases, with perhaps minor adjustments for the > database-connections. > > Is this true? > > Regards, > Sumarlidi Einar Dadason > > SED - Graphic Design > > ------------------------------------------ > Phone: (+354) 4615501 > Mobile: (+354) 8960376 > Fax: (+354) 4615503 > E-mail: [EMAIL PROTECTED] > Homepage: www.sed.is <- New Homepage! > ------------------------------------------ > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
