Hide

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again.

Delete that bloated snippets file you've been using and share your personal repository with the world. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.


Get involved!

You can sign-in using OpenID credentials, or register a traditional username and password.

First-time OpenID users will be automatically assigned a username which can be changed after signing in.

Universal configuration monitoring and system of record for IT.
Hide

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

Hide

News

May 19, 2015 - A Look At The New Commandlinefu
I've put together a short writeup on what kind of newness you can expect from the next iteration of clfu. Check it out here.
March 2, 2015 - New Management
I'm Jon, I'll be maintaining and improving clfu. Thanks to David for building such a great resource!
Hide

Top Tags

Hide

Functions

Psst. Open beta.

Wow, didn't really expect you to read this far down. The latest iteration of the site is in open beta. It's a gentle open beta-- not in prime-time just yet. It's being hosted over at UpGuard (link) and you are more than welcome to give it a shot. Couple things:

  • » The open beta is running a copy of the database that will not carry over to the final version. Don't post anything you don't mind losing.
  • » If you wish to use your user account, you will probably need to reset your password.
Your feedback is appreciated via the form on the beta page. Thanks! -Jon & CLFU Team

Export MySQL query as .csv file

Terminal - Export MySQL query as .csv file
echo "SELECT * FROM table; " | mysql -u root -p${MYSQLROOTPW} databasename | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > outfile.csv
2009-02-16 18:55:18
Functions: echo sed
8
Export MySQL query as .csv file

This command converts a MySQL query directly into a .csv (Comma Seperated Value)-file.

Alternatives

There are 2 alternatives - vote for the best!

Terminal - Alternatives

Know a better way?

If you can do better, submit your command here.

What others think

Or you could use the "SELECT * INTO OUTFILE " syntax

http://dev.mysql.com/doc/refman/5.1/en/select.html

Comment by mydarb 413 weeks and 2 days ago

A new pendant is the most useful on the whole item as possible worn at any time and does not desire a reason to become put on for. Pendants for girls today store a fully distinct style and fashion for the unique design. Pendants are available various forms we.e. small , weighty, light-weight, very long etcetera. one of many kinds of rings we've got diamond studded bracelets, rare metal, gold, vogue diamond jewelry charms and so on. Such charms are generally something we simply cannot miss the opportunity specifically during events, events along with presenting uses. Pendants for women may be the very best reward, when it comes to giving equipment because there is few other accent that's numerous different versions and styles. Several charms can be employed by simply a couple of techniques you could use these being a choker along with very long necklace. This is because have got a size realignment supply. Necklaces for female via Daniela Zagnolli tend to be special exotic as well as hand crafted from legitimate leather-based with beautiful coloration styles. Most of these rings for female are generally unique in design and it's really difficult to get a couple of items a similar. To produce women delighted the good thing you can do for is actually, found the girl a gorgeous Daniela Zagnolli throat part while there's nothing much more valuable for you to your ex nowadays than the usual drawing diamond necklace.Talking about handbags for females we see that females love transporting fancy handbags for several events. Previous the word handbag has been limited by operating ladies when they were those accused of to sue handbags consistently. Although, right now we see every other female draping an exclusive handbag. Girls right now consider handbags together nearly all time period. If not any handbag they will a minimum of manage to have a very modest motorola clutch with these which in turn fits their dress-up costume wonderfully. Women of all ages handbags right now is found using a great wide variety in the marketplace and every handbag equates which consists of individual layout and also colour.Necklace along with handbags for girls finishes the could wardrobe and therefore are definitely the many elegant and classy equipment found in your closet. Daniela Zagnolli brings a large variety of remarkable in addition to special bunch of grip and handbags for female. These kinds of grip undoubtedly are a modern-day accent together with easily-removed archipelago band. Besides bracelets and handbags for ladies, women's trend necklaces can also be very attractive. Girls diamond jewelry doesn't have any restriction as there are necklaces, engagement rings, anklet bracelets, head jewelry, , head of hair accessory as well as parts and so on. because there are many versions in man-made as well as fashion ladies jewellery, a lot of women receive quickly consumed by the newest offered pattern. Daniela Zagnolli, anklet bracelets are one of a kind along with unique hand made leather bracelets, that has a legitimate natural leather as well as platinum plated porn stars. It is really an authentic design and style and it's handmade. These kind of necklaces tend to be custom made items, therefore no a couple parts are usually the identical. Trendy seeking pendants, rings, necklaces along with other accessories are very used by your ladies because they have on corresponding charms which works well on the dress-up costume. Thus we have seen an alternative http://www.hermesbeltsbirkinkellybag.co.uk/ range ladies bracelets that's undergone an excellent makeover during these many years. In the long term we will see more adjust as well as wide variety inside the vogue associated with females jewelry because it is something isn't gonna be permanent and you will be modifying on occasion. Daniela Zagnolli, assists a female in order to think additional elegant featuring its distinctive artist clothing's as well as components.

