MySQL¶¯Ô±14000ÈËÇ©Ãû·´¶Ô¼×¹ÇÎÄSun½»Ò×
¾Ý¹úÍâýÌ屨µÀ£¬MySQLÊý¾Ý¿âµÄ¿ª·¢ÕßMichael WideniusÒÔ¼°²¿·ÖÏà¹ØÈËÊ¿½üÈÕÏòÅ·ÖÞ¡¢ÖйúÓë¶íÂÞ˹µÄ¼à¹Ü»ú¹¹Ìá½»Á˶Լ׹ÇÎÄ-Sun½»Ò׵ķ´¶ÔÒâ¼û£¬ÓдóÔ¼14000ÈËÔÚ¸ÃÒâ¼ûÉÏÇ©×Ö±íʾËûÃǶԴËÊÕ¹ºµÄ·´¶Ô¡£Å·ÃËίԱ»á´ËÇ°Ôø·´¶Ô¼×¹ÇÎÄÊÕ¹ºSun£¬µ«Õâһ¢¶ÏÉó²é»ú¹¹ÔÚ12ÔÂÓֳƣ¬¶Ô´Ë½»Ò×´ï³ÉÒ»¸öÂúÒâµÄ½á¹û±íʾÀÖ¹Û¡£Å·ÃËίԱ»á½«ÔÚ1ÔÂ27 ÈÕ×îÖÕ¾ö¶¨ÊÇ·ñ·ÅÐÐÕâÒ»½»Òס£
WindeniusÔÚÖÜÒ»Ïò¸÷¹ú¼à¹Ü»ú¹¹Ìá½»ÁËÕâ·Ý´øÓÐÇ©ÃûµÄÒâ¼û¡£ÔÚ¼×¹ÇÎĶÔÅ·Ã˱íʾÊÕ¹ºSun²»»áÓ°ÏìÕý³£¾ºÕùºó£¬ÕâÃû¿ª·¢Õß±ãÔÚÍøÕ¾·¢ÆðÁËÒ»Ïî·´¶Ô´Ë½»Ò׵Ļ¡£
·´Â¢¶ÏÂÉÊ¦Ôø±íʾ£¬ÈôÄÜ»ñµÃ´ó¹«Ë¾µÄÖ§³Ö£¬±ã»áÓ°ÏìÒ¡°Ú²»¶¨µÄ¼à¹Ü»ú¹¹×ö³ö¾ö¶¨¡£
MySQLÊÇÊý¾Ý¿âÊг¡µÄºó½øÈëÕߣ¬¸ÃÊг¡ÓÉIT¹«Ë¾¼×¹ÇÎÄ¡¢IBMÓë΢ÈíÕ¼Áì¡£MySQLµÄ½øÈëÀµÍÁËÊý¾Ý¿â²úÆ·µÄ¼Û¸ñ£¬Ò²¶¯Ò¡ÁËÕâЩ¾ÞÍ·¹«Ë¾µÄͳÖεØÎ»¡£
WideniusÊÇÓÐÃûµÄ¿ªÔ´Èí¼þ¿ª·¢Õߣ¬ËûÈ¥Äê´ÓSun¹«Ë¾´ÇÖ°£¬´´½¨ÁË×Ô¼ºµÄÊý¾Ý¿â¹«Ë¾Monty Program Ab¡£¶øSun¹«Ë¾ÔÚ2008Äê³â×Ê10ÒÚÃÀÔªÂòÏÂÁËMySQL¡£
WideniusÔÚÌá½»µÄÒâ¼ûÊéÖгƣ¬“Ç©ÃûÕß²»ÏàÐż׹ÇÎÄ»áÉÆ´ýMySQL¡£”Ëû±íʾ½«¼ÌÐø·´¶Ô¸Ã½»Ò×Ö±ÖÁ×îÖÕ½á¹û³ö¯¡£
Ç©Ãû»î¶¯µÄ·¢ÆðÈ˳ƣ¬Óг¬¹ý5000Ãû¸öÈË¿ª·¢ÕßÔÚ·´¶ÔÒâ¼ûÊéÉÏÇ©ÊðÁË×Ô¼ºµÄÃû×Ö£¬»¹ÓÐ3000¸öÇ©ÃûÀ´×ÔÄÇЩʹÓÃMySQLµÄ¹«Ë¾Óë»ú¹¹¹ÍÔ±¡£
ÕâЩǩÃûÔÚ·´¶Ô»î¶¯¿ªÊ¼µÄÒ»ÖÜÄÚÊÕ¼¯Íê³É£¬²¢±»Ìá½»ÖÁÅ·ÃËίԱ»á¡¢Å·ÖÞÒé»á¼°Å·ÃË27¸ö³ÉÔ±¹úµÄ¢¶ÏÉó²é»ú¹¹¡£»î¶¯·¢ÆðÕß»¹ÏòÖйúÉÌÎñ²¿Óë¶íÂÞ˹Áª°î·´Â¢¶Ï´¦Ìá½»ÁËÕâЩǩÃû¡£
24СʱҽÉúÔÚÏß×Éѯ
Ïà¹ØÎĵµ£º
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql ......
Ò»¹²ÓÐÈý¸öÀࣺWriteFile ; ReadFile ; InsertDB ;
//WriteFile.java
//ÓÃÓÚ½«ÐÅϢдÈëÎı¾Îļþ
package org.mb.insertfromfile;
import java.io.*;
public class WriteFile{
private int count = 0 ;
public int getCount() {
return count;
}
public void setCount(int count) {
this.cou ......
1.SELECT
*
from
table
LIMIT
1
,
20
;
//
¼ìË÷¼Ç¼ÐÐ
2-21
µÚÒ»¸ö²ÎÊý£º²éѯÆðʼÐУ¨´Ó0¿ªÊ¼£©
µÚ¶þ¸ö²ÎÊý£º²éѯ¼¸Ìõ¼Ç¼
2.
SELECT
*
from
table
LIMIT
5
,
-
1
;
//
&nbs ......
MySQL5.X¶¼ÒѾ·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵ쬯äʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾
Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃæ£¬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ
¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓë¼¼ÊõÎÞ¹ ......
MySQLµÄdatetimeÉèÖõ±Ç°Ê±¼äΪĬÈÏÖµ
ÓÉÓÚMySQLĿǰ×ֶεÄĬÈÏÖµ²»Ö§³Öº¯Êý£¬ËùÒÔÓÃ
create_time datetime default now()
µÄÐÎʽÉèÖÃĬÈÏÖµÊDz»¿ÉÄܵġ£
´úÌæµÄ·½°¸ÊÇʹÓÃTIMESTAMPÀàÐÍ´úÌæDATETIMEÀàÐÍ¡£
CURRENT_TIMESTAMP £ºµ±ÎÒ¸üÐÂÕâÌõ¼Ç¼µÄʱºò£¬ÕâÌõ¼Ç¼µÄÕâ¸ö×ֶβ»»á¸Ä±ä
¡£
CURRENT_TIMESTAMP O ......