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

Re: How to convert this mysql syntax

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: vincent(dot)richomme(at)ratp(dot)fr
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: How to convert this mysql syntax
Date: 2005-02-04 14:49:49
Message-ID: 20050204144949.73602.qmail@web20828.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- markw(at)mohawksoft(dot)com wrote:

> > I thought that SQL was nomalized but when I tried
> this wmysql code
> 
> SQL is mostly normalized, but every database seems
> to bring in its own
> incompatibilities.
> >
> > With PostGreSQL it doesn't work.
> 
> It is probably a MySQL extension.
> 
> >
> >
> >
> >
> >
> > //Select database
> >
> >
> >
> > m_pDb.Execute( "USE dbBornes;" );
> 
> Try:
> m_pDb.Execute( "connect dbBornes;" );
> 
> >
> >
> >
> > // Create table
> >
> > csSql.Format( "CREATE TABLE %s(", m_DbTable );
> >
> > csSql += _T( "UserID     INTEGER    NOT NULL
> > AUTO_INCREMENT,"    );

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

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

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

> >
> > csSql += _T( "NumSerie   INTEGER    NOT NULL," );
> >
> > csTmp.Format( "%s VARCHAR(64),", im->first );
> >
> > csSql += _T( "PRIMARY KEY(UserID))" );

http://www.postgresql.org/docs/8.0/interactive/datatype.html

> >
> >
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
> 



		
__________________________________ 
Do you Yahoo!? 
Take Yahoo! Mail with you! Get it on your mobile phone. 
http://mobile.yahoo.com/maildemo 

In response to

pgsql-odbc by date

Next:From: Merlin MoncureDate: 2005-02-04 18:33:47
Subject: Re: How to convert this mysql syntax
Previous:From: markwDate: 2005-02-04 14:40:29
Subject: Re: How to convert this mysql syntax

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