How to convert this mysql syntax

From: vincent(dot)richomme(at)ratp(dot)fr
To: pgsql-odbc(at)postgresql(dot)org
Subject: How to convert this mysql syntax
Date: 2005-02-04 12:49:50
Message-ID: E23B4EE4F2A6F44B8660AA8723D0B82B012E18BC@nyplme19.neuilly.ratp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I thought that SQL was nomalized but when I tried this wmysql code

With PostGreSQL it doesn't work.

//Select database

m_pDb.Execute( "USE dbBornes;" );

// Create table

csSql.Format( "CREATE TABLE %s(", m_DbTable );

csSql += _T( "UserID INTEGER NOT NULL AUTO_INCREMENT," );

csSql += _T( "Time DATETIME NOT NULL," );

csSql += _T( "NumSerie INTEGER NOT NULL," );

csTmp.Format( "%s VARCHAR(64),", im->first );

csSql += _T( "PRIMARY KEY(UserID))" );

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message markw 2005-02-04 14:40:29 Re: How to convert this mysql syntax
Previous Message Christof Glaser 2005-02-04 12:21:32 Re: not possible to create a database