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

php mysql»Ø¹öʾÀý

Ê×ÏÈ£¬½¨InnoDBÀàÐÍµÄ±í£¬²ÅÄÜÖ§³ÖÊÂÎñ
$handler = mysql_connect('localhost', '', '');
mysql_select_db('test');
mysql_query('SET AUTOCOMMIT=0'); // ÉèÖÃΪ²»×Ô¶¯Ìá½»²éѯ
mysql_query('START TRANSACTION'); // ¿ªÊ¼²éѯ£¬ÕâÀïÒ²¿ÉÒÔʹÓÃBEGIN
mysql_query("INSERT INTO users VALUES ('ccc')");
mysql_query("DELETE from users WHERE username = 'aac'");
if (mysql_affected_rows($handler) == 0)
mysql_query('ROLLBACK'); // Èç¹ûɾ³ýδÕÒµ½ÏàÓ¦µÄ¼Ç¼Ôò»Ø¹ö£¬²»Ö´ÐÐÉÏÃæµÄ²åÈë²éѯ
mysql_query('COMMIT');
mysql_close($handler);


Ïà¹ØÎĵµ£º

MySQL ´æ´¢ schema lessµÄÊý¾Ý

from timyang¡¯s blog ×ÛºÏÈ¡ÉᣬʹÓÃMySQLÀ´´æ´¢key/value(schema-less)Êý¾Ý,valueÖпÉÒÔ·Å£º
Python dict
JSON object ʵ¼Êfriendfeed´æ·ÅµÄÊÇzlibѹËõµÄPython dictÊý¾Ý£¬µ±È»ÕâÖÖ°ó¶¨Ò»ÖÖÓïÑÔµÄ×ö·¨¾ßÓÐÕùÒéÐÔ¡£ ......

ÈÃMySQLÊý¾Ý¿â·þÎñÆ÷Ö§³ÖÔ¶³ÌÁ¬½Ó

1¡¢ÔÚ¿ØÖÆÌ¨Ö´ÐÐ mysql -u root -p mysql£¬ÏµÍ³ÌáʾÊäÈëÊý¾Ý¿ârootÓû§µÄÃÜÂ룬ÊäÈëÍê³Éºó¼´½øÈëmysql¿ØÖÆÌ¨£¬Õâ¸öÃüÁîµÄµÚÒ»¸ömysqlÊÇÖ´ÐÐÃüÁµÚ¶þ¸ömysqlÊÇϵͳÊý¾ÝÃû³Æ£¬²»Ò»ÑùµÄ¡£
2¡¢ÔÚmysql¿ØÖÆÌ¨Ö´ÐÐ GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPassword' WITH GRANT OPTION;
3¡¢ÔÚmysql¿ØÖÆ ......

VB6.0ÈçºÎÓà libmySQL.dll API·ÃÎÊMYSQLÊý¾Ý¿â

MYSQL Ó¦ÓÃÊ®·Ö¹ã·¶£¬ºÜ¶àÍøÕ¾¼¸ºõ¶¼ÔÚÓÃËû£¬ÒòΪËûµÄСÇɺÍÁé»îÐԵȷ½ÃæÈÃÎÒ¾ö¶¨Òª¶ÔËû½øÐÐÑо¿£¬µ½ÏÖÔÚÒѾ­³É¹¦µÄ²»Óþ­¹ýODBC£¬ADOµÈ·½Ê½¾Í¿ÉÒÔ¶ÁÈ¡ºÍ¸üÐÂÊý¾Ý¡£
 
ºÃÁ˲»¶àÂÞ࣬ÒÔÏÂÎÒÀ´½éÉÜ×ܸö³ÌÐòµÄϸ½Ú:
 
£¨Ò»£©APIÉùÃ÷
 
1.  '·ÖÅä»ò³õʼ»¯ÊʺÏmysql_real_connect()µÄÒ»¸öMYSQL¶ÔÏñ¡ ......

mysql sqlÓï¾äÖеÄlimitÓ÷¨

1¡¢select * from tablename <Ìõ¼þÓï¾ä> limit 100,15
´Ó100Ìõ¼Ç¼ºó¿ªÊ¼(²»°üÀ¨µÚ100Ìõ¼Ç¼)È¡³ö15Ìõ¼Ç¼ (ʵ¼ÊÈ¡³öµÄÊÇµÚ 101-115Ìõ¼Ç¼Êý¾Ý) 
2¡¢select * from tablename <Ìõ¼þÓï¾ä> limit 15
È¡³ö ǰ15Ìõ¼Ç¼Êý¾Ý,limit 15Ï൱ÓÚ limit 0,15 ......

jquery php ajax json

just get a json
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<mce:script src="jquery-1.3.2.min.js" mce_src="jq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