Comment by stephanieg915 3 days ago

You will find beautiful in addition to magnet about a girl transporting a real wallet. Now i'm particularly comfortable to mention one of several attractive additions to some sort of gals apparel really needs to be any handbag. I've received customers tell me that the mama compiled totes and the've ongoing together with the custom made. These kinds of females have stated they think comfortable holding the carrier from your 70s. You plainly can not discussion the particular timelessness connected with a few of these projects.If you will be have never possessed a new bag and are also hunting 1, then you definately may be feeling a bit get over about http://www.hermesbeltsbirkinkellybag.co.uk/ which usually model to acquire. Here are some of this tailor made bags customers arriving more than well as over. A lot of them are extremely latest, although some people might originate from yet another decade. In any event, they have in which great inspiration you are sure that is.Gucci Sukey PursesIn the very last few years, I've come across progressively more ladies having Sukey purses. They can be service totes who have an original shape not like the original rectangle-shaped form the majority of tote bags tend to be recognized by. Probably by far the most well-liked type of this Sukey handbag may be the 211843 type. The vast majority of Sukey that are manufactured from beige-ebony materials include whether black, brown, white-colored or orange lean. They're characterized by a light gold components, double band, take drawing a line under and part pictures. Additionally be aware of the pleat fine detail, within squat budget, studs, as well as easily-removed interlock Grams appeal. Additionally, they can be obtained inssima natural leather.Gucci Pelham PursesThese sorts of carriers tend to be seen as an the size of these are. I actually sometimes think buyers who have never ever frequented a store and just see a graphic with the Pelham tote severely ignore what size they might be. I basically experienced a client return a handbag 137621 Dark Pelham Horsebit Carry since she'd been recently surprised by how large it absolutely was. Pelham totes usually are seen as an two times woven shoulder straps, bill press closing, horse portions, porn stars, bottom ft, in addition to in zip billfold. Additionally they are available in medium in addition to modest amounts however, if weighed against various other personalized bags, it is still larger than the average.Presently there are lots of additional designs nevertheless the 2 above are my top picks. Make sure you check around several price about the bag that you pick.

Comment by stephanieg915 3 days ago

www.canadagoosefemmehomme2016.fr/parka-canada-goose-montebello_214.html

www.canadagoosefemmehomme2016.fr/huron-bomber-canada-goose_335.html

www.canadagoosefemmehomme2016.fr/parka-chateau-canada-goose_94.html

www.canadagoosefemmehomme2016.fr/manteau-canada-goose-femme-prix_422.html

www.canadagoosefemmehomme2016.fr/gants-canada-goose_312.html

www.canadagoosefemmehomme2016.fr/canada-goose-chine_250.html

www.canadagoosefemmehomme2016.fr/canada-goose-veste-femme_363.html

www.canadagoosefemmehomme2016.fr/canada-goose-vrai_249.html

www.canadagoosefemmehomme2016.fr/canada-goose-taille-xs_224.html

www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-pour-femme_475.html

www.canadagoosefemmehomme2016.fr/canada-goose-rabais_88.html

www.canadagoosefemmehomme2016.fr/parka-expedition-canada-goose_452.html

www.canadagoosefemmehomme2016.fr/manteau-canada-goose-a-vendre_450.html

www.canadagoosefemmehomme2016.fr/canada-goose-nantes_367.html

www.canadagoosefemmehomme2016.fr/canada-goose-com_213.html

www.canadagoosefemmehomme2016.fr/canada-goose-huron-bomber_437.html

www.canadagoosefemmehomme2016.fr/yukon-bomber-canada-goose_147.html

www.canadagoosefemmehomme2016.fr/canada-goose-parka-homme_339.html

www.canadagoosefemmehomme2016.fr/canada-goose-mountaineer_477.html

