0

win10 瀹夎 MySQL-5.7.28 璁板綍

[TOC] 涓銆佸畨瑁呭墠鍑嗗 1.浜戠洏涓嬭浇瀹夎鍖呬互鍙婂鎴风宸ュ叿 涓嬭浇鍦板潃锛 "MySQL 5.7.28 + SQLyog" 2.瀹樼綉涓嬭浇瀹夎鍖 涓嬭浇鍦板潃锛 "http://dev.mysql.com/downloads/installer/" 浜屻佸畨瑁呮楠 1.鎵ц瀹夎鍖 2.閫夋嫨瀹夎绫诲瀷 Deve ...

tester_ggf 鍙戝竷浜 2019-12-07 22:50 璇勮(0)闃呰(13)
0

centos瀹夎redis骞跺紑鍚涓猺edis瀹炰緥

1.涓嬭浇瀹夎鍖 涓嬭浇鍦板潃 锛 http://download.redis.io/releases/锛屽幓閲岄潰鎵惧搴旂殑鐗堟湰涓嬭浇 渚嬪 wget http://download.redis.io/releases/redis-5.0.0.tar.gz 2.瑙e帇 tar -zxf redis-5.0.0.t ...

AutoCoad 鍙戝竷浜 2019-12-07 17:16 璇勮(0)闃呰(6)
0

sql server 琛ㄨ繛鎺

鏁版嵁搴撴搷浣滀腑锛屾垜浠渶瑕佺殑缁撴灉鍙兘鍦ㄤ袱寮犺〃鐢氳嚦澶氬紶琛ㄤ腑锛岃繖鏃跺欏氨闇瑕佽〃杩炴帴鎿嶄綔锛屽琛ㄦ煡璇腑鐨勫悇涓〃涔嬮棿鐨勫瓧娈典細瀛樺湪杩炴帴锛屾瘮濡備富澶栭敭鍏宠仈锛屽彲浠ヤ娇鐢ㄤ富澶栭敭鏉ュ叧鑱旀瘡寮犺〃銆傝〃杩炴帴鏂瑰紡鏈変互涓嬪嚑绉嶏細 JOIN: 濡傛灉琛ㄤ腑鏈夎嚦灏戜竴涓尮閰嶏紝鍒欒繑鍥炶 LEFT JOIN锛堝乏杩炴帴锛: 鍗充娇鍙宠〃涓病鏈夊尮閰嶏紝涔熶粠宸﹁〃杩斿洖鎵鏈 ...

绱瀬榄旂灣 鍙戝竷浜 2019-12-07 15:04 璇勮(0)闃呰(11)
0

鏍规嵁鍏抽敭瀛楁煡鎵惧寘鍚鍏抽敭瀛楃殑瀛樺偍杩囩▼鍚

--鏍规嵁鍏抽敭瀛楁煡鎵惧寘鍚鍏抽敭瀛楃殑瀛樺偍杩囩▼鍚峉ELECT DISTINCT t1.name FROM SYSOBJECTS t1, SYSCOMMENTS t2WHERE t1.id = t2.idAND t1.xtype = 'P'AND t2.text LIKE '%鍏抽敭瀛%' ...

甯呰鐩楃増 鍙戝竷浜 2019-12-07 14:11 璇勮(0)闃呰(6)
0

MYSQL 娓告爣瀛︿範鍙婁娇鐢ㄥ疄渚

山西快三平台app—官方网址22270.COMwho?(娓告爣鏄粈涔?)娓告爣(cursor)瀹樻柟瀹氫箟锛氭槸绯荤粺涓虹敤鎴峰紑閫氱殑涓涓暟鎹紦鍐插尯锛屽瓨鏀緎ql鎵ц缁撴灉銆傛瘡涓父鏍囧尯閮芥湁涓涓悕瀛楋紝鐢ㄦ埛鍙互閫氳繃sql璇彞閫愪竴浠庢父鏍囦腑鑾峰彇璁板綍锛屽苟璧嬪肩粰鍙橀噺锛屼氦鐢变富璇█杩涗竴姝ュ鐞;涓汉鐞嗚В锛氭劅瑙夋父鏍囧拰鎸囬拡鐩镐技锛屾寚瀹氱粨鏋滈泦鍚庝竴琛岃鎵ц; why?(涓轰粈涔堣瀛︿範娓告爣)娓告爣 ...

