Home arrow Blog
Main Menu
Home
Blog
Downloads
Forum
Link
Search
Category
Mobile
PHP
Google
Joomla
Cygwin
I-Apply
Linux
Plagger
Internet
Other
What's New
Recommend
RSS
E-Pagerank
便利！VIM(GVIM 7.x)でSQLを整形する
Writte by Administrator   
2008/04/23 水曜日 16:34
Tag it:
Hatena
Delicious
Spurl
blogmarks
?

ということで、VIMにMacroという便利な機能があるので、それを使う。
VIM用のMacroというのはいっぱい既に出回っていて、今回は以下のものを使う。

SQLUtilities
http://www.vim.org/scripts/script.php?script_id=492


まずは、上記の場所からMacroをダウンロードしてくる。
ダウンロードしたファイルを解凍し、VIMのHOMEディレクトリ配下の「plugin」
ディレクトリにファイルを配置する。
※解凍すると、pluginフォルダを含む複数のディレクトリが出来ると思うので、
　実際にはHOMEディレクトリ配下の「plugin」ディレクトリの上のディレクトリ
　に丸ごとコピーすれば良い。

　HOMEディレクトリは、VIM上で
　:echo $HOME
　とやれば、出力される。


また、このマクロを動かすには以下のMacroも必要なのでそちらもダウンロード。

Align
http://www.vim.org/scripts/script.php?script_id=294


こちらは、ダウンロード後、ダウンロードしたファイルを開く。
gvim Align.vba.gz
:so%
:q

これでインストールは完了。

実際に、適当なSQLファイルを読み込み

:SQLUFormatter

とコマンドを打つと、SQLがきれいに整形される。便利！

 

Tag it:
Hatena
Delicious
Spurl
blogmarks
?

