Use Excel to generate a whole crapload of SQL queries
9/09/09 at 16.04 by: tim
I had to update a whole lot of rows, and instead of sitting down and doing some ridiculous export and re-update, I figured I'd just write an SQL query in an Excel Concatenate statement and use the ids in the spreadsheet. WAH LA
First 2 columns are A : the id and B : the value I want to replace.
In column C, I put:
=CONCATENATE("UPDATE tablename SET fieldname='",B1,"' WHERE idfield=",A1,";")Then, just copy and paste that cell all the way down, copy the queries, and paste them into a phpMyAdmin SQL text box and run.
http://www.gucci-shoes.cc gucci store
http://www.gucci-shoes.cc gucci outlet
http://www.gucci-shoes.cc gucci
http://www.gucci-shoes.cc gucci mane
http://www.gucci-shoes.cc gucci sneakers
http://www.newaj.com air jordan
http://www.newaj.com air jordan shoes
http://www.4uaj.com air jordan shoes
http://www.4uaj.com jordan shoes
http://www.gucci-shoes.cc gucci 2009
http://www.gucci-shoes.cc gucci 2010
http://www.gucci-shoes.cc gucci new arrival
http://www.gucci-shoes.cc cheap gucci shoes
http://www.gucci-shoes.cc buy gucci shoes
http://www.gucci-shoes.cc men gucci shoes
http://www.gucci-shoes.cc gucci men shoes
http://www.gucci-shoes.cc women gucci shoes
http://www.gucci-shoes.cc gucci women shoes
http://www.gucci-shoes.cc discount gucci shoes
http://www.gucci-shoes.cc gucci shoes man
http://www.gucci-shoes.cc buy gucci
http://www.watchesair.com/
http://www.watchesloot.com/
http://www.watchesshow.com/
http://www.handbagsair.com/
http://www.mybagsroom.com/
http://www.ebagsell.com/(L5.14)
blu-ray ripper http://besthdsoft.com/best-hd-blu-ray-ripper.html
blu-ray to avi http://besthdsoft.com/blu-ray-to-avi-converter.html
blu-ray to mpeg http://besthdsoft.com/blu-ray-to-mpeg-converter.html
blu-ray dvd converter http://besthdsoft.net/best-hd-blu-ray-dvd-ripper.html
http://www.mychristianlouboutinshoes.com
summer
http://www.seawatches.com/replica watches.html
http://www.replicame.com/breitling-watches.html
http://www.replicame.com/cartier-watches.html
http://www.replicame.com/omega-watches.html
http://www.replicame.com/fake watches.html
http://www.replicame.com/rolex-watches.html
http://www.replicame.com/breitling-watches.html
http://www.replicame.com/tag_heuer-watches.html
http://www.replicame.com/cartier-watches.html
http://www.replicame.com/omega-watches.html
http://www.replicame.com/panerai-watches.html
http://www.replicame.com/armani-watches.html
http://www.replicame.com/audemars_piguet-watches.html
http://www.replicame.com/bvlgari-watches.html
http://www.replicame.com/chanel-watches.html
http://www.replicame.com/gucci-watches.html
http://www.replicame.com/movado-watches.html
http://www.replicame.com/montblanc-watches.html
http://www.replicame.com/patek_philippe-watches.html
http://www.replicame.com/rolex-watches.html
http://www.replicame.com/breitling-watches.html
http://www.replicame.com/tag_heuer-watches.html
http://www.replicame.com/omega-watches.html
http://www.replicame.com/panerai-watches.html
http://www.replicame.com/armani-watches.html
http://www.replicame.com/audemars_piguet-watches.html
http://www.replicame.com/bvlgari-watches.html
http://www.replicame.com/chanel-watches.html
http://www.replicame.com/gucci-watches.html
http://www.replicame.com/movado-watches.html
http://www.replicame.com/montblanc-watches.html
http://www.replicame.com/patek_philippe-watches.html
http://www.seawatches.com/rolex-watches.html
http://www.seawatches.com/breitling-watches.html
http://www.seawatches.com/tag_heuer-watches.html
http://www.seawatches.com/cartier-watches.html
http://www.seawatches.com/omega-watches.html
http://www.seawatches.com/panerai-watches.html
http://www.seawatches.com/audemars_piguet-watches.html
http://www.seawatches.com/bvlgari-watches.html
http://www.seawatches.com/chanel-watches.html
http://www.seawatches.com/gucci-watches.html
http://www.seawatches.com/iwc-watches.html
http://www.seawatches.com/montblanc-watches.html
http://www.seawatches.com/patek_philippe-watches.html
http://www.seawatches.com/rado-watches.html
http://www.seawatches.com/rolex-watches.html
http://www.seawatches.com/breitling-watches.html
http://www.seawatches.com/tag_heuer-watches.html
http://www.seawatches.com/cartier-watches.html
http://www.seawatches.com/omega-watches.html
http://www.seawatches.com/panerai-watches.html
http://www.seawatches.com/armani-watches.html
http://www.seawatches.com/audemars_piguet-watches.html
http://www.seawatches.com/bvlgari-watches.html
http://www.seawatches.com/chanel-watches.html
http://www.seawatches.com/gucci-watches.html
http://www.seawatches.com/iwc-watches.html
http://www.seawatches.com/montblanc-watches.html
http://www.seawatches.com/patek_philippe-watches.html
http://www.seawatches.com/rado-watches.html
http://www.watchesview.com/rolex-watches.html
http://www.watchesview.com/rolex-watches.html
http://www.watchesview.com/breitling-watches.html
http://www.watchesview.com/omega-watches.html
http://www.watchesview.com/cartier-watches.html
http://www.watchesview.com/breitling-watches.html
http://www.watchesview.com/omega-watches.html
http://www.watchesview.com/cartier-watches.html
http://www.watchesview.com/rolex,.html
http://www.watchesview.com/tag_heuer-watches.html
http://www.watchesview.com/patek_philippe-watches.html
http://www.watchesview.com/chanel-watches.html
http://www.watchesview.com/audemars_piguet-watches.html
http://www.watchesview.com/armani-watches.html
http://www.watchesview.com/iwc-watches.html
http://www.watchesview.com/montblanc-watches.html
http://www.watchesview.com/bvlgari-watches.html
http://www.watchesview.com/lv-watches.html
http://www.watchesview.com/movado-watches.html
http://www.watchesview.com/franck_muller-watches.html
http://www.watchesview.com/parmigiani-watches.html
http://www.watchesview.com/hublot-watches.html
http://www.watchesview.com/panerai-watches.html
http://www.watchesview.com/longines-watches.html
http://www.watchesview.com/tissot-watches.html
http://www.watchesview.com/tudor-watches.html
http://www.watchesday.com/rolex-watches.html
http://www.watchesday.com/breitling-watches.html
http://www.watchesday.com/tag_heuer-watches.html
http://www.watchesday.com/cartier-watches.html
http://www.watchesday.com/omega-watches.html
http://www.watchesday.com/panerai-watches.html
http://www.watchesday.com/armani-watches.html
http://www.watchesday.com/audemars_piguet-watches.html
http://www.watchesday.com/bvlgari-watches.html
http://www.watchesday.com/chanel-watches.html
http://www.watchesday.com/gucci-watches.html
http://www.watchesday.com/iwc-watches.html
http://www.watchesday.com/montblanc-watches.html
http://www.watchesday.com/patek_philippe-watches.html
http://www.watchesday.com/rado-watches.html
http://www.watchesday.com/rolex-watches.html
http://www.watchesday.com/breitling-watches.html
http://www.watchesday.com/tag_heuer-watches.html
http://www.watchesday.com/cartier-watches.html
http://www.watchesday.com/omega-watches.html
http://www.watchesday.com/panerai-watches.html
http://www.watchesday.com/armani-watches.html
http://www.watchesday.com/audemars_piguet-watches.html
http://www.watchesday.com/bvlgari-watches.html
http://www.watchesday.com/chanel-watches.html
http://www.watchesday.com/gucci-watches.html
http://www.watchesday.com/iwc-watches.html
http://www.watchesday.com/montblanc-watches.html
http://www.watchesday.com/patek_philippe-watches.html
http://www.watchesday.com/rado-watches.html
<a href="http://gilffxiv.com/">ffxiv gold</a>,
<a href="http://gilffxiv.com/">final fantasy XIV gil</a>,
<a href="http://gilffxiv.com/">buy ffxiv gil</a>,
<a href="http://gilffxiv.com/">final fantasy XIV money</a>,
<a href="http://www.10minget.com/ffxiv.html">ffxiv gil</a>,
<a href="http://www.10minget.com/ffxiv.html">ffxiv money</a>,
<a href="http://www.10minget.com/ffxiv.html">ffxiv gold</a>,
<a href="http://www.10minget.com/ffxiv.html">final fantasy XIV money</a>,
<a href="http://www.4gamefight.com/ffxiv.html">ffxiv gold</a>,
<a href="http://www.4gamefight.com/ffxiv.html">final fantasy XIV money</a>,
<a href="http://www.4gamefight.com/ffxiv.html">buy ffxiv gil</a>,
<a href="http://www.4gamefight.com/ffxiv.html">final fantasy XIV gil</a>,
<a href="http://www.enjoygolds.com/ffxiv-gil.html">ffxiv gil</a>,
<a href="http://www.enjoygolds.com/ffxiv-gil.html">ffxiv money</a>,
<a href="http://www.enjoygolds.com/ffxiv-gil.html">ffxiv gold</a>,
<a href="http://www.gamegoldmoney.com/ffxiv-gil.html">final fantasy XIV money</a>,
<a href="http://www.gamegoldmoney.com/ffxiv-gil.html">buy ffxiv gil</a>,
<a href="http://www.gamegoldmoney.com/ffxiv-gil.html">final fantasy XIV gil</a>,
<a href="http://gilffxiv.com/">ffxiv gil</a>,
<a href="http://gilffxiv.com/">ffxiv money</a>,
<a href="http://gilffxiv.com/">ffxiv gold</a>,
<a href="http://www.gamezmoney.com">tibia weapon</a>,
<a href="http://www.gamezmoney.com">tibia leveling</a>,
<a href="http://www.gamezmoney.com">armor tibia</a>,
<a href="http://www.gamezmoney.com">tibia level</a>,
<a href="http://www.gamezmoney.com">tibia account</a>,
<a href="http://www.tibiamoney.com">tibia gold</a>,
<a href="http://www.tibiamoney.com">tibia money</a>,
<a href="http://www.tibiamoney.com">tibia item</a>,
<a href="http://www.10minget.com">tibia weapon</a>,
<a href="http://www.10minget.com">tibia leveling</a>,
<a href="http://www.10minget.com">armor tibia</a>,
<a href="http://www.10minget.com">tibia level</a>,
<a href="http://www.10minget.com">tibia account</a>,
<a href="http://www.gamegoldcoin.com">tibia gold</a>,
<a href="http://www.gamegoldcoin.com">tibia money</a>,
<a href="http://www.gamegoldcoin.com">tibia item</a>,
<a href="http://www.gamegoldcoin.com">tibia items</a>,
<a href="http://www.enjoygolds.com">tibia level</a>,
<a href="http://www.enjoygolds.com">tibia account</a>,
<a href="http://www.gamexgolds.com">tibia gold</a>,
<a href="http://www.gamexgolds.com">tibia money</a>,
<a href="http://www.gamexgolds.com">tibia item</a>,
<a href="http://www.guildwarsgoldmoney.com/">guild wars shop</a>,
<a href="http://www.guildwarsgoldmoney.com/">guild wars gold</a>,
<a href="http://www.guildwarsgoldmoney.com/">gw gold</a>,
<a href="http://www.guildwarsgoldmoney.com/">guild wars money</a>,
<a href="http://www.gamezmoney.com/">guild wars armor</a>,
<a href="http://www.gamezmoney.com/">guild wars platinum</a>,
<a href="http://www.enjoygolds.com/">guild wars gold</a>,
<a href="http://www.enjoygolds.com/">gw gold</a>,
<a href="http://www.enjoygolds.com/">guild wars money</a>,
<a href="http://www.gamegoldmoney.com/">guild wars armor</a>,
<a href="http://www.gamegoldmoney.com/">guild wars platinum</a>,
<a href="http://www.gamegoldmoney.com/">guild wars farming</a>,
<a href="http://www.10minget.com/">guild wars gold</a>,
<a href="http://www.10minget.com/">gw gold</a>,
<a href="http://www.10minget.com/">guild wars money</a>,
<a href="http://www.4gamefight.com/">guild wars armor</a>,
<a href="http://www.4gamefight.com/">guild wars platinum</a>,
<a href="http://www.4gamefight.com/">guild wars farming</a>,
<a href="http://www.runescape100m.com/">runescape gp</a>,
<a href="http://www.runescape100m.com/">runescape quest</a>,
<a href="http://www.runescape100m.com/">buy runescape</a>,
<a href="http://www.runescape100m.com/">runescape money</a>,
<a href="http://www.rs15min.com/">runescape gp</a>,
<a href="http://www.rs15min.com/">runescape quest</a>,
<a href="http://www.rs15min.com/">buy runescape</a>,
<a href="http://www.rs15min.com/">runescape money</a>,
<a href="http://www.rs15min.com/">runescape item</a>,
<a href="http://www.rs15min.com/">runescape gp</a>,
<a href="http://www.rs15min.com/">runescape quest</a>,
<a href="http://www.rs15min.com/">buy runescape</a>,
<a href="http://www.rs15min.com/">runescape money</a>,
<a href="http://www.rs15min.com/">runescape item</a>,
<a href="http://www.rs15min.com/">runescape account</a>,
<a href="http://www.rs15min.com/">runescape gold</a>,
-------------------------------------------------------------------------------------------------------------
<a href="http://www.runescapego.com/">runescape gp</a>,
<a href="http://www.runescapego.com/">runescape quest</a>,
<a href="http://www.runescapego.com/">buy runescape</a>,
<a href="http://www.runescapego.com/">runescape money</a>,
<a href="http://www.runescapego.com/">runescape item</a>,
<a href="http://www.runescapego.com/">runescape account</a>,
<a href="http://www.runescapego.com/">runescape gold</a>,
<a href="http://www.runescape360.com/">runescape gp</a>,
<a href="http://www.runescape360.com/">runescape quest</a>,
<a href="http://www.runescape360.com/">buy runescape</a>,
<a href="http://www.runescape360.com/">runescape money</a>,
<a href="http://www.runescape360.com/">runescape item</a>,
<a href="http://www.runescape360.com/">runescape account</a>,
<a href="http://www.runescape360.com/">runescape gold</a>,
<a href="http://www.gameotl.com/">runescape gp</a>,
<a href="http://www.gameotl.com/">runescape quest</a>,
<a href="http://www.gameotl.com/">buy runescape</a>,
<a href="http://www.gameotl.com/">runescape money</a>,
<a href="http://www.gameotl.com/">runescape item</a>,
<a href="http://www.gameotl.com/">runescape account</a>,
<a href="http://www.gameotl.com/">runescape gold</a>,
<a href="http://www.runescape100m.com/">runescape gp</a>,
<a href="http://www.runescape100m.com/">runescape quest</a>,
<a href="http://www.runescape100m.com/">buy runescape</a>,
<a href="http://www.runescape100m.com/">runescape money</a>,
<a href="http://www.runescape100m.com/">runescape item</a>,
<a href="http://www.runescape100m.com/">runescape account</a>,
<a href="http://www.runescape100m.com/">runescape gold</a>,
http://www.replicame.com/rolex-watches.html
http://www.watchesview.com/tag_heuer-watches.html
http://www.watchesview.com
http://www.watchesday.com
http://www.wtchesday.com/rolex-watches.html
http://www.seawatches.com
http://www.seawatches.com/rolex-watches.html
http://www.watchessell.com/product.php?id=4&categories_id=36
http://www.watchessell.com/product.php?id=13&categories_id=36
http://www.watchessell.com/product.php?id=21&categories_id=36
http://www.watchessell.com/product.php?id=14&categories_id=36
http://www.watchessell.com/product.php?id=19&categories_id=36
http://www.watchessell.com/product.php?id=44&categories_id=36
http://www.wholewatches.com/rolex-watches.html
http://www.wholewatches.com/breitling-watches.html
http://www.wholewatches.com/tag_heuer-watches.html
http://www.wholewatches.com/cartier-watches.html
http://www.wholewatches.com/omega-watches.html
http://www.wholewatches.com/movado-watches.html
http://www.overwatches.com/rolex-watches.html
http://www.overwatches.com/breitling-watches.html
http://www.overwatches.com/tag_heuer-watches.html
http://www.overwatches.com/cartier-watches.html
http://www.overwatches.com/omega-watches.html
http://www.overwatches.com/movado-watches.html
http://www.watchvisa.com
http://www.watchvisa.com/breitling-watches.html
http://www.watchvisa.com/cartier-watches.html
http://www.watchvisa.com/omega-watches.html
http://www.watchvisa.com/tag_heuer-watches.html
http://www.watchvisa.com/rolex-watches.html
It certainly has sturdy roots: Victoria ruled replica handbasg for 63 years, and adored Albert so much that she wore black for the 40 years she was widowed. But was it a wild love story for both wholesale handbags parties? It can be a challenge to trust historical dramas. We are so used to replica handbags being duped that even while we're enjoying a scene, we may think it is all made up. The Young louis vuitton handbags Victoria features the jolly King William at his birthday banquet, quite in his cups, trashing Victoria mother.
http://www.mybagsvip.com
http://www.mybagsvip.com/louis_vuitton-bags.html
http://www.aimbags.com
http://www.aimbags.com/louis_vuitton-bags.html
http://www.handbagssell.com
http://www.handbagssell.com/Louis_Vuitton-bags.html
It is a funny bit, ending with wow gold Richardson huffing off and some dry old man saying ruefully, Families. This scene wow gold eu has the mark of something written for expressly wow gold us for Broadbent by Fellowes, but in Lytton Strachey biography Queen Victoria, and wow gold again in Christopher Hibbert , you will find that scene, told exactly as it is on screen. The only difference is that Blunt Victoria does not power leveling burst into tears as the real princess apparently did; the movie heroine has more backbone.
http://www.pvpbutt.com
http://www.pvpbutt.com/world-of-warcraft-us.php
http://www.pvpbutt.com/world-of-warcraft-eu.php
http://www.pvpbutt.com/powerleveling.php
http://www.duckpvp.com
http://www.duckpvp.com/world-of-warcraft-us.php
http://www.duckpvp.com/world-of-warcraft-eu.php
http://www.duckpvp.com/powerleveling.php
http://www.thewowgold.net
http://www.thewowgold.net/world-of-warcraft-us.php
http://www.thewowgold.net/world-of-warcraft-eu.php
http://www.uswotlk.com
http://www.uswotlk.com/world-of-warcraft-us.php
http://www.uswotlk.com/world-of-warcraft-eu.php
http://www.uswotlk.com/Powerleveling.php
http://www.igcome.com
http://www.igcome.com/world-of-warcraft-us.php
http://www.igcome.com/world-of-warcraft-eu.php
http://www.igcome.com/Powerleveling.php