[root@www]# /usr/local/mysql/bin/mysql -u root -p mydb <mydb.dump
3g(Tr f M Wx7I
Uwww.linuxeden.comEnter password:
4ve$K'K z;{&? |.bERROR 1049:Unknow database 'mydb'
6_n uP P2g/y pU.G这是怎么回事？？？下面是一个测试ＭＹＳＱＬ的程序：
www.linuxeden.com6D7A
o;wNT,gv
安装MySQL后，建立一个mydb.dump文件，包含入下内容：
!b xq'|a8^Y
1X0`4F*Y5WN`CREATE TABLE employees ( id tinyint(4) DEFAULT '0' NOT NULL
9E ^ `#K Z'E5b ~www.linuxeden.comAUTO_INCREMENT, first varchar(20), last varchar(20),
8x }9S
r N9|C,XLinux伊甸园论坛address varchar(255), position varchar(50), PRIMARY KEY (id),
Linux伊甸园论坛j:}1J1F*g"X M,B5c
UNIQUE id (id));
|8}0GP+z],W-[INSERT INTO employees VALUES (1,'Bob','Smith',
R7}G E-sw6`*j@'128 Here St, Cityname','Marketing Manager');
&| E#@+b` ?7B5ZqU1MLinux伊甸园论坛
4h9Y'RjK?tcINSERT INTO employees VALUES (2,'John','Roberts','45 There St,
Ho a FqK$uTownville','Telephonist');
e0c u5v]"F"O~ P
;i7cR%gnqwww.linuxeden.comINSERT INTO employees VALUES (3,'Brad','Johnson','1/34 Nowhere Blvd,
4M x*E }9h
na1x
Snowston','Doorman');
C%z(P^)JLinux伊甸园论坛Mv[2O)m
X
MJ.c%D^然后用这个SQL脚本在MySQL中创建一个数据库mydb，在shell下打入下列命令：
cS xJ3{t
mysql -u root -pyourpasswd mydb <mydb.dump
*H:wb!W]gLinux伊甸园论坛
,f \D t G/g%cW创建后上述数据库后，创建一个php3脚本文件，如test.php3，其内容如下：
&W5{8c)m8w!y5r4Q^v6t,h E[
<html>
$RsL w~1Y/j2].[8~5i Ytc@;G
<body>
y F8@/HI!B
1T9i5I |1\-s<?php
Linux伊甸园论坛 jk)K*Ht
d"^Q(T r%i i
|
$db = mysql_connect("localhost", "root","12345");
H} I-K {.na-j
#^f1BB*Q5M2T _mysql_select_db("mydb",$db);
l}R8s_1mwww.linuxeden.com
Sr*FDq1x p[Y t s$result = mysql_query("SELECT * FROM employees",$db);
!v&F3w;L2Q6_
f;]O*}0Os.kl6|www.linuxeden.comprintf("First Name: %s<br>\n", mysql_result($result,0,"first"));
www.linuxeden.com3\}1\-O X A/Q] H
J"]
"xu E(g(J.|
printf("Last Name: %s<br>\n", mysql_result($result,0,"last"));
P s$p)e3L {M
#_N3i.s;fs ~printf("Address: %s<br>\n", mysql_result($result,0,"address"));
)OnXRNh2S!}1~1P
e7M4|!W ^d1J2ODwww.linuxeden.comprintf("
osition: %s<br>\n", mysql_result($result,0,"position"));
m
vR;w/}A6S8Tt}
]"b6F
C6hL p.W?>
www.linuxeden.com
O9c0~)wD
w6Rs P
www.linuxeden.com t0L r0i7t&} pc?&o'd
</body>
W{-[S)R+g'?4X.VF?@ jl}
</html>
ZPm9Y%q4^bC
CD2p lU1G7pLinux伊甸园论坛
9g
}D [!A6H&x,B"{Linux伊甸园论坛
[
M#|"`O P!J其显示的结果应该是：
Ux2j SHQLinux伊甸园论坛
5uu!G7U3u2KFirst Name: Bob
Linux伊甸园论坛!jt| s,L q%}
L
Last Name: Smith
Tq F0L$zHbLinux伊甸园论坛Address: 128 Here St, Cityname
#}&NF
d ix}ALinux伊甸园论坛Position: Marketing Manager
{;s,y a:GF)u QOwww.linuxeden.comN h7i
q
F+k1V}j2k9H V
请问有没有什么问题？？？
2[u1n
a i
