phpѧϰ±Ê¼Ç£¨10£©:MYSQLÊý¾Ý¿âÖеij£ÓÃSQLÓï¾ä
MYSQLÊý¾Ý¿âÖеij£ÓÃSQLÓï¾ä
1¡¢SELECT ²éѯÓï¾äºÍÌõ¼þÓï¾ä
SELECT ²éѯ×Ö¶Î from ±íÃû WHERE Ìõ¼þ
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£º Êý¾Ý¿â.±íÃû £¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEEN ÔÚ·¶Î§ ¡¢ not BETWEEN ²»ÔÚ·¶Î§ < ¡¢>
Ìõ¼þÔËË㣺 and ¡¢ or ¡¢ ( )
2¡¢ÅÅÐò,·Ö×é,Ö¸Õë²éѯ,¼ÆËã
·Ö×éÓï¾ä£ºgroup by ×Ö¶Î --ÔÚorder֮ǰ
ÅÅÐòÓï¾ä£ºorder by ×ֶΣ¬×Ö¶Î ASC / DESC --ÔÚlimit֮ǰ
Ö¸Õë²éѯ£ºlimit ³õʼֵ£¬½áÊøÖµ --Óï¾ä×îºó
¼ÆË㣺
COUNT(*) ͳ¼Æº¯Êý
MAX(*) ×î´óÖµº¯Êý
MIN (*) ×îСֵº¯Êý
AVG(*) ƽ¾ùÖµº¯Êý
SUM(*) ÀÛ¼ÆÖµº¯Êý£¨∑£©
3¡¢Insert ²åÈëÓï¾ä
insert into ±íÃû (×Ö¶Î…,…) values(Öµ…,…)
insert into ±íÃû values(Öµ…,…)
4¡¢Update ¸üÐÂÓï¾ä
UPDATE ±íÃû SET ×Ö¶Î = Öµ WHERE Ìõ¼þ £¨limit¿ÉÓпÉÎÞ£©
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEEN ÔÚ·¶Î§ ¡¢ not BETWEEN ²»ÔÚ·¶Î§
Ìõ¼þÔ¤Ë㣺 and ¡¢ or ¡¢ ( )
5¡¢Delete ɾ³ýÓï¾ä
DELETE from ±íÃû WHERE Ìõ¼þ £¨limit¿ÉÓпÉÎÞ£©
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEEN ÔÚ·¶Î§ ¡¢ not BETWEEN ²»ÔÚ·¶Î§
Ìõ¼þÔ¤Ë㣺 and ¡¢ or ¡¢ ( )
¸´Ï°
Ïà¹ØÎĵµ£º
°²×°ºÃmysqlºó£¬ÔÚʹÓÃmysqʱ£¬³öÏÖÁËÈçÏÂÎÊÌâ.
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2 ......
ÖÐÎÄÏÔʾÎÊÌâÒ»Ö±ÊÇÀ§ÈÅÎÒÃǵÄÒ»¸öÄÑÌ⣬²»ÐÅÄãÉÏgoogleËÑË÷һϣ¬ÕâÀàµÄÎÊÌâºÍ½â´ð¿ÉÒÔ˵ÊÇÆÌÌì¸ÇµØ£¬ºÃ¶àÍøÕ¾ÉõÖÁ½«ÆäÌá³öÀ´×÷ΪרÌâÀ´ÌÖÂÛ£¬¹ÜÖпú±ª£¬¿É¼ûÒ»°ß¡£
¿ªÊ¼Ò²ÔøÎªÕâ¸öÎÊÌâÍ·ÌÛ£¬ÉÏÍø²éÔÄ´óÁ¿µÄ×ÊÁϺͽâ¾ö·½·¨£¬ÖÕÓÚÕÒµ½ÁËÒ»Öּȼòµ¥ÓÖºÃÓõİ취£¬ÒÔJSP+MYSQL´æ´¢ÎªÀý£¬¼òµ¥½éÉÜÒ ......
/***************************************************
×÷Õߣºherowang(ÈÃÄãÍû¼ûÓ°×ÓµÄǽ£©
ÈÕÆÚ£º2010.1.1
×¢£º ×ªÔØÇë±£Áô´ËÐÅÏ¢
& ......
<?php
function vCode($num=4,$size=20, $width=0,$height=0){
!$width && $width = $num*$size*4/5+5;
!$height && $height = $size + 10;
// È¥µôÁË 0 1 O l µÈ
$str = "23456789abcdefghijkmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVW";
$code ......