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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2005-02-04 18:33:47 | Re: How to convert this mysql syntax |
Previous Message | markw | 2005-02-04 14:40:29 | Re: How to convert this mysql syntax |