CINXE.COM

<!DOCTYPE html>     <html lang="en">  <head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=HxkREWBo" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script>window.RufflePlayer=window.RufflePlayer||{};window.RufflePlayer.config={"autoplay":"on","unmuteOverlay":"hidden"};</script> <script type="text/javascript" src="/_static/js/ruffle/ruffle.js"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("http://magp.ie:80/tag/mysql/","20130127123217","https://web.archive.org/","web","/_static/", "1359289937"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=3PDvdIFv" />  <meta charset="UTF-8"/> <meta name="viewport" content="width=device-width"/> <title>MySQL | Magp.ie</title> <link rel="profile" href="http://gmpg.org/xfn/11"/> <link rel="stylesheet" type="text/css" media="all" href="https://web.archive.org/web/20130127123217cs_/http://s2.wp.com/wp-content/themes/pub/twentyeleven/style.css?m=1357837687g"/> <link rel="pingback" href="http://magp.ie/xmlrpc.php"/>  <meta name="google-site-verification" content="ltxwsji8RKfu7Qj15fAQWhwT_K3vrCH1tcK9u84CWM8"/> <script src="https://web.archive.org/web/20130127123217js_/http://r-login.wordpress.com/remote-login.php?action=js&host=magp.ie&id=11708208&t=1359289936&back=magp.ie%2Ftag%2Fmysql%2F" type="text/javascript"></script> <script type="text/javascript"> /* <![CDATA[ */ if ( 'function' === typeof WPRemoteLogin ) { document.cookie = "wordpress_test_cookie=test; path=/"; if ( document.cookie.match( /(;|^)\s*wordpress_test_cookie\=/ ) ) { WPRemoteLogin(); } } /* ]]> */ </script> <link rel="alternate" type="application/rss+xml" title="Magp.ie 禄 Feed" href="https://web.archive.org/web/20130127123217/http://magp.ie/feed/"/> <link rel="alternate" type="application/rss+xml" title="Magp.ie 禄 Comments Feed" href="https://web.archive.org/web/20130127123217/http://magp.ie/comments/feed/"/> <link rel="alternate" type="application/rss+xml" title="Magp.ie 禄 MySQL Tag Feed" href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/mysql/feed/"/> <script type="text/javascript"> /* <![CDATA[ */ function addLoadEvent(func){var oldonload=window.onload;if(typeof window.onload!='function'){window.onload=func;}else{window.onload=function(){oldonload();func();}}} /* ]]> */ </script> <link rel="stylesheet" id="all-css-0" href="https://web.archive.org/web/20130127123217cs_/http://s1.wp.com/_static/??-eJyNzdEKQiEMBuAXylYng7qInuXoWWpMJ8eZnLfPiCKIoKv9jO/foGVlOQkmAUPsVKbqQirQs8OJq6gLE3GDFiaHsralrOCjFOu7krl0TWOYochC+GXFY8TuqgFpfbEg4Q3TU6uWLcd/7/txDsm95q9PXoMjNiM9wDmetrv94bgZBq2vd2oRXM4=" type="text/css" media="all"/> <script type="text/javascript"> /* <![CDATA[ */ var LoggedOutFollow = {"invalid_email":"Your subscription did not succeed, please try again with a valid email address."}; /* ]]> */ </script> <script type="text/javascript" src="https://web.archive.org/web/20130127123217js_/http://s0.wp.com/_static/??/wp-includes/js/jquery/jquery.js,/wp-content/blog-plugins/loggedout-follow/widget.js?m=1354137473j"></script> <link rel="EditURI" type="application/rsd+xml" title="RSD" href="http://blogalhost.wordpress.com/xmlrpc.php?rsd"/> <link rel="wlwmanifest" type="application/wlwmanifest+xml" href="http://blogalhost.wordpress.com/wp-includes/wlwmanifest.xml"/> <meta name="generator" content="WordPress.com"/> <link rel="shortcut icon" type="image/x-icon" href="https://web.archive.org/web/20130127123217im_/http://1.gravatar.com/blavatar/fbe42d2ab251c56150b55bf337e873bc?s=16" sizes="16x16"/> <link rel="icon" type="image/x-icon" href="https://web.archive.org/web/20130127123217im_/http://1.gravatar.com/blavatar/fbe42d2ab251c56150b55bf337e873bc?s=16" sizes="16x16"/> <link rel="apple-touch-icon-precomposed" href="https://web.archive.org/web/20130127123217im_/http://0.gravatar.com/blavatar/061e340c5da13b5a41ae8016bee03aa8?s=114"/> <link rel="openid.server" href="http://blogalhost.wordpress.com/?openidserver=1"/> <link rel="openid.delegate" href="http://blogalhost.wordpress.com/"/> <link rel="search" type="application/opensearchdescription+xml" href="https://web.archive.org/web/20130127123217/http://magp.ie/osd.xml" title="Magp.ie"/> <link rel="search" type="application/opensearchdescription+xml" href="https://web.archive.org/web/20130127123217/http://wordpress.com/opensearch.xml" title="WordPress.com"/> <style> /* <![CDATA[ */ /* Block: reblog */ .reblog-from img { margin: 0 10px 0 0; vertical-align: middle; padding: 0; border: 0; } .reblogger-note img.avatar { float: left; padding: 0; border: 0; } .reblogger-note-content { margin: 0 0 20px; } .reblog-post .wpcom-enhanced-excerpt-content { border-left: 3px solid #eee; padding-left: 15px; } .reblog-post ul.thumb-list { display: block; list-style: none; margin: 2px 0; padding: 0; clear: both; } .reblog-post ul.thumb-list li { display: inline; margin: 0; padding: 0 1px; border: 0; } .reblog-post ul.thumb-list li a { margin: 0; padding: 0; border: 0; } .reblog-post ul.thumb-list li img { margin: 0; padding: 0; border: 0; } .reblog-post .wpcom-enhanced-excerpt { clear: both; } .reblog-post .wpcom-enhanced-excerpt address, .reblog-post .wpcom-enhanced-excerpt li, .reblog-post .wpcom-enhanced-excerpt h1, .reblog-post .wpcom-enhanced-excerpt h2, .reblog-post .wpcom-enhanced-excerpt h3, .reblog-post .wpcom-enhanced-excerpt h4, .reblog-post .wpcom-enhanced-excerpt h5, .reblog-post .wpcom-enhanced-excerpt h6, .reblog-post .wpcom-enhanced-excerpt p { font-size: 100% !important; } .reblog-post .wpcom-enhanced-excerpt blockquote, .reblog-post .wpcom-enhanced-excerpt pre, .reblog-post .wpcom-enhanced-excerpt code, .reblog-post .wpcom-enhanced-excerpt q { font-size: 98% !important; } /* ]]> */ </style> <script type="text/javascript" src="//web.archive.org/web/20130127123217js_/http://use.typekit.net/yrt0waj.js"></script><script type="text/javascript">try{Typekit.load();}catch(e){}</script> <meta name="application-name" content="Magp.ie"/><meta name="msapplication-window" content="width=device-width;height=device-height"/><meta name="msapplication-tooltip" content="A nest for the random, shiny, online tidbits I stumble across..."/><meta name="msapplication-task" content="name=Subscribe;action-uri=http://magp.ie/feed/;icon-uri=http://1.gravatar.com/blavatar/fbe42d2ab251c56150b55bf337e873bc?s=16"/><meta name="msapplication-task" content="name=Sign up for a free blog;action-uri=http://wordpress.com/signup/;icon-uri=http://s2.wp.com/i/favicon.ico"/><meta name="msapplication-task" content="name=WordPress.com Support;action-uri=http://support.wordpress.com/;icon-uri=http://s2.wp.com/i/favicon.ico"/><meta name="msapplication-task" content="name=WordPress.com Forums;action-uri=http://forums.wordpress.com/;icon-uri=http://s2.wp.com/i/favicon.ico"/><meta name="title" content="Posts about MySQL on Magp.ie"/> <meta name="description" content="Posts about MySQL written by Eoin"/> <link rel="stylesheet" id="custom-css-css" type="text/css" href="https://web.archive.org/web/20130127123217cs_/http://s0.wp.com/?custom-css=1&csblog=N7Q4&cscache=6&csrev=76"/> </head> <body class="archive tag tag-mysql tag-4419 typekit-enabled single-author two-column right-sidebar highlander-enabled highlander-light"> <div id="page" class="hfeed"> <header id="branding" role="banner"> <hgroup> <h1 id="site-title"><span><a href="https://web.archive.org/web/20130127123217/http://magp.ie/" title="Magp.ie" rel="home">Magp.ie</a></span></h1> <h2 id="site-description">A nest for the random, shiny, online tidbits I stumble across…</h2> </hgroup> <form method="get" id="searchform" action="https://web.archive.org/web/20130127123217/http://magp.ie/"> <label for="s" class="assistive-text">Search</label> <input type="text" class="field" name="s" id="s" placeholder="Search"/> <input type="submit" class="submit" name="submit" id="searchsubmit" value="Search"/> </form> <nav id="access" role="navigation"> <h3 class="assistive-text">Main menu</h3> <div class="skip-link"><a class="assistive-text" href="#content" title="Skip to primary content">Skip to primary content</a></div> <div class="skip-link"><a class="assistive-text" href="#secondary" title="Skip to secondary content">Skip to secondary content</a></div> <div class="menu"><ul><li><a href="https://web.archive.org/web/20130127123217/http://magp.ie/" title="Home">Home</a></li><li class="page_item page-item-2"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/about/">About me…</a></li></ul></div> </nav> </header> <div id="main"> <section id="primary"> <div id="content" role="main"> <header class="page-header"> <h1 class="page-title">Tag Archives: <span>MySQL</span></h1> </header> <article id="post-762" class="post-762 post type-post status-publish format-standard hentry category-code tag-bash tag-duplicates tag-mysql tag-scripting tag-sort tag-uniq"> <header class="entry-header"> <h1 class="entry-title"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/10/26/quick-way-to-find-duplicate-entries-in-mysql-table/" title="Permalink to Quick way to find duplicate entries in MySQL聽table" rel="bookmark">Quick way to find duplicate entries in MySQL table</a></h1> <div class="entry-meta"> <span class="sep">Posted on </span><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/10/26/quick-way-to-find-duplicate-entries-in-mysql-table/" title="18:27" rel="bookmark"><time class="entry-date" datetime="2012-10-26T18:27:39+00:00">October 26, 2012</time></a><span class="by-author"> <span class="sep"> by </span> <span class="author vcard"><a class="url fn n" href="https://web.archive.org/web/20130127123217/http://magp.ie/author/eoigal/" title="View all posts by Eoin" rel="author">Eoin</a></span></span> </div> <div class="comments-link"> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/10/26/quick-way-to-find-duplicate-entries-in-mysql-table/#comments" title="Comment on Quick way to find duplicate entries in MySQL聽table">3</a> </div> </header> <div class="entry-content"> <p>I recently needed a script that could find duplicate entries in a particular table so I wrote the following bash script…<br/> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/10/26/quick-way-to-find-duplicate-entries-in-mysql-table/#more-762" class="more-link">Continue reading <span class="meta-nav">→</span></a></p> <div id="geo-post-762" class="geo geo-post" style="display: none"> <span class="latitude">53.734750</span> <span class="longitude">-8.989992</span> </div><div id="jp-post-flair" class="sharedaddy sd-rating-enabled sd-like-enabled sd-sharing-enabled"></div> </div> <footer class="entry-meta"> <span class="cat-links"> <span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/category/code/" title="View all posts in Code" rel="category tag">Code</a> </span> <span class="sep"> | </span> <span class="tag-links"> <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/bash/" rel="tag">bash</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/duplicates/" rel="tag">duplicates</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/mysql/" rel="tag">MySQL</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/scripting/" rel="tag">scripting</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/sort/" rel="tag">sort</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/uniq/" rel="tag">uniq</a> </span> <span class="sep"> | </span> <span class="comments-link"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/10/26/quick-way-to-find-duplicate-entries-in-mysql-table/#comments" title="Comment on Quick way to find duplicate entries in MySQL聽table"><b>3</b> Replies</a></span> </footer> </article> <article id="post-704" class="post-704 post type-post status-publish format-standard hentry category-guides tag-cheat-sheet tag-mysql"> <header class="entry-header"> <h1 class="entry-title"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/02/21/mysql-cheat-sheet/" title="Permalink to MySQL Cheat Sheet and Field Type聽Sizes" rel="bookmark">MySQL Cheat Sheet and Field Type Sizes</a></h1> <div class="entry-meta"> <span class="sep">Posted on </span><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/02/21/mysql-cheat-sheet/" title="20:42" rel="bookmark"><time class="entry-date" datetime="2012-02-21T20:42:12+00:00">February 21, 2012</time></a><span class="by-author"> <span class="sep"> by </span> <span class="author vcard"><a class="url fn n" href="https://web.archive.org/web/20130127123217/http://magp.ie/author/eoigal/" title="View all posts by Eoin" rel="author">Eoin</a></span></span> </div> <div class="comments-link"> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/02/21/mysql-cheat-sheet/#respond" title="Comment on MySQL Cheat Sheet and Field Type聽Sizes"><span class="leave-reply">Reply</span></a> </div> </header> <div class="entry-content"> <p>Handy <a title="MySQL Cheat Sheet" href="https://web.archive.org/web/20130127123217/http://www.nparikh.org/unix/mysql.php" target="_blank">MySQL cheat sheet from Neal Parikh</a></p> <p>Breakdown of <a href="https://web.archive.org/web/20130127123217/http://help.scibit.com/mascon/masconMySQL_Field_Types.html" target="_blank" title="MySQL Field Types">MySQL Field Types</a> with their corresponding sizes.</p> <div id="geo-post-704" class="geo geo-post" style="display: none"> <span class="latitude">53.734750</span> <span class="longitude">-8.989992</span> </div><div id="jp-post-flair" class="sharedaddy sd-rating-enabled sd-like-enabled sd-sharing-enabled"></div> </div> <footer class="entry-meta"> <span class="cat-links"> <span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/category/guides/" title="View all posts in Guides" rel="category tag">Guides</a> </span> <span class="sep"> | </span> <span class="tag-links"> <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/cheat-sheet/" rel="tag">cheat sheet</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/mysql/" rel="tag">MySQL</a> </span> <span class="sep"> | </span> <span class="comments-link"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2012/02/21/mysql-cheat-sheet/#respond" title="Comment on MySQL Cheat Sheet and Field Type聽Sizes"><span class="leave-reply">Leave a reply</span></a></span> </footer> </article> <article id="post-6" class="post-6 post type-post status-publish format-standard hentry category-guides tag-mysql tag-port-forwarding tag-putty tag-ssh"> <header class="entry-header"> <h1 class="entry-title"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2010/01/30/ssh-windows/" title="Permalink to How to SSH into remote database from聽Windows" rel="bookmark">How to SSH into remote database from Windows</a></h1> <div class="entry-meta"> <span class="sep">Posted on </span><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2010/01/30/ssh-windows/" title="00:12" rel="bookmark"><time class="entry-date" datetime="2010-01-30T00:12:34+00:00">January 30, 2010</time></a><span class="by-author"> <span class="sep"> by </span> <span class="author vcard"><a class="url fn n" href="https://web.archive.org/web/20130127123217/http://magp.ie/author/eoigal/" title="View all posts by Eoin" rel="author">Eoin</a></span></span> </div> <div class="comments-link"> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/2010/01/30/ssh-windows/#comments" title="Comment on How to SSH into remote database from聽Windows">5</a> </div> </header> <div class="entry-content"> <p>If you find yourself with a bust Mac and you have to fall back on your old ‘reliable’ windows laptop. You need to connect to your development web server using SSH, where do you start… I’ll tell you where, <a title="Help" href="https://web.archive.org/web/20130127123217/http://google.com/" target="_blank">Google</a>, or you may find this guide of some use.</p> <p>So firstly, I need to set up PuTTY,聽a free and open source terminal emulator that will allow me to SSH into my remote web server.</p> <p>Download PuTTY <a title="PuTTY Download" href="https://web.archive.org/web/20130127123217/http://www.chiark.greenend.org.uk/~sgtatham/putty/" target="_blank">here</a>.</p> <p>Once downloaded, I need to generate a public/private key to authenticate the SSH connection from my machine to the web server.</p> <p>Use another tool – PuTTYGen to generate the keys for you.</p> <p>Download PuTTYGen <a title="PuTTYGen Download" href="https://web.archive.org/web/20130127123217/http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html" target="_blank">here</a>.</p> <p>Here’s a pretty straightforward <a title="Generate SSH Keys" href="https://web.archive.org/web/20130127123217/http://www.howtoforge.com/ssh_key_based_logins_putty_p2" target="_blank">guide</a> that I cannot be arsed to repeat on how to create the key. One difference for me was we use DSA encryption.</p> <p><strong>HANDY TIP:</strong> If you wish to use this key on a Mac (like I did once it was repaired) so that you can connect from either machine (windows or mac), then do the following.</p> <p>Once you have your key created you need to export the key as an OpenSSL key and save it for later.</p> <p><a href="https://web.archive.org/web/20130127123217/http://blogalhost.files.wordpress.com/2010/01/export-openssh.gif"><img class="alignnone size-full wp-image-7" title="Export OpenSSH" src="https://web.archive.org/web/20130127123217im_/http://blogalhost.files.wordpress.com/2010/01/export-openssh.gif?w=584" alt=""/></a></p> <p>On with the guide…<br/> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/2010/01/30/ssh-windows/#more-6" class="more-link">Continue reading <span class="meta-nav">→</span></a></p> <div id="geo-post-6" class="geo geo-post" style="display: none"> <span class="latitude">53.734750</span> <span class="longitude">-8.989992</span> </div><div id="jp-post-flair" class="sharedaddy sd-rating-enabled sd-like-enabled sd-sharing-enabled"></div> </div> <footer class="entry-meta"> <span class="cat-links"> <span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/category/guides/" title="View all posts in Guides" rel="category tag">Guides</a> </span> <span class="sep"> | </span> <span class="tag-links"> <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/mysql/" rel="tag">MySQL</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/port-forwarding/" rel="tag">Port forwarding</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/putty/" rel="tag">PuTTY</a>, <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/ssh/" rel="tag">SSH</a> </span> <span class="sep"> | </span> <span class="comments-link"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/2010/01/30/ssh-windows/#comments" title="Comment on How to SSH into remote database from聽Windows"><b>5</b> Replies</a></span> </footer> </article> </div> </section> <div id="secondary" class="widget-area" role="complementary"> <aside id="blog_subscription-3" class="widget widget_blog_subscription"> <form action="https://web.archive.org/web/20130127123217/https://subscribe.wordpress.com/" method="post" accept-charset="utf-8" id="subscribe-blog"> <p>Join 257 other followers</p> <p><input type="text" name="email" style="width: 95%; padding: 1px 2px" value="" id="subscribe-field"/></p> <p> <input type="hidden" name="action" value="subscribe"/> <input type="hidden" name="blog_id" value="11708208"/> <input type="hidden" name="source" value="http://magp.ie/tag/mysql/"/> <input type="hidden" name="sub-type" value="widget"/> <input type="hidden" name="redirect_fragment" value="blog_subscription-3"/> <input type="hidden" id="_wpnonce" name="_wpnonce" value="5492d30b2a"/> <input type="submit" value="Subscribe to email"/> </p> </form> </aside><aside id="nav_menu-3" class="widget widget_nav_menu"><h3 class="widget-title">Categories</h3><div class="menu-catergories-container"><ul id="menu-catergories" class="menu"><li id="menu-item-273" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-273"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/category/code/">Code</a></li> <li id="menu-item-274" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-274"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/category/guides/">Guides</a></li> <li id="menu-item-275" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-275"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/category/shortcuts/">Shortcuts</a></li> </ul></div></aside><aside id="pd_top_rated-2" class="widget top_rated"><h3 class="widget-title">Top Rated</h3><div id="pd_top_rated_holder"></div><script language="javascript" src="https://web.archive.org/web/20130127123217js_/http://i.polldaddy.com/js/top-rated.js"></script><script language="javascript" type="text/javascript">PDRTJS_TOP = new PDRTJS_RATING_TOP( 4096552, 1247824, 6383034, '100', 3 );PDRTJS_TOP.get_top( 'posts', '0' );</script></aside><aside id="text-3" class="widget widget_text"><h3 class="widget-title">Poll</h3> <div class="textwidget"><a name="pd_a_3159187"></a> <div class="PDS_Poll" id="PDI_container3159187" style="display:inline-block;"></div> <div id="PD_superContainer"></div> <script type="text/javascript" charset="UTF-8" src="https://web.archive.org/web/20130127123217js_/http://static.polldaddy.com/p/3159187.js"></script> <noscript><a href="https://web.archive.org/web/20130127123217/http://polldaddy.com/poll/3159187">Take Our Poll</a></noscript></div> </aside><aside id="wp_tag_cloud" class="widget wp_widget_tag_cloud"><h3 class="widget-title">Content</h3><div style="overflow:hidden"><a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/aliases/" class="tag-link-885498" title="1 topic" style="font-size: 8pt;">aliases</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/array/" class="tag-link-271798" title="2 topics" style="font-size: 10.964705882353pt;">array</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/bash/" class="tag-link-2674" title="9 topics" style="font-size: 19.529411764706pt;">bash</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/character-set/" class="tag-link-1172285" title="1 topic" style="font-size: 8pt;">character set</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/cheat-sheet/" class="tag-link-57214" title="2 topics" style="font-size: 10.964705882353pt;">cheat sheet</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/coda/" class="tag-link-592018" title="2 topics" style="font-size: 10.964705882353pt;">coda</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/commands/" class="tag-link-319" title="2 topics" style="font-size: 10.964705882353pt;">commands</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/cross-browser/" class="tag-link-742329" title="2 topics" style="font-size: 10.964705882353pt;">cross-browser</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/csv/" class="tag-link-602178" title="2 topics" style="font-size: 10.964705882353pt;">CSV</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/duplicates/" class="tag-link-318577" title="2 topics" style="font-size: 10.964705882353pt;">duplicates</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/encoding/" class="tag-link-153304" title="2 topics" style="font-size: 10.964705882353pt;">encoding</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/externalinterface/" class="tag-link-2254413" title="2 topics" style="font-size: 10.964705882353pt;">ExternalInterface</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/flash/" class="tag-link-456" title="2 topics" style="font-size: 10.964705882353pt;">Flash</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/format/" class="tag-link-62572" title="2 topics" style="font-size: 10.964705882353pt;">format</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/format-xml/" class="tag-link-8008148" title="1 topic" style="font-size: 8pt;">format xml</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/gmail/" class="tag-link-1110" title="2 topics" style="font-size: 10.964705882353pt;">Gmail</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/javascript/" class="tag-link-457" title="9 topics" style="font-size: 19.529411764706pt;">javascript</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/jquery/" class="tag-link-203308" title="3 topics" style="font-size: 12.941176470588pt;">jQuery</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/lso/" class="tag-link-1077397" title="2 topics" style="font-size: 10.964705882353pt;">LSO</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/mac-osx/" class="tag-link-4006" title="4 topics" style="font-size: 14.588235294118pt;">Mac OSX</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/microsoft-sql-server/" class="tag-link-23600" title="1 topic" style="font-size: 8pt;">Microsoft SQL Server</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/mysql/" class="tag-link-4419" title="3 topics" style="font-size: 12.941176470588pt;">MySQL</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/php/" class="tag-link-458" title="13 topics" style="font-size: 22pt;">php</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/plugin/" class="tag-link-3965" title="3 topics" style="font-size: 12.941176470588pt;">plugin</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/polldaddy/" class="tag-link-2585251" title="1 topic" style="font-size: 8pt;">polldaddy</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/polls/" class="tag-link-1811" title="1 topic" style="font-size: 8pt;">polls</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/port-forwarding/" class="tag-link-855164" title="1 topic" style="font-size: 8pt;">Port forwarding</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/putty/" class="tag-link-848756" title="1 topic" style="font-size: 8pt;">PuTTY</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/ratings/" class="tag-link-33009" title="1 topic" style="font-size: 8pt;">ratings</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/regex/" class="tag-link-54025" title="5 topics" style="font-size: 15.905882352941pt;">regex</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/regular-expression/" class="tag-link-178521" title="4 topics" style="font-size: 14.588235294118pt;">regular expression</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/screen/" class="tag-link-36435" title="2 topics" style="font-size: 10.964705882353pt;">screen</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/service-broker/" class="tag-link-303408" title="1 topic" style="font-size: 8pt;">Service Broker</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/shortcuts-2/" class="tag-link-36128991" title="2 topics" style="font-size: 10.964705882353pt;">shortcuts</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/ssh/" class="tag-link-49320" title="4 topics" style="font-size: 14.588235294118pt;">SSH</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/svn/" class="tag-link-164684" title="3 topics" style="font-size: 12.941176470588pt;">SVN</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/terminal/" class="tag-link-16478" title="9 topics" style="font-size: 19.529411764706pt;">terminal</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/textwrangler/" class="tag-link-5371323" title="4 topics" style="font-size: 14.588235294118pt;">textwrangler</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/tips/" class="tag-link-1788" title="3 topics" style="font-size: 12.941176470588pt;">tips</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/utf8/" class="tag-link-322023" title="2 topics" style="font-size: 10.964705882353pt;">UTF8</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/validate-email/" class="tag-link-11873558" title="1 topic" style="font-size: 8pt;">validate email</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/validate-url/" class="tag-link-30879525" title="1 topic" style="font-size: 8pt;">validate url</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/wordpress/" class="tag-link-33" title="2 topics" style="font-size: 10.964705882353pt;">wordpress</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/xkcd/" class="tag-link-344213" title="1 topic" style="font-size: 8pt;">xkcd</a> <a href="https://web.archive.org/web/20130127123217/http://magp.ie/tag/xml/" class="tag-link-6852" title="3 topics" style="font-size: 12.941176470588pt;">XML</a></div></aside><aside id="text-4" class="widget widget_text"> <div class="textwidget"><a href="https://web.archive.org/web/20130127123217/http://wikimediafoundation.org/wiki/Support_Wikipedia/en"><img border="0" alt="Support Wikipedia" src="https://web.archive.org/web/20130127123217im_/http://upload.wikimedia.org/wikipedia/commons/4/40/Fundraising_2009-micro-thanks-en.png"/></a> </div> </aside> </div> </div> <footer id="colophon" role="contentinfo"> <div id="site-generator"> Theme: <a href="https://web.archive.org/web/20130127123217/http://theme.wordpress.com/credits/magp.ie/" title="Learn more about how this site is customized with the Custom Design upgrade">Customized Twenty Eleven</a> <span class="sep"> | </span> <a href="https://web.archive.org/web/20130127123217/http://wordpress.com/?ref=footer" rel="generator">Blog at WordPress.com</a>. </div> </footer> </div> <script type="text/javascript"> var _qevents = _qevents || [], wpcomQuantcastData = {"qacct":"p-18-mFEk4J448M","labels":",language.en,type.wpcom"}; function wpcomQuantcastPixel( labels, options ) { var i, defaults = wpcomQuantcastData, data = { event: 'ajax' }; labels = labels || ''; options = options || {}; if ( typeof labels != 'string' ) options = labels; for ( i in defaults ) { data[i] = defaults[i]; } for ( i in options ) { data[i] = options[i]; } if ( data.labels ) { data.labels += ',' + labels; } else { data.labels = labels; } _qevents.push( data ); }; (function() {var elem = document.createElement('script');elem.src = (document.location.protocol == "https:" ? "https://web.archive.org/web/20130127123217/https://secure" : "https://web.archive.org/web/20130127123217/http://edge") + ".quantserve.com/quant.js";elem.async = true;elem.type = "text/javascript";var scpt = document.getElementsByTagName('script')[0];scpt.parentNode.insertBefore(elem, scpt); })(); _qevents.push( wpcomQuantcastData ); </script> <noscript><div style="display: none;"><img src="//web.archive.org/web/20130127123217im_/http://pixel.quantserve.com/pixel/p-18-mFEk4J448M.gif?labels=%2Clanguage.en%2Ctype.wpcom" height="1" width="1" alt=""/></div></noscript> <script type="text/javascript" src="//web.archive.org/web/20130127123217js_/http://0.gravatar.com/js/gprofiles.js?ver=201304ab"></script> <script type="text/javascript"> /* <![CDATA[ */ var WPGroHo = {"my_hash":""}; /* ]]> */ </script> <script type="text/javascript" src="https://web.archive.org/web/20130127123217js_/http://s0.wp.com/wp-content/mu-plugins/gravatar-hovercards/wpgroho.js?m=1351637563g"></script> <script>jQuery(document).ready(function($){ Gravatar.profile_cb = function( h, d ) { WPGroHo.syncProfileData( h, d ); }; Gravatar.my_hash = WPGroHo.my_hash; Gravatar.init( 'body', '#wp-admin-bar-my-account' ); });</script> <div style="display:none"> </div> <div id="bit" class="loggedout-follow-typekit"> <a class="bsub" href="javascript:void(0)"><span id="bsub-text">Follow</span></a> <div id="bitsubscribe"> <h3><label for="loggedout-follow-field">Follow “Magp.ie”</label></h3> <form action="https://web.archive.org/web/20130127123217/https://subscribe.wordpress.com/" method="post" accept-charset="utf-8" id="loggedout-follow"> <p>Get every new post delivered to your Inbox.</p> <p id="loggedout-follow-error" style="display: none;"></p> <p class="bit-follow-count">Join 257 other followers</p> <p><input type="email" name="email" style="width: 95%; padding: 1px 2px" value="Enter your email address" onfocus="this.value=(this.value=="Enter your email address") ? "" : this.value;" onblur="this.value=(this.value=="") ? "Enter email address" : this.value;" id="loggedout-follow-field"/></p> <input type="hidden" name="action" value="subscribe"/> <input type="hidden" name="blog_id" value="11708208"/> <input type="hidden" name="source" value="http://magp.ie/tag/mysql/"/> <input type="hidden" name="sub-type" value="loggedout-follow"/> <input type="hidden" id="_wpnonce" name="_wpnonce" value="5492d30b2a"/><input type="hidden" name="_wp_http_referer" value="/tag/mysql/"/> <p id="bsub-subscribe-button"><input type="submit" value="Sign me up"/></p> </form> <div id="bsub-credit"><a href="https://web.archive.org/web/20130127123217/http://wordpress.com/signup/?ref=lof">Powered by WordPress.com</a></div> </div> </div> <script type="text/javascript" src="https://web.archive.org/web/20130127123217js_/http://s0.wp.com/wp-content/js/devicepx.js?m=1354656609g"></script> <script type="text/javascript"> // <![CDATA[ (function() { try{ if ( window.external &&'msIsSiteMode' in window.external) { if (window.external.msIsSiteMode()) { var jl = document.createElement('script'); jl.type='text/javascript'; jl.async=true; jl.src='/wp-content/plugins/ie-sitemode/custom-jumplist.php'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(jl, s); } } }catch(e){} })(); // ]]> </script><script src="https://web.archive.org/web/20130127123217js_/http://s.stats.wordpress.com/w.js?21" type="text/javascript"></script> <script type="text/javascript"> st_go({'blog':'11708208','v':'wpcom','tz':'0','user_id':'0','subd':'blogalhost'}); ex_go({'crypt':'UE40eW5QN0p8M2Y/RE1TaVhzUzFMbjdWNHpwZGhTayxPSUFCMGNrd29+Smw0c2Z8TEIsUW15UD9dTndwSDlMVitPQXArT1VCQmxoNW0vUEs9eDllS3RScDItYjc2aDE5UStxdi44MT9LTkVDVk5VYU9vc2xkK35SZjB2LHoxMlNYZVI2alEwWSs0LF9XMUVfXVJibiVvMVY1VU9zMXpVcXg4b1hYYW01dmVwWTBkQnpHOC98M1EmQW5pdlkrVy1nakJmW35bVGhRdU4rRXVyPVVGN3d+PUViRTlQdzdHW01pb0YlMUdBWWZdJU5tLT8reT8sLVZxNE9+Yjk1Nm8wTT1kVHVZLVREckxPJk1+Vm1pSC9PJWFmdy5MTzdjb3oudHglZXcwTUJoc1JrWDNjMHxCMi54Qjk4K2Q='}); addLoadEvent(function(){linktracker_init('11708208',0);}); </script> <noscript><img src="https://web.archive.org/web/20130127123217im_/http://stats.wordpress.com/b.gif?v=noscript" style="height:0px;width:0px;overflow:hidden" alt=""/></noscript> </body> </html>