On Thu, Feb 06, 2003 at 10:03:18AM -0500, Hawk wrote: > > > 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.
MS SQL could refer to either Jet SQL or SQL Server SQL, but the SQL below is obviously SQL Server. So the database was created with SQL Server. The GO statements are not SQL. They are used by SQL Server utilities to mark the end of a batch. I don't think they're used by anything other than MS SQL Server utilities and the equivalent Sybase utilites. But regardless, GO isn't used by any MySQL utilities. Every DBMS uses its own dialect of SQL. When you switch from one DBMS (SQL Server) to another (MySQL), you will have to look up the syntax of the statements that don't run and learn how to rewrite them in the new SQL dialect. The best place to start looking for info is the on-line manual at www.mysql.com. Good luck, and have fun. Bob Hall > 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