stqian 鍙戝竷浜 2019-12-07 11:51 璇勮(0)闃呰(9)
0

鍒╃敤FOR XML PATH琛岃浆鍒楋紙鏍规嵁鏌愬瓧娈靛垎缁勶紝澶氳鏁版嵁杞垚涓琛岋紝骞剁敤閫楀彿闅斿紑锛

CREATE TABLE #TEST(A VARCHAR(10) NULL,B VARCHAR(MAX) NULL) INSERT INTO #TESTSELECT 'A','A001'UNION ALLSELECT 'A','A002'UNION ALLSELECT 'A','A003'UNION ...

甯呰鐩楃増 鍙戝竷浜 2019-12-07 11:27 璇勮(0)闃呰(10)
0

鏁版嵁搴撳浠姐佽繕鍘熴佸垹闄ゃ佹敹缂╋紝鍒涘缓鐧诲綍鐢ㄦ埛锛屾暟鎹簱鐢ㄦ埛绛夋搷浣滆剼鏈

璁板綍涓涓/ --澶囦唤鏁版嵁搴 use [master] go BACKUP DATABASE [LnkSys11] TO DISK = N'C:\BackUp\LnkSys11.bak' WITH --澶囦唤鏂囦欢瀛樻斁璺緞 NOFORMAT, INIT, --INIT:瑕嗙洊澶囦唤;NOINIT: 杩藉姞澶囦唤 ...

蹇犺瘹鍗+ 鍙戝竷浜 2019-12-06 21:27 璇勮(0)闃呰(9)
0

use azure data studio to create external table for oracle

http://sqlserver.code.blog/2019/12/06/use-azure-data-studio-to-create-external-table-for-oracle-server/ ...

stswordman 鍙戝竷浜 2019-12-06 14:32 璇勮(0)闃呰(5)
0

linux mysql 鏁版嵁搴撳鍒

涓銆佷富鏈嶅姟鍣ㄩ厤缃 1銆侀厤缃枃浠秏y.cnf鐨勪慨鏀 [root@localhost mysql]# vim /etc/my.cnf #鍦╗mysqld]涓坊鍔狅細server-id=1log_bin=master-binlog_bin_index=master-bin.indexbinlog_do_db ...

鐏靛浠g爜 鍙戝竷浜 2019-12-06 11:59 璇勮(0)闃呰(22)
0

mysql涓巔ython鐨勪氦浜

mysql鏄竴绉嶅叧绯诲瀷鏁版嵁搴擄紝鏄负浜嗚〃绀轰簨鐗╀笌浜嬬墿涔嬮棿鐨勫叧绯伙紝鏈韩瀛樹簬鏁版嵁搴撲腑鐨勫唴瀹规剰涔夊苟涓嶅ぇ锛屾墍浠ュ箍娉涘簲鐢ㄤ簬缂栫▼璇█涓紝python涓節鍚湁涓嶮ySQL浜や簰鐨勬ā鍧 pymysql 缂栫▼瀵筸ysql鐨勬搷浣 ...

bug鑰楀瓙 鍙戝竷浜 2019-12-06 11:17 璇勮(0)闃呰(21)
0

瑙e喅mysql瀵煎叆鏁版嵁閲忓緢澶у鑷村け璐ュ強鏌ユ壘my.ini 浣嶇疆锛坢y.ini锛夊湪鍝

鏁版嵁搴撴暟鎹噺寰堝ぇ鐨勬暟鎹簱瀵煎叆鍒版湰鍦版椂锛屼細绛夊緢涔咃紝鐒惰岀瓑寰堜箙涔嬪悗杩樻槸鏄剧ず澶辫触锛 杩欐槸灏辫鐪嬬湅鑷繁鏈湴鐨勬病mysql鏄惁璁剧疆浜嗚秴鏃剁瓑寰咃紝濡傛灉鎶ョ浉鍏硉ime_out杩欎簺锛屽彲浠ユ妸mysql.ini灏鹃儴娣诲姞max_allowed_packet銆乮nteractive_timeout銆亀ait_timeout ...

