a±íÖÐÓУ¨a1£¬b1£¬c1,a2,a3£©b±íÖÐÓУ¨b1,b2,b3£©c±íÖÐÓУ¨c1,c2,c3£©ÔÚ¶ÁÈ¡a1±íµÄͬʱ£¬ÔõôµÃµ½b1µÄ¶ÔÓ¦µÄB2,B3£¬
ÎÒµÄÒ»¸ötable±íÖÐÓõÄbµÄÃû³Æ£¨b2£©ºÍcµÄÃû³Æ£¨c2£©ºÍ£¨a1£¬a2£¬a3£©
ÏÖÔÚÎÒÒªÔõôдsqlÓï¾äµÃµ½£¬Íâ¼üb1µÄ¶ÔÓ¦µÄÊôÐÔ
µÈ´ý£¬
ÒýÓÃÎÒµÄÒ»¸ötable±íÖÐÓõÄbµÄÃû³Æ£¨b2£©ºÍcµÄÃû³Æ£¨c2£©ºÍ£ ......
¹«Ë¾µÄMYSQL·þÎñÆ÷Ò»Ö±±¨´í£º¡°Got error 134 from storage engine¡±£¬Çë½Ì¸ßÊÖÕâÊÇʲôÔÒò£¬Óнâ¾ö°ì·¨Âð£¿
REPAIR TABLE xxx һϡ£
SQL code:
C:\Documents and Settings\zxh>perror 134
MySQL error code 134: Record was already deleted (or record file crashed)
Win32 error code 134: ÊÔͼÔÚÒѱ»ºÏ²¢µ ......
¸ÃÎÊÌâȷʵÓеãÀÏÌ×ÁË!µ«ÊÇÒ²»¹ÊÇûÓеõ½ºÜºÃµÄ´¦Àí°ì·¨
»·¾³ÊÇRed hat linux, mysql 5.1.30
mysqldump±¸·ÝÊý¾Ý¿â,Êý¾Ý¿âµÄ×Ö·û¼¯¸÷Ïî²ÎÊýÈçÏÂ:
+--------------------------+-----------------------------------+
| Variable_name | Value & ......
ËÖªµÀMySQLÖ§³ÖÄļ¸ÖÖÒýÇæ,°ïÎÒÃèÊöÒ»ÏÂËûÃǵÄÓÅÁÓ
rt£¡
»òÕßÄãÓ¦¸Ã×Ô¾õµØ×ªÈ¥ MySQL Çø£¬¾Í²»»á±»ÀäÂäÁË¡£
¿´ÄãÕâÎÊÌ⣬¾ÍÖªµÀÄã¸ù±¾²»Á˽âÊý¾Ý¿â£¬Ò²Ã»Óж¯ÊÖ¡£Ö§³ÖÄļ¸ÖÖÒýÇæ£¿Äã×°¸ö MySQL5 ²»¾ÍÖªµÀÁË¡£
×î³£ÓõÄÊÇ MyISAM ¡¢ InnoDB ¡¢ Memory£¬ÓÅÁÓÖ»ÊǼòµ¥ËµËµ£¬¾ßÌåµÄ×Ô¼ºÔٰٶȹȸ衣
......
mysqlÔõÑùÅúÁ¿µ¼ÈëCSVÎļþ
ллָ½Ì
µ¥Ò»CSVÎļþµ¼Èë
LOAD DATA LOCAL INFILE 'C:/LT.csv'
IGNORE
INTO TABLE TEMP_LTCSV
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
ÎÒÖ»»áJSP°¡
Èç¹ûÓÐÏֳɵÄPHP´úÂë¿ÉÒÔ¸øÎÒÂð£¿
Ð ......
ÈçÌâ ѸÀ×ÏÂÔØ½ø¶ÈΪ0 ÇëÎÊÊÇÔõô»ØÊ°¡ »òÕßËÓеϰÄÜ·ñ¸øÎÒ´«Ò»Ï ÎÒÏëÓÃ5.1°æµÄ Red Hat Enterprise Linux 4 RPM (AMD64 / Intel EM64T)
²»ÐèҪע²á¡£Ö±½ÓÏÂÔØ¾ÍÐÐÁË¡£
http://dev.mysql.com/downloads/mysql/5.1.html
Linux (non RPM packages)
Linux (non RPM, Intel C/C++ compiled, glibc-2. ......