Add as favourites (47) | Quote this article on your site | Views: 2769

  Comments (10)
 1 Comment 04 1902
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 05-07-2008 02:02 , IP: 91.121.165.32
Hielloo , [URL=http://465.dream.az.pl]pima community college in tucson az classes[/URL], [URL=http://145.dream.az.pl]pensacola christian college a beka regional representative[/URL], [URL=http://285.dream.az.pl]palo alto college san antonio[/URL], [URL=http://422.dream.az.pl]el camino college of torrance california[/URL], [URL=http://91.dream.az.pl]college frat guys naked[/URL], [URL=http://221.dream.az.pl]queens baurought community college[/URL], [URL=http://424.dream.az.pl]junior college football[/URL], [URL=http://559.dream.az.pl]college lesbians girls gone wild[/URL], [URL=http://140.dream.az.pl]gay college guys in shower[/URL], [URL=http://265.dream.az.pl]luzerne county community college mens basketball[/URL], [URL=http://123.dream.az.pl]city of college station texas city manager[/URL], [URL=http://587.dream.az.pl]college girls free[/URL], [URL=http://245.dream.az.pl]pensacola christian college summer camp[/URL], [URL=http://77.dream.az.pl]online college courses in teaching degrees[/URL], [URL=http://501.dream.az.pl]bracket college basketball[/URL], [URL=http://481.dream.az.pl]playboy college girls spring 2004[/URL], [URL=http://557.dream.az.pl]blonde college sluts nude[/URL], [URL=http://499.dream.az.pl]college football bowl game schedule[/URL], [URL=http://550.dream.az.pl]find grants to pay for college classes[/URL], [URL=http://494.dream.az.pl]westwood college online bad[/URL], [URL=http://101.dream.az.pl]college chicks porn galleries[/URL], [URL=http://536.dream.az.pl]college football helmets[/URL], [URL=http://294.dream.az.pl]franklin pierce college nh teacher certification[/URL], [URL=http://110.dream.az.pl]craig's list for cheap college text books[/URL]
 2 Comment 05 210
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 05-07-2008 09:10 , IP: 91.121.165.32
Hielloo , [URL=http://118.kurtis.radom.pl]cheap flight deals[/URL], [URL=http://506.kurtis.radom.pl]flight centre to australia[/URL], [URL=http://298.kurtis.radom.pl]flight simulator x addons[/URL], [URL=http://723.hubel.waw.pl]north central texas community college corrinth[/URL], [URL=http://142.admissibility.waw.pl]auto loan on line application[/URL], [URL=http://37.hubel.waw.pl]college scholarships and grants for sports[/URL], [URL=http://513.kurtis.radom.pl]recife phoenix cheap flight[/URL], [URL=http://297.admissibility.waw.pl]credit union personal loan rates in massachusetts[/URL], [URL=http://541.kurtis.radom.pl]flight status check[/URL], [URL=http://772.hubel.waw.pl]top 100 college football teams[/URL], [URL=http://79.admissibility.waw.pl]early payoff calculators loan[/URL], [URL=http://258.admissibility.waw.pl]auto loan deferred payments[/URL], [URL=http://121.kurtis.radom.pl]pros and cons of being a flight attendant[/URL], [URL=http://127.hubel.waw.pl]sexy college girls in thongs[/URL], [URL=http://216.admissibility.waw.pl]eagle bank online loan application[/URL], [URL=http://250.kurtis.radom.pl]united airlines flight 93[/URL], [URL=http://499.kurtis.radom.pl]cheap flight to orlando[/URL], [URL=http://164.hubel.waw.pl]college wild parties torrent[/URL], [URL=http://312.admissibility.waw.pl]cash advance loan with saving[/URL], [URL=http://80.admissibility.waw.pl]free car loan estimator[/URL], [URL=http://72.admissibility.waw.pl]company consolidation loan student[/URL], [URL=http://145.hubel.waw.pl]city college manchester it foundaion[/URL], [URL=http://657.hubel.waw.pl]fiu college application essay[/URL], [URL=http://72.hubel.waw.pl]scholarships available to adult college students[/URL]
 3 Comment 05 1951
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 06-07-2008 02:50 , IP: 91.121.165.32
Hielloo , [URL=http://246.perm.radom.pl]airline ticket gift card[/URL], [URL=http://591.perm.radom.pl]hawaiian airline ticket[/URL], [URL=http://54.meissner.wroclaw.pl]coupons alibris[/URL], [URL=http://279.perm.radom.pl]airline ticket agency[/URL], [URL=http://689.perm.radom.pl]airline ticket to guyana cheap[/URL], [URL=http://15.meissner.wroclaw.pl]six flags coupons georgia[/URL], [URL=http://143.perm.radom.pl]airline electronic ticket kiosks[/URL], [URL=http://253.filmdom.tychy.pl]airline discount europe ticket travel[/URL], [URL=http://15.filmdom.tychy.pl]cheapest airline ticket to oklahoma city departing date asap[/URL], [URL=http://647.perm.radom.pl]20.00 airline ticket usa[/URL], [URL=http://355.filmdom.tychy.pl]airline flight ticket cheap[/URL], [URL=http://353.filmdom.tychy.pl]cheap airline ticket red eye one way[/URL], [URL=http://79.meissner.wroclaw.pl]printable food coupons[/URL], [URL=http://277.perm.radom.pl]have an airline ticket, how do i get confirmation number[/URL], [URL=http://248.filmdom.tychy.pl]airline ticket[/URL], [URL=http://373.perm.radom.pl]mihin lanka airline ticket booking singapore to sri lanka[/URL], [URL=http://73.filmdom.tychy.pl]airline ticket purchase[/URL], [URL=http://113.meissner.wroclaw.pl]coupons paypal[/URL]
 4 Comment 06 415
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 06-07-2008 11:15 , IP: 91.121.165.32
Hielloo , [URL=http://quickstep.az.pl/1203.html]photos of mizpah hotel in reno nv[/URL], [URL=http://quickstep.az.pl/109.html]discount hotel rates melbourne[/URL], [URL=http://781.whack.az.pl]womens gold bracelet watch jewelry watches[/URL], [URL=http://quickstep.az.pl/178.html]love how you love me neutral milk hotel[/URL], [URL=http://quickstep.az.pl/371.html]rate for gaylord opryland hotel in nashville,tn[/URL], [URL=http://547.whack.az.pl]all vintage accutron watches[/URL], [URL=http://372.whack.az.pl]paolo gucci watches and gucci handbags[/URL], [URL=http://quickstep.az.pl/436.html]hotel manager resume[/URL], [URL=http://quickstep.az.pl/953.html]singapore airport hotel[/URL], [URL=http://687.whack.az.pl]14 gold ladies watches[/URL], [URL=http://quickstep.az.pl/873.html]hyatt hotel[/URL], [URL=http://143.whack.az.pl]orient automatic ladies watches[/URL], [URL=http://quickstep.az.pl/1462.html]marriott hotel discounts[/URL], [URL=http://quickstep.az.pl/1298.html]usa habbo hotel credit cheats[/URL], [URL=http://869.whack.az.pl]italian replica watches[/URL], [URL=http://984.whack.az.pl]mens nike watches jewellery watches[/URL], [URL=http://679.whack.az.pl]black hills gold rings jewelry watches[/URL], [URL=http://quickstep.az.pl/1045.html]alberto barajas hilton hotel los angeles union[/URL], [URL=http://968.whack.az.pl]womens citizen solar watches[/URL], [URL=http://556.whack.az.pl]ladies red watches[/URL], [URL=http://160.whack.az.pl]boy gold charms jewelry watches[/URL], [URL=http://quickstep.az.pl/348.html]hotel rwanda joaquin phoenix[/URL]
 5 Comment 06 2352
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 07-07-2008 06:51 , IP: 91.121.165.32
Hielloo , [URL=http://20.mamet.az.pl]hot pepper casino no deposit bonus code[/URL], [URL=http://167.bangladesh.olsztyn.pl]wild party girls college co[/URL], [URL=http://113.bangladesh.olsztyn.pl]long beach city college schedule[/URL], [URL=http://375.bangladesh.olsztyn.pl]columbia college,chicago[/URL], [URL=http://828.breadfruit.az.pl]africa airline discount ticket travel[/URL], [URL=http://210.bangladesh.olsztyn.pl]ashworth college business communication exam cheats[/URL], [URL=http://485.mamet.az.pl]casino directory reno nevada[/URL], [URL=http://424.tiling.mazury.pl]harvey hotel dfw airport[/URL], [URL=http://8.tiling.mazury.pl]hotel motel for sale in usa[/URL], [URL=http://431.mamet.az.pl]casino play money[/URL], [URL=http://197.tiling.mazury.pl]hotel living for rochester ny monthly rate[/URL], [URL=http://804.breadfruit.az.pl]airline ticket, europa[/URL], [URL=http://9.mamet.az.pl]casino poker[/URL], [URL=http://411.tiling.mazury.pl]sex in geylang hotel[/URL], [URL=http://268.mamet.az.pl]grand casino inn hinckley hinckley[/URL], [URL=http://449.mamet.az.pl]casino free cash[/URL], [URL=http://268.tiling.mazury.pl]hotel motel rooms[/URL]
 6 Comment 07 2034
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 08-07-2008 03:33 , IP: 91.121.165.32
Hielloo , [URL=http://106.anglicization.az.pl]airline ticket pricing[/URL], [URL=http://30.imposition.az.pl]latino free online dating websites[/URL], [URL=http://280.creeps.warszawa.pl]airline tycoon deluxe[/URL], [URL=http://550.hominidae.az.pl]booking airline flights[/URL], [URL=http://1126.palmae.az.pl]womens citizen solar watches[/URL], [URL=http://618.hominidae.az.pl]ethipian airline news[/URL], [URL=http://108.imposition.az.pl]gay sexual dating service[/URL], [URL=http://724.imposition.az.pl]interracial dating chat room for louisiana[/URL], [URL=http://501.anglicization.az.pl]singapore airline a380 boarding pass[/URL], [URL=http://558.pollinate.mazury.pl]last minute cheap airline deals[/URL], [URL=http://282.hominidae.az.pl]airline news yahoo[/URL], [URL=http://166.creeps.warszawa.pl]cheapest airline tickets in the world[/URL], [URL=http://520.hominidae.az.pl]malaysia airline schedule[/URL], [URL=http://144.pollinate.mazury.pl]airtran airline customer service[/URL], [URL=http://912.palmae.az.pl]size 7 white opal ring jewelry watches[/URL], [URL=http://339.creeps.warszawa.pl]airtran airline employee travel dress code[/URL], [URL=http://443.anglicization.az.pl]turkish airline crashes[/URL]
 7 Comment 08 115
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 08-07-2008 08:15 , IP: 91.121.165.32
Hielloo , [URL=http://727.anglicization.az.pl]china aouthern airline[/URL], [URL=http://536.imposition.az.pl]free dating shemale yum.com[/URL], [URL=http://476.imposition.az.pl]free christian dating on the internet[/URL], [URL=http://60.creeps.warszawa.pl]video of emirates airline[/URL], [URL=http://845.palmae.az.pl]pink heart sapphire ring size 5 jewelry watches[/URL], [URL=http://118.pollinate.mazury.pl]virginia america airline[/URL], [URL=http://731.pollinate.mazury.pl]cheap refundable international airline tickets[/URL], [URL=http://127.creeps.warszawa.pl]american airline advantage program[/URL], [URL=http://333.hominidae.az.pl]delta airline .www.com[/URL], [URL=http://341.anglicization.az.pl]go airline ticket prices maui to oahu[/URL], [URL=http://984.palmae.az.pl]men elgin austrian crystal watches[/URL], [URL=http://715.pollinate.mazury.pl]coupons to air tran airline[/URL], [URL=http://163.hominidae.az.pl]price line airline ticket[/URL], [URL=http://664.imposition.az.pl]free email at black dating sites[/URL], [URL=http://77.anglicization.az.pl]cheapest airline ticket from seattle tp philippinrs[/URL], [URL=http://299.creeps.warszawa.pl]airline tycoon cheats[/URL], [URL=http://490.pollinate.mazury.pl]one way airline tickets on southwest airlines[/URL], [URL=http://284.palmae.az.pl]replica parts for rolex watches[/URL], [URL=http://342.imposition.az.pl]local personals internet dating service[/URL], [URL=http://586.pollinate.mazury.pl]airline reservation system storage device[/URL], [URL=http://625.anglicization.az.pl]last minute airline ticket deal[/URL], [URL=http://800.palmae.az.pl]gold watches of omega[/URL]
 8 Comment 08 1624
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 08-07-2008 23:24 , IP: 91.121.165.32
Hielloo , [URL=http://161.bribery.az.pl]pay my wells fargo auto loan[/URL], [URL=http://464.chain.az.pl]airline asia discount ticket travel[/URL], [URL=http://478.chain.az.pl]discount airline ticket japan[/URL], [URL=http://410.overvaluation.az.pl]fly porsche slot car[/URL], [URL=http://90.smooch.az.pl]books on how to win at slots[/URL], [URL=http://870.overvaluation.az.pl]aurora charger slot cars[/URL], [URL=http://146.smooch.az.pl]free slots to play[/URL], [URL=http://849.overvaluation.az.pl]sicwo1a newman porsche slot car[/URL], [URL=http://106.smooch.az.pl]numbered pci x slots in g5[/URL], [URL=http://36.smooch.az.pl]slots free play[/URL], [URL=http://851.bribery.az.pl]get loan for settlement[/URL], [URL=http://684.bribery.az.pl]no hassle faxless pay day loan[/URL], [URL=http://628.smooch.az.pl]wwwvegas slots for sale tripple double cash.com[/URL], [URL=http://403.overvaluation.az.pl]slot machines+games[/URL], [URL=http://396.smooch.az.pl]club pogo hogs heaven slots[/URL], [URL=http://11.smooch.az.pl]sim slots free slot games[/URL], [URL=http://880.overvaluation.az.pl]jennings antique slot machine pricing guide[/URL], [URL=http://411.chain.az.pl]airline ticket for october 18, 2007 to sacramento[/URL], [URL=http://290.bribery.az.pl]federal home loan bank subprime mortgages[/URL], [URL=http://857.chain.az.pl]lowest airline ticket prices[/URL], [URL=http://901.bribery.az.pl]mortgage loan southern california[/URL], [URL=http://684.overvaluation.az.pl]atlanticcity slot machine play for free[/URL], [URL=http://180.overvaluation.az.pl]vintage aurora slot cars[/URL], [URL=http://810.chain.az.pl]when to buy cheap airline ticket[/URL], [URL=http://144.overvaluation.az.pl]free wheel of fortune slot machine game[/URL], [URL=http://253.bribery.az.pl]home mortgage refinance loan mortgage calculators with[/URL]
 9 Comment 09 2038
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 10-07-2008 03:38 , IP: 91.121.165.32
Hielloo , [URL=http://31.infarct.az.pl]slot machines for sale toronto[/URL], [URL=http://239.earlobe.az.pl]www free progressive slots[/URL], [URL=http://59.earlobe.az.pl]slots o fun casino las vegas[/URL], [URL=http://24.infarct.az.pl]video and slot machines[/URL], [URL=http://375.hornbeam.az.pl]airline tycoon three pc[/URL], [URL=http://625.defrost.az.pl]empire poker codes[/URL], [URL=http://579.defrost.az.pl]1000 poker chips 11.5g[/URL], [URL=http://534.earlobe.az.pl]how to win on slots in casino[/URL], [URL=http://363.cauda.pila.pl]the cheapest airline ticket to egypt[/URL], [URL=http://264.infarct.az.pl]24 slot car decals[/URL], [URL=http://543.earlobe.az.pl]how to win at slots[/URL], [URL=http://548.defrost.az.pl]odds for poker hand[/URL], [URL=http://373.bride-gift.az.pl]diamond dog tag jewelry watches[/URL], [URL=http://167.cauda.pila.pl]airline international ticket[/URL], [URL=http://480.bride-gift.az.pl]club g casio watches[/URL], [URL=http://431.bride-gift.az.pl]used mens nixon watches[/URL]
 10 Comment 10 114
Written by このメールアドレスはスパムボットから保護されています。観覧するにはJavaScriptを有効にして下さい , on 10-07-2008 08:13 , IP: 91.121.165.32
Hielloo , [URL=http://205.rheumatic.az.pl]payout poker casino on ps2[/URL], [URL=http://601.rheumatic.az.pl]horseshoe casino hotel tunica mississippi[/URL], [URL=http://1339.rheumatic.az.pl]harrahs cherokee casino in north carolina[/URL], [URL=http://441.histaminase.az.pl]how can i obtain xanax without a prescription[/URL], [URL=http://973.rheumatic.az.pl]3.html casino gambling guide online[/URL], [URL=http://661.gigabit.az.pl]we ship tramadol to florida[/URL], [URL=http://1146.histaminase.az.pl]xanax overdose warnings[/URL], [URL=http://694.gigabit.az.pl]tramadol addiction and withdrawal[/URL], [URL=http://680.dung.az.pl]best casino codes[/URL], [URL=http://833.dung.az.pl]winstar casino thackerville ok[/URL], [URL=http://118.dung.az.pl]new no deposit bonus casino[/URL], [URL=http://1941.dung.az.pl]007 casino royale car wallpaper[/URL], [URL=http://531.rheumatic.az.pl]007 sunglasses casino royal[/URL], [URL=http://207.rheumatic.az.pl]james bond casino royale tickets[/URL], [URL=http://680.histaminase.az.pl]order soma xanax without prescription[/URL], [URL=http://332.gigabit.az.pl]buy tramadol in tucson[/URL], [URL=http://166.gigabit.az.pl]what is tramadol hcl for[/URL], [URL=http://719.histaminase.az.pl]xanax xr description[/URL], [URL=http://1237.dung.az.pl]fun free casino games[/URL], [URL=http://1126.dung.az.pl]jobs in mgm grand casino hotel in detroit[/URL], [URL=http://855.gigabit.az.pl]prescription search tramadol[/URL], [URL=http://1606.dung.az.pl]mgm grand casino[/URL], [URL=http://182.dung.az.pl]bonus casino forums[/URL]

Write Comment
  • Please keep the topic of messages relevant to the subject of the article.
  • Personal verbal attacks will be deleted.
  • Please don't use comments to plug your web site. Such material will be removed.
  • Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button.
  • Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
Comment:

Code:* Code

Powered by AkoComment Tweaked Special Edition v.1.4.6
AkoComment © Copyright 2004 by Arthur Konze - www.mamboportal.com
All right reserved
 
< 前へ   次へ >
[ BACK ]

© 2008 Labs Zsrv Net
Joomla! is Free Software released under the GNU/GPL License.
Translation is Joomla!JAPAN