娑堝け鐨勫お闃 鍙戝竷浜 2019-12-06 09:59 璇勮(0)闃呰(16)
0

[20191206]闅愬惈鍙傛暟_db_always_check_system_ts.txt

[20191206]闅愬惈鍙傛暟_db_always_check_system_ts.txt--//浠婂勾骞村ご鎴戝仛tab$鍒犻櫎鎭㈠鏃,閬囧埌鐨勯棶棰,灏辨槸閬囧埌寤惰繜鍧楁竻闄ょ殑闂.鍙傝冮摼鎺:http://blog.itpub.net/267265/viewspace-2564716/http://blog.itp ...

lfree 鍙戝竷浜 2019-12-06 09:54 璇勮(0)闃呰(9)
0

ElasticSearch - 閬愭兂

浼楁墍鍛ㄧ煡锛孍lasticSearch 瀛樺湪涓涓棶棰橈紝鏃犳硶鏌ヨ鏈杩 1s 鐨勫啓鍏ャ傝繎瀹炴椂杩欎釜灞炴э紝闄愬埗浜嗗叾鍦ㄦ煇浜涘満鏅殑搴旂敤銆山西快三平台app—官方网址22270.COM鏈枃璁板綍浜嗘垜鍦ㄦ棩甯稿伐浣滀腑鎯冲埌鐨勶紝瑙e喅鐗瑰畾鍦烘櫙鐨勪竴浜涙柟妗堛傛棦鐒舵槸璁板綍锛屼究浼氭湁濂芥湁鍧忥紝浠呬緵澶у鍙傝冦 棰勮涓婁笅鏂 涓涓功绫嶏紙book锛夌储寮曪紙index锛夛紝鏂囨。锛坉oc锛夊睘鎬ф湁锛氬悕绉帮紙 ...

蹇垫棤浼 鍙戝竷浜 2019-12-05 22:50 璇勮(0)闃呰(10)
0

MySQL 鏈夊叧MHA鎼缓涓庡垏鎹㈢殑鍑犱釜閿欒log

1锛歮asterha_check_repl 鍓湰闆嗘柟闈㈡姤閿 replicates is not defined in the configuration file! 鍏蜂綋淇℃伅濡備笅锛 鍒嗘瀽锛歁HA 婕傜Щ杩囧悗锛屾垜浠煡閬撻厤缃俊鎭腑 涓昏妭鐐圭殑淇℃伅灏变笉鍦ㄤ簡锛屾垜浠渶瑕佸強鏃剁淮鎶わ紝鍚﹀垯/usr/local/bin/ ...

涓滃北绲煶浠 鍙戝竷浜 2019-12-05 22:45 璇勮(0)闃呰(17)
0

C# ODP.NET 璋冪敤Oracle鍑芥暟杩斿洖鍊兼椂鎶ラ敊鐨勪竴涓В鍐虫柟妗

鏈変汉鍦ㄧぞ鍖洪棶鍒帮細C#璋冪敤Oracle涓嚜瀹氫箟鍑芥暟鐨勮繑鍥炲兼椂锛屾棤娉曟甯歌皟鐢ㄣ備絾鍦≒L/SQL涓甯歌皟鐢ㄨ繑鍥炪 ...

閭鏈 鍙戝竷浜 2019-12-05 21:50 璇勮(0)闃呰(28)
0

Hadoop_MapReduce_03

