RE: converting MS SQL to MySQL

Cal Evans Sun, 09 Feb 2003 03:24:14 -0800

check the docs at www.mysql.com for the CORRECT command to create indexes.
=C=


* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com


-----Original Message-----
From: Hawk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 9:03 AM
To: [EMAIL PROTECTED]
Subject: converting MS SQL to MySQL




Hi,

I am new to SQL.  I am attempting to create a database that was created in
MS SQL to MySQL.  The below SQL statements works with MS SQL.

I am executing the following:

CREATE TABLE 'Accounting'(
        'Username' VARCHAR(254) NULL,
        'CallerID' VARCHAR(128) NULL,
        'Addr' VARCHAR(128) NULL,
        'NAS' VARCHAR(128) NULL,
        'Port' VARCHAR(128) NULL,
        'Start' DATETIME NULL,
        'Stop' DATETIME NULL,
        'SessionTime' INTEGER DEFAULT 0,
        'ExtraTime' INTEGER DEFAULT 0,
        'TimeLeft' INTEGER DEFAULT 0,
        'KBytesIn' INTEGER DEFAULT 0,
        'KBytesOut' INTEGER DEFAULT 0,
        'SessionKB' INTEGER DEFAULT 0,
        'ExtraKB' INTEGER DEFAULT 0,
        'KBytesLeft' INTEGER DEFAULT 0,
        )
GO

CREATE INDEX IX_Username ON Accounting(Username)         <---- MySQL will
not take this command
GO

CREATE TABLE 'ActiveUsers'(
        'UserID' VARCHAR(254) PRIMARY KEY,
        'NAS' VARCHAR(128) NULL,
        'Port' VARCHAR(128) NULL,
        'Username' VARCHAR(254) NULL,
        'CallerID' VARCHAR(128) NULL,
        'Address' VARCHAR(128) NULL,
        'LoginTime' DATETIME NULL,
        )
GO

CREATE TABLE 'TAC_GRP'(
        'TAC_ID' VARCHAR(254) NOT NULL,
        'TAC_Attr' VARCHAR(64) NOT NULL,
        'TAC_Val' TEXT NULL
        )
GO

CREATE UNIQUE INDEX IX_TAC_ID ON TAC_GRP(TAC_ID, TAC_Attr)  <---- MySQL
will not take this command
GO

CREATE TABLE 'TAC_USR'(
        'TAC_ID' VARCHAR(254) NOT NULL,
        'TAC_Attr' VARCHAR(64) NOT NULL,
        'TAC_Val' TEXT NULL
        )
GO

CREATE UNIQUE INDEX IX_TAC_ID ON TAC_USR(TAC_ID, TAC_Attr) <---- MySQL will
not take this command
GO


Thanks in advance.

---
[This E-mail scanned for viruses by Friend.ly.net.]


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: converting MS SQL to MySQL

Reply via email to