mysqlûÓÐÏìÓ¦ - PHP / »ù´¡±à³Ì
ÎÒ֮ǰ°²×°µÄÊÇwamp¼¯³É°ü ¿ª·¢phpÓÃµÄ ÏÖÔÚÏëÊÖ¶¯´î½¨¸ö»·¾³ ÔÚmysql°²×°µ½×îºóÒ»²½ÊdzöÏÖ
ûÓÐÏìÓ¦
Çë¸÷λ´óÏÀ²»Áߴͽ̣¡
ÊDz»ÊÇ»úÆ÷µÄÔÒò°¡£¬ÎҼǵÃÒÔǰÔÚÄÄÀï¿´¹ýÕâÖÖÇé¿ö£¬²»¹ýÄÇÊǺܾÃÒÔǰµÄÊÂÇéÁË
ÖØÆôµçÄÔÔÙ°²×°ÊÔÊÔ....
Â¥Ö÷£¬ÒªÊÇÅäÖõ½×îºóÒ»²½³öÏÖ²»ÄÜÆô¶¯·þÎñµÄ´íÎóµÄ»°£¬ÄǹÀ¼ÆÄãÔÀ´ÔÚ»ú×ÓÉÏ×°¹ýMySql£¬ÐèÒª°ÑMySql³¹µ×ɾ³ý£¬¾Í¿ÉÒÔ½â¾öÎÊÌâÁË¡£Ï£Íû¿ÉÒÔ°ïµ½Äã¡£
¼ì²éÒ»ÏÂÄãµÄMYSQLµÄ´íÎóÈÕÖ¾¡£
Óöµ½¹ýͬÑùµÄÎÊÌ⣬һֱ¹Ò×Å£¬Ëü×îºó»á×°ÍêµÄ
......
Ïà¹ØÎÊ´ð£º
zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£
»òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£
ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1
ÎÞ½â
ÒýÓÃ
ÎÞ½â
²»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿
SELECT time, goodid from ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
/ ......