www.canadagoosefemmehomme2016.fr/manteau-type-canada-goose_369.html

www.canadagoosefemmehomme2016.fr/constable-parka-canada-goose_97.html

www.canadagoosefemmehomme2016.fr/canada-goose-noir-homme_384.html

www.canadagoosefemmehomme2016.fr/canada-goose-toronto-outlet_483.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-montebello_90.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-occasion_262.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-victoria_285.html

www.canadagoosefemmehomme2016.fr/canada-goose-homme-pas-cher_440.html

Comment by sguerra376 1 day ago

www.canadagoosefemmehomme2016.fr/canada-goose-grise_80.html

www.canadagoosefemmehomme2016.fr/canada-goose-canada-prix_284.html

www.canadagoosefemmehomme2016.fr/magasin-canada-goose-new-york_396.html

www.canadagoosefemmehomme2016.fr/veste-canada-goose_228.html

www.canadagoosefemmehomme2016.fr/bomber-canada-goose_240.html

www.canadagoosefemmehomme2016.fr/veste-canada-goose-femme-pas-chere_357.html

www.canadagoosefemmehomme2016.fr/canada-goose-toulouse_459.html

www.canadagoosefemmehomme2016.fr/canada-goose-sherbrooke_245.html

www.canadagoosefemmehomme2016.fr/canada-goose-point-de-vente_371.html

www.canadagoosefemmehomme2016.fr/canada-goose-printemps-haussmann_323.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-bleu-marine_151.html

www.canadagoosefemmehomme2016.fr/homme-canadian-goose_180.html

www.canadagoosefemmehomme2016.fr/blouson-canada-goose_156.html

www.canadagoosefemmehomme2016.fr/canada-goose-summit_236.html

www.canadagoosefemmehomme2016.fr/canada-goose-chilliwack-bomber_273.html

www.canadagoosefemmehomme2016.fr/canada-goose-fourrure-amovible_71.html

www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-femme-prix_362.html

www.canadagoosefemmehomme2016.fr/branta-canada-goose_271.html

www.canadagoosefemmehomme2016.fr/manteau-canada-goose-a-vendre_450.html

www.canadagoosefemmehomme2016.fr/canada-goose-vs-pjs_443.html

www.canadagoosefemmehomme2016.fr/canada-goose-metz_445.html

www.canadagoosefemmehomme2016.fr/blouson-canada-goose-pas-cher_78.html

www.canadagoosefemmehomme2016.fr/site-canada-goose_352.html

Comment by sguerra376 14 hours ago

www.canadagoosefemmehomme2016.fr/montebello-parka-canada-goose_287.html

www.canadagoosefemmehomme2016.fr/yorkville-canada-goose_463.html

www.canadagoosefemmehomme2016.fr/goose-femme_52.html

www.canadagoosefemmehomme2016.fr/revendeur-canada-goose-france_401.html

www.canadagoosefemmehomme2016.fr/canada-goose-banff_129.html

www.canadagoosefemmehomme2016.fr/manteau-canada-goose-enfant_405.html

www.canadagoosefemmehomme2016.fr/parka-montebello-canada-goose_379.html

www.canadagoosefemmehomme2016.fr/canada-goose-solaris-parka_375.html

www.canadagoosefemmehomme2016.fr/lodge-hoody-canada-goose_133.html

www.canadagoosefemmehomme2016.fr/canada-goose-montreal_267.html

www.canadagoosefemmehomme2016.fr/canada-goose-freestyle_324.html

www.canadagoosefemmehomme2016.fr/marque-doudoune-canada-goose_74.html

www.canadagoosefemmehomme2016.fr/canada-goose-pour-enfant_217.html

www.canadagoosefemmehomme2016.fr/canada-goose-site_385.html

www.canadagoosefemmehomme2016.fr/canada-goose-montebello-parka_81.html

www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-paris_144.html

www.canadagoosefemmehomme2016.fr/solaris-parka-canada-goose_110.html

www.canadagoosefemmehomme2016.fr/canada-goose-kaki_251.html

www.canadagoosefemmehomme2016.fr/canada-goose-outlet_132.html

www.canadagoosefemmehomme2016.fr/chateau-parka-canada-goose_225.html

www.canadagoosefemmehomme2016.fr/doudoune-homme-canada-goose_366.html

www.canadagoosefemmehomme2016.fr/site-canada-goose_352.html

