请教数据库高手sql2000和mysql有什么区别？？

EasonHoi 2003-12-10 12:09:06

他们的操作命令好像都一样啊？？
那么他们建出来的表有什么区别？格式一样不？
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

...全文

208 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

happydreamer 2003-12-13

打赏
举报

上面有点错 ;)
应该是
c:\mysql\bin> mysql -uroot -ppassword
大多数的T-SQL命令都能用的

看看这个
http://www.mysql.com/doc/en/MySQL_4.1_Nutshell.html

happydreamer 2003-12-13

打赏
举报

php可以这样连接mysql
example: config.inc.php

<? //==========================================

// db_type: mysql

// connect to db: host user pass

$mysql_db_host = "localhost";

$mysql_db_user = "root";

$mysql_db_pass = "1234";

// db_name:

$db_cluster = "gonghui";

//==========================================

$db = mysql_connect($mysql_db_host, $mysql_db_user, $mysql_db_pass);

$link = mysql_select_db($db_cluster);

function errorbig($message)

{

echo "<script>alert('$message')</script>";

echo "<script>window.history.back(-1);</script>";

exit;

}

function echostr($str,$titlelen) {

$len = strlen($str);

if ($len <= $titlelen):

$title = $str;

else:

$title = substr($str,"0","$titlelen");

$parity= 0;

for($i=0;$i<$titlelen;$i++){

$temp_str=substr($title,$i,1);

if(Ord($temp_str)>127) $parity+=1;

}

if($parity%2==1) $title=substr($title,0,($titlelen-1));

else $title=substr($title,0,$titlelen);

endif;

echo $title;}

$pagesize=25;

function alertjump($message,$topage)

{

echo "<script>alert('$message')</script>";

echo "<script>document.location='$topage';</script>";

exit;

}

?>

happydreamer 2003-12-13

打赏
举报

命令行方式下登录mysql数据库是这样的
c:\> cd mysql\bin
c:\> mysql -uroot -ppassword
...

mysql 执行语句后面要加 ;
mysql 删除记录要 delete from tablename ,delete tablename 不行
mysql 不能 select * into newtable from oldtable
mysql 自增列不是identity 要这样创建
create table test (id int(8) primary key auto_increment)
.....

你可以找本书看看

EasonHoi 2003-12-13