Posted by Jacques Lebastard on 09/30/06 20:08

I have a problem writing PHP ODBC scripts that suit both MySQL and
PostgreSQL. So far, the following syntaxes seem to apply to each
database (this is an 'insert' example; the same differences apply to
'select commands):

MySQL: INSERT INTO MyTable (col1, col2) VALUES ("value1","value2")
PGSQL: INSERT INTO "MyTable" (col1, col2) VALUES ('value1','value2')

I'd like to have a single syntax for both databases. Is this possible?
Do I need to modify either database configuration settings? Does each
database (MySQL, PGSQL, MSSQL, Oracle, ...) use its own SQL syntax?

Any advice welcome.

[Back to original message]