Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Óû§ÈÏ֤ЭÒé¸ü»»£¨mysqlʹÓÃÎÊÌâ)

°²×°ºÃ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 ......

MYSQLÊý¾Ý¿âµÄÖÐÎÄÎÊÌâ

      ÖÐÎÄÏÔʾÎÊÌâÒ»Ö±ÊÇÀ§ÈÅÎÒÃǵÄÒ»¸öÄÑÌ⣬²»ÐÅÄãÉÏgoogleËÑË÷һϣ¬ÕâÀàµÄÎÊÌâºÍ½â´ð¿ÉÒÔ˵ÊÇÆÌÌì¸ÇµØ£¬ºÃ¶àÍøÕ¾ÉõÖÁ½«ÆäÌá³öÀ´×÷ΪרÌâÀ´ÌÖÂÛ£¬¹ÜÖпú±ª£¬¿É¼ûÒ»°ß¡£
¿ªÊ¼Ò²ÔøÎªÕâ¸öÎÊÌâÍ·ÌÛ£¬ÉÏÍø²éÔÄ´óÁ¿µÄ×ÊÁϺͽâ¾ö·½·¨£¬ÖÕÓÚÕÒµ½ÁËÒ»Öּȼòµ¥ÓÖºÃÓõİ취£¬ÒÔJSP+MYSQL´æ´¢ÎªÀý£¬¼òµ¥½éÉÜÒ ......

ÔÚSQL SERVERÖÐʵÏÖRSA¼ÓÃÜËã·¨

/***************************************************  
          ×÷Õߣºherowang(ÈÃÄãÍû¼ûÓ°×ÓµÄǽ£©
    ÈÕÆÚ£º2010.1.1
          ×¢£º    ×ªÔØÇë±£Áô´ËÐÅÏ¢
  & ......

PHP×Ô¶¨Òå´óСÑéÖ¤Âë

<?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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