1. MapReduce鍏ラ棬 1.1 MapReduce鐨勬濇兂 MapReduce鐨勬濇兂鏍稿績鏄"鍒嗚屾不涔" , 閫傜敤浜庡ぇ閲忕殑澶嶆潅鐨勪换鍔″鐞嗗満鏅 (澶ц妯℃暟鎹鐞嗗満鏅) . Map璐熻矗"鍒" , 鍗虫妸澶嶆潅鐨勪换鍔″垎瑙d负鑻ュ共涓"绠鍗曠殑浠诲姟"鏉ヨ繘琛屽鐞. 鍙互杩涜鎷嗗垎鐨勫墠鎻愭槸杩欎簺灏忎换鍔″苟琛岃绠, 褰兼闂村嚑涔 ...

澶ф暟鎹晫绗竴ADC 鍙戝竷浜 2019-12-05 21:21 璇勮(0)闃呰(1)
0

Navicat Keygen - 娉ㄥ唽鏈烘槸鎬庝箞宸ヤ綔鐨勶紵

Navicat Keygen - 娉ㄥ唽鏈烘槸鎬庝箞宸ヤ綔鐨勶紵 1. 鍏抽敭璇嶈В閲. Navicat婵娲诲叕閽 杩欐槸涓涓2048浣嶇殑RSA鍏挜锛孨avicat浣跨敤杩欎釜鍏挜鏉ュ畬鎴愮浉鍏虫縺娲讳俊鎭殑鍔犲瘑鍜岃В瀵嗐 杩欎釜鍏挜琚綔涓 RCData 绫诲瀷鐨勮祫婧愬偍瀛樺湪 navicat.exe 褰撲腑銆傝祫婧愬悕涓"ACTIVATION ...

鍙ら亾杞婚 鍙戝竷浜 2019-12-05 18:24 璇勮(0)闃呰(13)
0

MySQL Last_SQL_Errno: 1062----缁忓吀閿欒锛屼富閿啿绐

涓銆佸熀纭淇℃伅 1. Centos7.4 2.MySQL 5.7.21 3.鍩轰簬gtid鐨勫鍒 浜屻佸紓甯告弿杩 璇妸浠庤妭鐐瑰綋鎴愪富鑺傜偣鎻掑叆涓鏉℃暟鎹紝鍚屼竴鏉℃暟鎹湪涓汇佷粠鑺傜偣鎻掑叆閮借繘琛屼簡涓娆℃彃鍏ユ搷浣滐紝瀵艰嚧涓婚敭鍐茬獊锛宻lave涓嬬殑SQL绾跨▼寮傚父銆 寤鸿璁剧疆浠庡簱涓哄彧璇伙細 set global read_only= ...

灏廮浼 鍙戝竷浜 2019-12-05 16:56 璇勮(0)闃呰(30)
0

ElasticSearch濡備綍涓娆℃煡璇㈠嚭鍏ㄩ儴鏁版嵁鈥斺斿熀浜嶴croll

ElasticSearch 鐢⊿croll锛堝搴旀暟鎹簱鐨勬父鏍囷級 涓娆℃煡鍑哄叏閮ㄦ暟鎹 ...

CoderBaby 鍙戝竷浜 2019-12-05 14:19 璇勮(0)闃呰(41)
0

Sqlite鈥斿垹闄よ鍙(Delete)

SQLite 鐨 DELETE 璇彞鐢ㄤ簬鍒犻櫎琛ㄤ腑宸叉湁鐨勮褰曘傚彲浠ヤ娇鐢ㄥ甫鏈 WHERE 瀛愬彞鐨 DELETE 鏌ヨ鏉ュ垹闄ら夊畾琛岋紝鍚﹀垯鎵鏈夌殑璁板綍閮戒細琚垹闄ゃ SQLite 瑕佹竻绌鸿〃璁板綍锛屽彧鑳戒娇鐢―elete鏉ュ垹闄ゅ叏閮ㄨ〃鏁版嵁銆備絾鏄笌鍒殑鏁版嵁搴撲笉鍚岋紝SQlite鍦ㄤ负琛ㄥ垱寤鸿嚜澧炲垪鍚庯紝浼氬皢琛ㄨ嚜澧炲垪鐨勫綋鍓嶅簭鍙蜂繚瀛 ...

鍒榑love_鐢 鍙戝竷浜 2019-12-05 14:18 璇勮(0)闃呰(33)