On Sun, Sep 5, 2010 at 22:56, Tim Starling tstarling@wikimedia.org wrote:
It would be great if the maintainers of the less-commonly used DBMSes could write up development guides and put them in phase3/docs. These guides could describe relevant differences in SQL syntax compared to MySQL, and explain how to write schema files.
I have a reference table for the MySQL, Postgres, and DB2 data types in the current schema on the wiki:
http://www.mediawiki.org/wiki/Manual:IBM_DB2#SQL_data_types
It's somewhat hard to predict what the important differences in SQL syntax would be. Is there anything specific that comes to mind? If not, I can just write MySQL/DB2 differences up as I encounter them
Would it be useful to link to the reference documentation for things like CREATE TABLE, ALTER TABLE, ALTER COLUMN, etc in the short term?
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ib...
Regards,
Leons Petrazickis http://lpetr.org/blog/