subject:"converting MS SQL to MySQL"

Re: converting MS SQL to MySQL

2003-02-10 Thread Barry C . Hawkins

Hawk,
	While your script is fairly straightforward in terms of SQL syntax, 
Transact-SQL and MySQL's dialect of SQL are different enough that you 
will have to modify some things.  Here's a link to the CREATE INDEX 
syntax page of the online MySQL manual:

http://www.mysql.com/doc/en/CREATE_INDEX.html

	It could be as simple as placing a space between the table name and 
columns list.  What sort of errors are you getting?  Have you tried 
creating an index with the command-line utility to see if you can get 
more information on the issue?  Also, what version of MySQL are you 
running?  The manual states that prior to 3.22 this statement did 
nothing.  Most folks are on 3.23.5x, but it never hurts to check.

Regards,



On Thursday, February 6, 2003, at 05:57 PM, 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.

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 mysql-unsubscribe- 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




--
Barry C. Hawkins
Systems Consultant
All Things Computed
404-795-9147 voice/fax
[EMAIL PROTECTED]


-
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

2003-02-10 Thread Barry C. Hawkins

Scott,
Try using single quotes for the values in your INSERT statement.

$sSql = INSERT INTO contacts (first_,last_ ) VALUES 
('$first_','$last_');

Quoted identifiers is a setting usually enabled for SQL Server 
connections, and so it thinks you are indicating an attribute (column) 
of an entity (table) and therefore fails.  At least that's my best 
guess for now.

Regards,

 Barry
 
 I have had a crack at alering a php script written for a mysql 
database but
 instead I want it into a MS SQl database. I though am getting a 
unexplained
 T_variable.
 
 This is what I have got:-
 
 ?PHP
 $hostname = database;
 $username = login;
 $password = password;
 $dbName = database;
 
 MSSQL_CONNECT($hostname,$username,$password);
 mssql_select_db($dbName) or DIE(Table unavailable);
 
 $sSql = INSERT INTO contacts (first_,last_ ) VALUES 
($first_,$last_);
 
 $pResult = mssql_query($sSql, $g_pDBServer);
 print  Data submitted to database!p
 first_: $first_br
 last_: $last_br;
 
 // Close the database connection
 mssql_close();
 ?
 
 
 Each time I run it though I am getting
 Parse error: parse error, unexpected T_VARIABLE in 
C:\Intranet\Intranet -
 Main Folder\access.php on line 10
 
 Been looking in google and php.nt - and so far coming up a blank - 
can u
 help put me on the right track.
 
 Scott
 
 
 - Original Message -
 From: Barry C. Hawkins [EMAIL PROTECTED]
 To: Hawk [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Saturday, February 08, 2003 2:33 PM
 Subject: Re: converting MS SQL to MySQL
 
 
  Hawk,
  While your script is fairly straightforward in terms of SQL syntax,
  Transact-SQL and MySQL's dialect of SQL are different enough that 
you
  will have to modify some things.  Here's a link to the CREATE INDEX
  syntax page of the online MySQL manual:
 
  http://www.mysql.com/doc/en/CREATE_INDEX.html
 
  It could be as simple as placing a space between the table name and
  columns list.  What sort of errors are you getting?  Have you tried
  creating an index with the command-line utility to see if you can 
get
  more information on the issue?  Also, what version of MySQL are you
  running?  The manual states that prior to 3.22 this statement did
  nothing.  Most folks are on 3.23.5x, but it never hurts to check.
 
  Regards,
 
 
 
  On Thursday, February 6, 2003, at 05:57 PM, 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.
  
   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 mysql-
[EMAIL PROTECTED]
   To unsubscribe, e-mail mysql-unsubscribe-
   [EMAIL PROTECTED]
   Trouble unsubscribing? Try: 
http://lists.mysql.com/php/unsubscribe.php
  
  
  
  
  --
  Barry C. Hawkins
  Systems Consultant
  All Things Computed
  404-795-9147 voice/fax
  [EMAIL PROTECTED]
 
 
  
-
  Before posting, please check:
 http://www.mysql.com/manual.php

Re: converting MS SQL to MySQL

2003-02-09 Thread mysql-list

Hi Hawk [EMAIL PROTECTED],

I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:

* http://www.mysql.com/doc/en/Using_mSQL_tools.html
* http://www.mysql.com/doc/en/Using_InnoDB_tables.html

This was an automated response to your email 'converting MS SQL to MySQL'.
Final search keyword used to query the manual was 'converting MS SQL'.

Comming soon...
  * Support for querying mysql archives for related discussions.


Feedbacks, suggestions and complaints should be directed to 
[EMAIL PROTECTED]


-
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

2003-02-09 Thread Cal Evans

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

2003-02-09 Thread Hawk

At 04:13 PM 2/7/2003 +, you wrote:

We sell a data converter for this purpose check out www.bpenet.net




I'm not concern about transferring the data.  I was having problems 
creating the indexes.

thanks for the reply...


Michael Johnson
Managing Director
Humphrey Consulting Limited BPEnet
Tel/Fax: 0870 922 0247
email: [EMAIL PROTECTED]
websites: www.humphreyconsulting.co.uk  www.bpenet.net


-Original Message-
From: Hawk [mailto:[EMAIL PROTECTED]]
Sent: 06 February 2003 3:03 PM
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]
com
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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


---
[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

Re: converting MS SQL to MySQL

2003-02-09 Thread Insanely Great

The best way is to import data from MS SQL Server to MySQL. SQLyog at
http://www.webyog.com/sqlyog/download.html has a DTS like ODBC Wizard.

Try it out and all you data will be imported.

Insane

- Original Message -
From: Hawk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 8:33 PM
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

2003-02-09 Thread Bob Hall

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

Re: converting MS SQL to MySQL

2003-02-09 Thread mysql-list-bot

Hawk [EMAIL PROTECTED],

Do you think the following links may help?

* http://www.mysql.com/doc/en/Using_mSQL_tools.html
* http://www.mysql.com/doc/en/Using_InnoDB_tables.html

This was an automated response to your email 'converting MS SQL to MySQL'.
Final search keyword used to query the manual was 'converting MS SQL to'.

Feedbacks, suggestions and complaints about me should be 
directed to [EMAIL PROTECTED]

-
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

2003-02-09 Thread Veysel Harun Sahin

Take look at http://www.mysql.com/doc/en/CREATE_TABLE.html

[EMAIL PROTECTED] 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.

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


--
Your favorite stores, helpful shopping tools and great gift ideas. 
Experience the convenience of buying online with Shop@Netscape! 
http://shopnow.netscape.com/



-
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

converting MS SQL to MySQL

2003-02-08 Thread Hawk



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

converting MS SQL to MySQL

2003-02-07 Thread Hawk



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

Re: converting MS SQL to MySQL

Re: converting MS SQL to MySQL

Re: converting MS SQL to MySQL

RE: converting MS SQL to MySQL

RE: converting MS SQL to MySQL

Re: converting MS SQL to MySQL

Re: converting MS SQL to MySQL

Re: converting MS SQL to MySQL

Re: converting MS SQL to MySQL

converting MS SQL to MySQL

converting MS SQL to MySQL

11 matches

Site Navigation

Mail list logo

Footer information