×òÌìÎÊÁËÄã¡£´Ósqlite ÅúÁ¿µ¼³öÀ´µ½csvÎļþ
sqlite3 -header -csv db1 "select * from t1" >> t1.csv
sqlite3 -header -csv db2 "select * from t1" >> t1.csv
sqlite3 -header -csv db3 "select * from t1" >> t1.csv
ÈçºÎ°ÑcsvÎļþµ¼Èëµ ......
RT£¬·ÇĬÈϵÄdataĿ¼
Çó¾È£¡
Ð޸IJÎÊýdatadirÖ¸Ïò¿ÉÒÔÂú×ãÄãµÄÒªÇóÂð£¿
Èç¹û²»Ðеϰ£¬ÄÇ¿¼ÂÇÓÃÁ´½ÓÎļþĿ¼µÄģʽ°É
linux / unix Ï¿ÉÒÔµ¥¶ÀÖ¸¶¨Ã¿¸ö±íµÄĿ¼£¬µ«WINDOWSÖв»¿ÉÒÔ¡£
LINUX/UNIX ÏÂÄã¿ÉÒÔÓÃ
create table xxxx () DATA DIRECTORY = 'absolute path to directory& ......
·þÎñÉÌ˵ Mysql µÄ±àÂëÓ¦¸ÃÊÇutf8µÄµÄ£¬ÎÒ°ÑBlog Engine µÄÎļþÈ«²¿¸ÄΪutf8¸ñʽÁË£¬»¹ÊÇÂÒÂ룬ÇëÎÊÈçºÎ½â¾öÕâ¸öÎÊÌ⣿
http://www.hywh.net/blogfln/
°ï¶¥
<globalization>½Úµã£º
ÓÃÓÚÅäÖÃÓ¦ÓóÌÐòµÄÈ«Çò»¯ÉèÖᣴ˽ڵãÓм¸¸ö±È½ÏÖØÒªµÄÊôÐÔ£¬·Ö±ðÈçÏ£º
ÊôÐÔÃû ˵Ã÷
fileEncoding ¿ÉÑ¡ÊôÐÔ¡ ......
SQL code:
------------------------------------
--ÓÃ;£º·ÖÒ³´æ´¢¹ý³Ì(¶ÔÓÐÖ÷¼üµÄ±íЧÂʼ«¸ß)
--˵Ã÷£º
------------------------------------
CREATE PROCEDURE [dbo].[UP_GetRecordByPage]
@tblName varchar(255), -- ±íÃû
@fldName varchar(255), -- Ö÷¼ü×Ö¶ÎÃû
@PageSize int = 10, -- Ò³³ß´ç
@PageIndex ......
mysqlÔõô֪µÀÄĸö±í±»Ë,»òÕßIP ,½ø³ÌËø×Å?
show processlist;
²é¿´ÈÕÖ¾
»òÕß¿´
SQL code:
mysql> show status like "%Com_unlock_tables%";
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Com_unlock_tables | 1 |
+------------ ......
show profile cpu, block io for query 15 µÄ½á¹ûÌ«´ó£¬Ò»ÆÁÄ»×°²»Ï£¬Ï뽫½á¹ûÊä³öµ½Ò»¸öÎļþÉÏÔÙ¿´£¡
ûÓÐʲôºÃ°ì·¨£¬mysql.exe ±¾ÉíûÓУϣңÁ£Ã£Ì£ÅÄÇÖÖspool µÄÃüÁî¡£Èç¹ûÊǣףɣģΣϣףӣ¬ÔòÔÚËüµÄÃüÁîÐй¤¾ßµÄÊôÐÔÖаѣ£գƣƣţÒÉèÖøßһЩ¡£
Èç¹ûÊǣգΣɣØÖ®ÀàµÄ£¬µ¹ÊÇ¿ÉÒÔÓÃһЩtelnet µÄ¹¤¾ß±¾ÉíÓм ......