Re: converting MS SQL to MySQL

2003-02-10 Thread Barry C. Hawkins
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

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.h

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'(

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

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

Re: converting MS SQL to MySQL

2003-02-09 Thread Insanely Great
ED]> 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 followi

RE: converting MS SQL to MySQL

2003-02-09 Thread Hawk
PEnet 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 S

RE: converting MS SQL to MySQL

2003-02-09 Thread Cal Evans
] 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) NUL

Re: converting MS SQL to MySQL

2003-02-09 Thread mysql-list
ed 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 b

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' VARC

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'