I've been doing a ton of MySQL work lately, migrating millions of records of content to a new Drupal platform.
One problem I ran into using the MySQL command-line client was trying to read the output of columns with long text content.
mysql> SELECT cid, nid, uid, subject, comment FROM comments LIMIT 1; +-----+-----+-----+---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | cid | nid | uid | subject | comment | +-----+-----+-----+---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 7 | 35 | 0 | Thanks for the code. But | Thanks for the code. But where should I keep it? In one of my website contributed modules and themes are mixed with core modules and themes, respectively. It is very difficult to figure out specified modules in that big list. I want to separate them, should I just cut and paste the folder in the sites/all/contrib folder after adding the above code? | +-----+-----+-----+---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
I learned a simple but helpful trick from Cameron Guill (DBA at Morris Digitalworks) to get easier to read output from this kind of query. Instead of ending your query statement with the usual semicolon, instead use "\G" to get the following:
mysql> SELECT cid, nid, uid, subject, comment FROM comments LIMIT 1\G
*************************** 1. row ***************************
cid: 7
nid: 35
uid: 0
subject: Thanks for the code.
But
comment: Thanks for the code.
But where should I keep it?
In one of my website contributed modules and themes are mixed with core modules and themes, respectively. It is very difficult to figure out specified modules in that big list. I want to separate them, should I just cut and paste the folder in the sites/all/contrib folder after adding the above code?
1 row in set (0.00 sec)That's much nice and much easier to read, isn't it?
Comments
Air Jordan
Jordan lorsque michael jordan intégra le monde de la nba en 1984, ce ne fut pas seulement le début d'une carrière sans égal, mais aussi
le début de la série célèbre "Air Jordan" de nike. le fabricant d'articles de sport accorda toute
une série de chaussures et d'habits au basketteur doté apparemment de talents surhumain. cette série fit tout de suite sensation : l' Air Jordan 1 fut interdite par la nba puisque la combinaison des coloris noir/rouge ne
correspondit pas au "code vestimentaire" de la nba à l'époque. pourtant, cela ne put empêcher le succès mondial de cette sneaker unique.
au contraire : la chaussure de basket déclencha une véritable hystérie et est, dès lors, lancée dans une nouvelle édition chaque
année.jordan - plus qu'une simple chaussure de basket les spots publicitaires de jordan sont aussi innovateurs que les produits eux-
mêmes. au cours des années 80, avec spike lee alias mars blackmon, ils conquirent les écrans de la télé. aujourd'hui, les spots pour les
différents modèles d'air jordan sont toujours de vrais classiques sur youtube. de nos jurs, le jumpman ne se porte pas seulement sur les
chaussures : Air Jordan 3, Air Jordan
4, Air Jordan 5, Air Jordan 6,
Air Jordan 7, Air Jordan Spizike.
ils se distinguent par le design typique de la marque et convainquent par une excellente qualité et des matières hut de gamme. en 1997,
nike externalisa même la série de jordan : aujourd'hui, la marque de jordan développe ses propres produits, mais coopère néanmoins
étroitement avec nike. des joueurs comme carmelo anthony ou dwyane wade portent le jumpman dans la nba. ainsi, michael jordan reste
présent dans la meilleure ligue de basket-ball du monde. Obtenez les dernières Air
Jordan 2012 Chaussures avec style avant-gardiste et la technologie. Obtenez les dernières Chaussures Air Jordan avec style avant-
gardiste et la technologie. Boutique 100% authentique Nike Air Jordan à partir des collections les
plus emblématiques. Air Jordan Retro, Fusion, Hommes, Femmes et Enfants Chaussures.
Isabel Marant Shoes
Isabel Marant Shoes Isabel Marant Sneakers Isabel Marant Boots Isabel Marant Heels ay Ban Aviator Ray Ban Wayfarer Ray Ban Active Lifestyle Ray Ban 3025 Ray Ban 2140 Ray Ban 2132
Nike TN Nike TN Requin Nike
Nike TN Nike TN Requin Nike TN Pas Cher
TN Pas Cher Nike TN TN Nike Requin TN
t shirt t shirt pas cher t-shirt homme Requin TN
TN Pas Cher Nike tn 2012 tn foot locker TN REQUIN Nike TN Nike Requin Chaussure Requin Air Max Requin TN Pas Cher Puma Pas Cher
Coach Outlet is designed so
Coach Outlet is designed so elegance and it is cheap sale Coach Outlet Online. The handbags are one of the most popular designer handbags on the Coach Outlet Online today. Coach Colette Handbags which is one of the classic styles of Coach Outlet. Colorful appearance and beauty accessories are the point of Coach Purses Outlet. These Coach Colette Bags are must-have from this classic Coach family. The traditional stylish Cheap Coach Handbags with gorgeously and luxuriously dotted coach print appearance, updates an Coach Factory extremely clean and extremely modern day time style research to accomplish Coach Outlet Online a alluring stylish coach bags. Every professional woman needs a good handbags. No matter what your industry or position. Colorful appearance and beauty accessories are the point of Coach Colette Bags.Every professional woman needs a good handbags. No matter what your industry or position, a Coach Factory Outlet is essential for anyone to be taken seriously at the condition. Welcome to our website and we will provide the best Coach Colette Handbags and best service for dear customers.
Goyard Wallet
Most people provide Goyard Handbags, all of all of our Goyard Bags available for purchase are typically high quality amount, fully confident to make sure some anything you purchase could be the most effective.Goyard St Louis this sort of beauty! i actually appeared to be continue to deliberating upon it whenever i identified not wearing running shoes expenditures just about $900 even so i uncovered outside them contains the following minimal designer purse hence i'm just bought! Now, usually there are some components of information for the exceptional goyard tote prospective buyers for goyard-bags.org.You may choose the techniques you will be involved.Obtain goyard wallet originating from a wide selection with internet shop.
True Religion Outlet
As we all know, the http://nikeoutletcheap.com/ end of a single number is not much, so most of them are fake.So how to identify genuine and fake foreign trade last single has become a headache. the original single goodsThe original http://nikeonlines.com/ single shipment of foreign trade in the true sense of the end of a single cargo. All of these commodities with the fabric / accessories http://truereligioncheapoutlete.com/ type version is provided by foreign brands in the domestic manufacturers out of the best equipment and management, these jeans, if the quality is perfect, it http://www.truereligiononlinecheap.com/ will become really expensive goods in the store. However, due to the very strict quality inspection, there is always a small part of the brand declined, and returned, so it was a real sense of the foreign trade last single, these products are often not low quality, a small number, due to defects, usually cut http://truereligiononlinestore.com/ standard by manufacturers generally to the market is three to one-fifth of the price of the genuine.
cheap oakley sunglasses
on this summer season,the fake oakley sunglasses are most popular for people who like to traveling and sporting,because it oakley sunglasses on sale for great discount,welcome yout to buy cheap oakley sunglasses online. http://www.oakleycheaponsale.com
cheap oakley sunglasses
We provide the 2012 oakley sunglasses discount in oakley sunglasses outlet Online store,I recommend the cheap oakley sunglasses sale up to 80% Off,our discount oakley sunglasses outlet sale top quality oakley sunglasses,100% secure safe and money back guarantee! http://www.oakleysunglassesis.com
Mont Blanc Pens
Mont Blanc Pens|
cheap mont blanc|
longchamp handbags|
longchamp wallets|
longchamp sale|
longchamp bags|
longchamp bags on sale|
longchamp outlet|
Puma 2012
Puma Speed Cat Suede, Puma 2012, Cheap Air Max Classic BW, Air Jordan VII, Nike Air Max Cheap , Air Jordan XI, Air Jordan I, puma drift cat ii suede, Nike Air Max Press, Nike Air Max 2011 Shoes, Air Max 2012 Uk, Air Max LTD, Nike Air Max 90 Hyperfuse, Air Jordan V, Nike Air Max 95, Air Max UK, Air Max 95 Cheap, Nike Air Max Cheap, Cheap Air Max 90, Nike Air Max 87, Air Jordan VIII, Nike Air Max Cheap, Jordan 13 Max Fusion, Puma Drift Cat Shoes, Puma Big Speed Cat Shoes, Nike Air Max LTD, Jordan Fusion, Air Jordan VIII, Air Jordan XII, Nike Air Max Shoes, Cheap Air Max 90, Puma Online, Nike Air Max 90 Hyperfuse, Nike Air Max 2012, Air Max 95, Nike Air Max Classic BW, Puma Running Shoes Sale, Puma Ferrari Drift Cat Trainers Sale, Cheap Jordan Fusion, Nike Air Max 1 UK"the article is composed by seoerbin 20120517"
Louis Vuitton outlet
zhong 123456 The Louis Vuitton Bagsis such a popular luxury brand that louis vuitton purses handbags Louis Vuitton outlet Online when you are carrying it authentic louis vuitton handbags Louis Vuitton sale you are bound to attract attention from admirers. Louis Vuitton online If you want to make a LV yours forever then you should visit
Louis Vuitton bags the outlet which gives you a deal that is louis vuitton women bags tempting. It offers you great prices and numerous designs to take your pick from. And since you are taking your pick from a Louis Vuitton outlet be Welcome to purchase authentic Louis Vuitton handbags from our site Men Louis Vuitton Oultet rest assured that your sell used louis vuitton Louis Vuitton outlet can withstand the test of time and is louis vuitton
Men Louis Vuitton Oultet equally long lasting as that of the original ones. This means you do not have to sacrifice quality in Louis Vuitton outlet exchange of low prices.Are you a fashion hand bags fanatic? Does the sight of louis vuitton mens handbags make you go crazy over Louis Vuitton Outlet it and you want to make it your own? A Louis Vuitton handbag Louis Vuitton Women Sale is a gorgeous piece of art and one of the labels that are most sought after by all the fashion divas and the followers. They are stylish and elegant and are available for all kinds of occasions. Louis Vuitton handBags You have the choice, the taste but you cannot go beyond a certain budget to fulfill your dream Louis Vuitton Handbags of owning a Louis Vuitton handbag. Of all the Louis Vuitton Handbags sale knock-off purse brands,louis vuitton womens Louis Vuitton probably has the most. Cheap Louis Vuitton Bags Since the purses are so expensive, women are drawn to ads that promise authentic handbags at a fraction of the price. Louis Vuitton outlet uk The only problem is that the purses tend to fall apart after just a month or two. In most cases,Louis Vuitton Outlet they are easily spotted as Louis Vuitton Travel a knock-off. louis vuitton mens Protect yourself and your money by learning Louis Vuitton online how to spot a fake Louis Vuitton purse.
Post new comment