mysql µÄ ÄÚ´æ±íºÍÁÙʱ±í
1 ÄÚ´æ±íµÄ±í»ú¹¹»¹ÊÇÔÚÊý¾Ý¿âÖеģ¬Ö»ÊÇÊý¾Ýʱ·ÅÔÚÄÚ´æÖеġ£
2 ÄÚ´æ±íÖв»¿ÉÒÔʹÓÃTEXTºÍBLOBÀàÐ͵Ä×ֶΡ£
3 ÄÚ´æ±í¿ÉÒÔͨ¹ýmax_heap_table_size = 2048MÀ´¼Ó´óʹÓõÄÄÚ´æ¡£
1 ÁÙʱ±íµÄ±í»ú¹¹ºÍÊý¾Ý¶¼ÊÇ·ÅÔÚÄÚ´æÖеÄ
¾ßÌå¼ûÏ£º
ÄÚ´æ±íʹÓùþϣɢÁÐË÷Òý°ÑÊý¾Ý±£´æÔÚÄÚ´æÖУ¬Òò´Ë¾ßÓм«¿ìµÄËÙ¶È£¬Êʺϻº´æÖÐСÐÍÊý¾Ý¿â¡£
¹Ù·½ÊÖ²á¶ÔÄÚ´æ±íÓÐÒÔϵÄһЩ½âÊÍ£º
The MEMORY storage engine creates tables with contents that are stored in memory. Formerly, these were known as HEAP tables. MEMORY is the preferred term, although HEAP remains supported for backward compatibility.
Each MEMORY table is associated with one disk file. The filename begins with the table name and has an extension of .frm to indicate that it stores the table definition.
1¡¢heap¶ÔËùÓÐÓû§µÄÁ¬½ÓÊǿɼûµÄ£¬ÕâʹµÃËü·Ç³£ÊʺÏ×ö»º´æ¡£
2¡¢½öÊʺÏʹÓõij¡ºÏ¡£heap²»ÔÊÐíʹÓÃxxxTEXTºÍxxxBLOBÊý¾ÝÀàÐÍ£»Ö»ÔÊÐíʹÓÃ=ºÍ<=>²Ù×÷·ûÀ´ËÑË÷¼Ç¼£¨²»ÔÊÐí& amp; lt;¡¢>¡¢<=»ò>=£©£»mysql4.1°æ±¾Ö®Ç°²»Ö§³Öauto_increment£»Ö»ÔÊÐí¶Ô·Ç¿ÕÊý¾ÝÁнøÐÐË÷Òý£¨not null£©¡£
×¢£º²Ù×÷·û “<=>” ˵Ã÷£ºNULL-safe equal.Õâ¸ö²Ù×÷·ûºÍ“=”²Ù×÷·ûÖ´ÐÐÏàͬµÄ±È½Ï²Ù×÷£¬²»¹ýÔÚÁ½¸ö²Ù×÷Âë¾ùΪNULLʱ£¬ÆäËùµÃֵΪ1¶ø²»ÎªNULL£¬¶øµ±Ò»¸ö²Ù×÷ÂëΪNULLʱ£¬ÆäËùµÃֵΪ0¶ø²»ÎªNULL¡£
3¡¢Ò»µ©·þÎñÆ÷ÖØÆô£¬ËùÓÐheap±íÊý¾Ý¶ªÊ§£¬µ«ÊÇheap±í½á¹¹ÈÔÈ»´æÔÚ£¬ÒòΪheap±í½á¹¹ÊÇ´æ·ÅÔÚʵ¼ÊÊý¾Ý¿â·¾¶Ïµģ¬²»»á×Ô¶¯É¾³ý¡£ÖØÆôÖ®ºó£¬heap½«±»Çå¿Õ£¬Õâʱºò¶ÔheapµÄ²éѯ½á¹û¶¼Êǿյġ£
4¡¢Èç¹ûheapÊǸ´ÖƵÄijÊý¾Ý±í£¨´´½¨ÆÕͨÓû§±íÕâЩҲ»á¶ªÊ§£©£¬Ôò¸´ÖÆÖ®ºóËùÓÐÖ÷¼ü¡¢Ë÷Òý¡¢×ÔÔöµÈ¸ñʽ½«²»¸´´æÔÚ£¬ÐèÒªÖØÐÂÌí¼ÓÖ÷¼üºÍË÷Òý£¬Èç¹ûÐèÒªµÄ»°¡£
5¡¢¶ÔÓÚÖØÆôÔì³ÉµÄÊý¾Ý¶ªÊ§£¬ÓÐÒÔϵĽâ¾ö°ì·¨£º
¡¡a¡¢ÔÚÈκβéѯ֮ǰ£¬Ö´ÐÐÒ»´Î¼òµ¥µÄ²éѯ£¬ÅжÏheap±íÊÇ·ñ´æÔÚÊý¾Ý£¬Èç¹û²»´æÔÚ£¬Ôò°ÑÊý¾ÝÖØÐÂдÈ룬»òÕßDROP±íÖØÐ¸´ÖÆÄ³ÕÅ±í¡£ÕâÐèÒª¶à×öÒ»´Î²éѯ¡£²»¹ý¿ÉÒÔд³ÉincludeÎļþ£¬ÔÚÐèÒªÓøÃheap±íµÄÒ³ÃæËæÊ±µ÷Ó㬱ȽϷ½±ã¡£
¡¡b¡¢¶ÔÓÚÐèÒª¸Ãheap±íµÄÒ³Ãæ£¬ÔÚ¸ÃÒ³ÃæµÚÒ»´ÎÇÒ½öÔÚµÚÒ»´Î²éѯ¸Ã±íʱ£¬¶ÔÊý¾Ý¼¯½á¹û½øÐÐÅжϣ¬Èç¹û½á¹ûΪ¿Õ£¬ÔòÐèÒªÖØÐÂдÈëÊý¾Ý¡£ÕâÑù¿ÉÒÔ½Úʡһ´Î²éѯ¡£
¡¡c¡¢¸üºÃµÄ°ì·¨ÊÇÔÚmysqlÿ´ÎÖØÐÂÆô¶¯Ê±×Ô¶¯Ð´ÈëÊý¾
Ïà¹ØÎĵµ£º
mysql> grant ȨÏÞ1,ȨÏÞ2,¡È¨ÏÞn on Êý¾Ý¿âÃû³Æ.±íÃû³Æ to Óû§Ãû@Óû§µØÖ· identified by ¡®Á¬½Ó¿ÚÁ; ȨÏÞ1,ȨÏÞ2,¡È¨ÏÞn´ú±íselect,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,fileµÈ14¸öȨÏÞ¡£µ±È¨ÏÞ1,ȨÏÞ2,¡È¨ÏÞn±»all privileges»òÕßall´úÌæ£¬±íʾ¸³ÓèÓû§È«²¿ ......
<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*,java.util.*"%>
<html>
<head>
<title>Á¬½ÓmysqlµÄjavabeanʵÀý+¼òµ¥·ÖÒ³</title>
<link href="../CSS.css" rel="stylesheet" type="text/css">
</head>
<body>
<jsp:useBean ......
½ñÌìÓÐÅóÓÑÎÊÆð´ËÀàÓï¾äµÄÓÅ»¯£¬ÎÒ´óÖ¸øËû½éÉÜÁËÏ´ÓSQL½Ç¶È×ö¼òµ¥µÄÓÅ»¯£¬ÖÁÓÚÓ¦ÓóÌÐò·½ÃæµÄ¿¼ÂÇÔÛÔÝʱ²»¿¼ÂÇ¡£
ÏÂÃæÎÒÀ´¾ÙÒ»¸ö
¼òµ¥µÄÀý×Ó¡£
¿¼ÂÇÈçÏÂ
±í½á¹¹£º
/*DDL Information
For - t_girl.t_page_sample*/
----------------------------------------------
Table ......
PHPµÄÒ»¸öÊý¾Ý¿â²Ù×÷Àà,ÒÔUTF8¸ñʽдÈë,Êý¾Ý¿âÄÚÖ±½ÓÏÔʾÕý³£ÖÐÎÄ,·ÀÖ¹²éѯ³ö´í
/**
* @author xggxnn
* ±¾ÀàÓÃÓÚʵÏÖÓйØÊý¾Ý¿âµÄ·ÃÎÊ
*
*/
class DBConnection {
private $host = "";
private $user = "";
private $pass = "";
private $DBname = "";
public $isConnected = false;
/**
* ¹¹Ôìº ......