|
|
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.
Navigation:
[Reply to this message]
|