www.canadagoosefemmehomme2016.fr/parka-canada-goose-expedition_381.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-occasion_262.html

www.canadagoosefemmehomme2016.fr/canada-goose-au-canada-prix_54.html

www.canadagoosefemmehomme2016.fr/vetements-canada-goose_64.html

www.canadagoosefemmehomme2016.fr/canada-goose-parka-chateau_427.html

Comment by sguerra376 12 hours ago

www.canadagoosefemmehomme2016.fr/canada-goose-grise-homme_468.html

www.canadagoosefemmehomme2016.fr/fr-canada-goose_182.html

www.canadagoosefemmehomme2016.fr/canada-goose-paris-magasin_420.html

www.canadagoosefemmehomme2016.fr/canada-goose-ou-parajumpers_414.html

www.canadagoosefemmehomme2016.fr/veste-canada-goose-homme-pas-cher_199.html

www.canadagoosefemmehomme2016.fr/femmes-canada-goose_281.html

www.canadagoosefemmehomme2016.fr/canada-goose-blouson-aviateur-chilliwack-homme_321.html

www.canadagoosefemmehomme2016.fr/canada-goose-chateau-parka_247.html

www.canadagoosefemmehomme2016.fr/canada-goose-enfant_264.html

www.canadagoosefemmehomme2016.fr/goose-canada-pas-cher_140.html

www.canadagoosefemmehomme2016.fr/canada-goose-pas-cher_455.html

www.canadagoosefemmehomme2016.fr/canada-goose-homme-parka_111.html

www.canadagoosefemmehomme2016.fr/logo-canada-goose_138.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-pas-cher_139.html

www.canadagoosefemmehomme2016.fr/canada-goose-violette_121.html

www.canadagoosefemmehomme2016.fr/canada-goose-solaris_107.html

www.canadagoosefemmehomme2016.fr/parka-canada-goose-expedition_381.html

www.canadagoosefemmehomme2016.fr/canada-goose-jogging_460.html

www.canadagoosefemmehomme2016.fr/canada-goose-montpellier_353.html

www.canadagoosefemmehomme2016.fr/resolute-canada-goose_116.html

www.canadagoosefemmehomme2016.fr/manteau-canada-goose-prix_332.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-solde_457.html

www.canadagoosefemmehomme2016.fr/canada-goose-toronto-outlet_483.html

Comment by sguerra376 11 hours ago

www.canadagoosefemmehomme2016.fr/canada-goose-laval_347.html

www.canadagoosefemmehomme2016.fr/canada-goose-banff_129.html

www.canadagoosefemmehomme2016.fr/canada-goose-milan_99.html

www.canadagoosefemmehomme2016.fr/selkirk-canada-goose_77.html

www.canadagoosefemmehomme2016.fr/canada-goose-montreal_267.html

www.canadagoosefemmehomme2016.fr/manteau-canada-goose-femme_44.html

www.canadagoosefemmehomme2016.fr/canada-goose-grise-homme_468.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-victoria_285.html

www.canadagoosefemmehomme2016.fr/canada-goose-kensington_86.html

www.canadagoosefemmehomme2016.fr/blouson-canada-goose-femme_143.html

www.canadagoosefemmehomme2016.fr/blouson-canada-goose-homme_467.html

www.canadagoosefemmehomme2016.fr/canada-goose-prix-canada_277.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-courte_322.html

www.canadagoosefemmehomme2016.fr/revendeur-canada-goose-france_401.html

www.canadagoosefemmehomme2016.fr/canada-goose-grande-taille_92.html

www.canadagoosefemmehomme2016.fr/blouson-goose-canada_195.html

www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-homme-prix_243.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-occasion_262.html

www.canadagoosefemmehomme2016.fr/canada-goose-freestyle_324.html

www.canadagoosefemmehomme2016.fr/canada-goose-fourrure-amovible_71.html

www.canadagoosefemmehomme2016.fr

www.canadagoosefemmehomme2016.fr/parka-banff-canada-goose_417.html

www.canadagoosefemmehomme2016.fr/manitoba-canada-goose_482.html

www.canadagoosefemmehomme2016.fr/soldes-canada-goose_137.html

www.canadagoosefemmehomme2016.fr/canada-goose-homme-solde_255.html

Comment by sguerra376 7 hours ago

Your point of view

You must be signed in to comment.