Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group