Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

php°²È«-²»ÓùýÂËmysqlÓïÑÔ°²È«Âð£¿

PHPÖУ¬Ê¹ÓÃmysqlÊý¾Ý¿â,Linuxϵͳ¡£
ÔÚʹÓÃËÑË÷¹¦ÄÜʱ£¬Ö±½ÓÖ´ÐÐÕâÑùµÄÓï¾ä°²È«Âð£¿
$keyword=$_POST["keyword"];
$sql="select * from abc where a_name like '%$keyword%'";
$rs=mysql_query($sql);
.....
Èç¹û²»°²È«£¬Ó¦¸ÃÔõô¹ýÂË£¿Ð»Ð»
²»ÊÇ×ö¿ª·¢µÄ ¶ÔÕâ¸ö²»ÊìϤ

$keyword = trim($ke ......

MysqlµÄÖ÷»úÃûÎÊÌâ

ÎÒ×¢²áµÄÍøÕ¾Ê¹ÓÃPhpMyadmin×÷Ϊ¹ÜÀíÆ÷
ÏÔʾ ·þÎñÆ÷: hostingdb.limedomains.com via TCP/IP
ÇëÎÊÎÒÔÚPHPÖÐÈçºÎÌîд$server
Õâ¸ö²»¾ÍÊÇÓòÃûÂ𣨿ÉÄÜÊDZ¾µØÓòÃû£©
Ö±½ÓÓÃhostingdb.limedomains.com·ÃÎʾÍÊÇÁË ¾Í¸úÔÚÄã×Ô¼ºµÄ»úÆ÷ÉÏʹÓÃlocalhostÁ¬½ÓÒ»Ñù

ÔÙ˵Äã×¢²áµÄÄǸöÍøÕ¾ ÄãÔõô²»ÎÊһϿͻ§ÔõôÁ¬½ÓÊ ......

MySQL ÊÂÎñµÄÎÊÌâ

PHP code:

<?php
include("config.inc.php");
$db=new db();
echo date('h:i:s') . "<br />";
$db->execute("begin");
$rs=$db->getRs("select * from book where sum>0 and id =1");
sleep(5);
if($rs->rowCount())//Èç¹û´æÔڿɽèµÄÊé¼®
$d ......

mysql×ֶ㤶È

int
varchar
text
date
³¤¶È/Öµ1

Õâ¸ö³¤¶ÈÖµÊÇʲôÒâ˼£¿£¿

±ÈÈçÎÒ varchar ÉèÖÃ10000 ÊDz»ÊǾÍÊÇÒ»Íò¸ö×Ö·û£¿£¿£¿
int 10000¾ÍÊǵ½1Íò£¿£¿£¿

Äܲ»ÄÜÏêϸ½âÊÍÏÂ
ÔÎ varchar×ֻÄÜÊÇ255 ÄãÄÜÉèÖÃ10000£¿

¿´¿´Õâ¸ö²©¿Í רÃŽ²Mysql×ֶγ¤¶ÈµÄ
http://blog.csdn.net/abaowu/ ......

¹ØÓÚmysql²éѯÓï¾ä ÎҺܲˣ¡

ÔÚÒ»¸ö½Ì³ÌÉÏ¿´µ½ÈçÏ´úÂ룺

        $db = 'samples';
mysql_select_db($db) or die('Could not select database ('.$db.') because of : '.mysql_error());
echo ' <b>µÚ¶þ²½: </b> ³É¹¦Á¬½Óµ½ ('.$db.') ! <BR>';
......

PerlÖÐÁ¬½ÓMySQLÎÊÌâ

ÇëÎʸßÊÖ£¬ Perl Á¬½ÓMySQLʱ£¬Óï¾äÈçÏ£º
use DBI;
my $dbh = DBI->connect("dbi:mysql:testsql:localhost,port=3306","root","abc");
print "success";
$dbh->disconnect;

µ«ÊÇÔÚ±àÒëʱ»áÓöµ½ÈçÏ´íÎóÌáʾ£º
install_driver(mysql) failed: C ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [58] [59] [60] [61] 62 [63] [64] [65] [66] [67]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