MySQL Forums
Forum List  »  Microsoft SQL Server

SQL on unix and on windows
Posted by: lenny quick
Date: July 11, 2004 07:00AM

I am a lil confused.. what is the difference between a unix server and a windows server running a SQL data base do they use different syntax? Is there a program that will convert the syntax so that it can be used on either server? I have this SQL data base that i want to use on a windows server.. but the hosting company i use.. well the admin for that company says that i can't use it because its for unix servers and that they have a windows server.. here is an example of the .sql file

CREATE TABLE tutorial_user_auth (
userID int(20) unsigned NOT NULL auto_increment,
userName varchar(15) NOT NULL default '0',
userPassword varchar(32) NOT NULL default '0',
userMail varchar(255) NOT NULL default '',
userQuestion varchar(255) NOT NULL default '',
userAnswer varchar(255) NOT NULL default '',
PRIMARY KEY (userID),
UNIQUE KEY userMail(userMail),
UNIQUE KEY userName(userName)
) TYPE=MyISAM;




I guess my question is how would i change the code so that i can get this data base running on a windows server?

oh .. i am also using php with this... here is the code for the php... do i need to change it also in some way to get it to work with a windows server?


<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Data passata
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
// sempre modificato
header("Cache-Control: no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
error_reporting(E_ALL);
$host = 'localhost';
$dbuser = '';
$dbpass = '';
$dbname = '';
$table = 'tutorial_user_auth';
$db = @mysql_connect($host,$dbuser,$dbpass) or die("error=could not connect to $host");
$db = mysql_select_db($dbname);
if(!$db)
{
print "error=could not connect to $dbname table";
exit;
}
?>

Options: ReplyQuote


Subject
Written By
Posted
SQL on unix and on windows
July 11, 2004 07:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.