<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<!------ Include the above in your HEAD tag ---------->
<div id="wrapper2">
<div id="container">
<div id="left-div">
<div id="left-inside">
<div class="post-wrapper">
<h1 class="titles"><a title="Permanent Link to MySQL Video Tutorial" href="http://www.newthinktank.com/2014/08/mysql-video-tutorial/" rel="bookmark">MySQL Video Tutorial</a></h1>
<script src="http://www.newthinktank.com/wp-content/plugins/wordpress-code-snippet/scripts/shBrushXml.js" type="text/javascript"></script>
<p>I cover creating / destroying databases, creating / destroying tables, data types, NULL, DEFAULT, ENUM, AUTO_INCREMENT, primary keys, foreign keys, atomic data, normalized, DESCRIBE, INSERT, ALTER, SELECT, SHOW, RENAME, WHERE, logical operators, comparison operators, ORDER BY, GROUP BY, LIMIT, string operators, joins, LIKE, DISTINCT, math functions and more.<span id="more-9005"></span></p>
<script type="text/javascript"> jQuery(document).ready(function () {jQuery('#commentform').submit(function () {_gaq.push(
['_setAccount','UA-11419683-2'],
['_trackEvent', 'comment', 'submit']); }); });
</script>
</div>
</div>
</div>
<div id="sidebar">
<div class="sidebar-box widget_search" id="search-3">
<span class="headings-sidebar">Search</span>
</div>
<div class="sidebar-box widget_Socialprofilr_output" id="socialprofilr"><span class="headings-sidebar">Social Networks</span>
<div id="sp_div_outer">
<div id="sp_div_list">
<div id="sp_ul">
<table><tbody>
<tr>
<td><a title="Facebook" class="sp_link_16" id="a1a983294f832b0532ff7cf24482d82f7" href="http://www.facebook.com/newthinktank" target="_blank" rel="nofollow me"></a>
</td>
<td style="vertical-align: bottom;">Facebook
<style type="text/css">
#a1a983294f832b0532ff7cf24482d82f7:hover {background-position: 0 -16px;} #a1a983294f832b0532ff7cf24482d82f7 {background: url(http://www.newthinktank.com/wp-content/plugins/social-profilr-display-social-network-profile/images/fb_16.png) no-repeat; padding-top: 1px;}
</style>
</td>
</tr>
<tr>
<td><a title="YouTube" class="sp_link_16" id="ae5305c1dcefac9c104df4a588ec56afc" href="http://www.youtube.com/derekbanas" target="_blank" rel="nofollow me"></a>
</td>
<td style="vertical-align: bottom;">YouTube
<style type="text/css">
#ae5305c1dcefac9c104df4a588ec56afc:hover {background-position: 0 -16px;}
#ae5305c1dcefac9c104df4a588ec56afc {background: url(http://www.newthinktank.com/wp-content/plugins/social-profilr-display-social-network-profile/images/yt_16.png) no-repeat; padding-top: 1px;}
</style>
</td>
</tr>
<tr>
<td><a title="Twitter" class="sp_link_16" id="a6012c089105dbd7d5d7d21e5975927a5" href="http://www.twitter.com/newthinktank" target="_blank" rel="nofollow me"></a>
</td>
<td style="vertical-align: bottom;">Twitter
<style type="text/css">
#a6012c089105dbd7d5d7d21e5975927a5:hover {background-position: 0 -16px;}
#a6012c089105dbd7d5d7d21e5975927a5 {background: url(http://www.newthinktank.com/wp-content/plugins/social-profilr-display-social-network-profile/images/tw_16.png) no-repeat; padding-top: 1px;}
</style>
</td>
</tr>
<tr>
<td><a title="LinkedIn" class="sp_link_16" id="ad35a0c84762cdddcb6be2992d3ded251" href="http://www.linkedin.com/in/derekbanas" target="_blank" rel="nofollow me"></a>
</td>
<td style="vertical-align: bottom;">LinkedIn
<style type="text/css">
#ad35a0c84762cdddcb6be2992d3ded251:hover {background-position: 0 -16px;}
#ad35a0c84762cdddcb6be2992d3ded251 {background: url(http://www.newthinktank.com/wp-content/plugins/social-profilr-display-social-network-profile/images/li_16.png) no-repeat; padding-top: 1px;}
</style>
</td>
</tr></tbody></table>
</div>
</div>
</div>
</div>
<div class="sidebar-box widget_adsensewidget" id="adsensewidget-3"><span class="headings-sidebar"> </span>
<div style="overflow: hidden;">
<script type="text/javascript"><!--
google_ad_client = "ca-pub-4235063622069818";
/* newthinktank ad */
google_ad_slot = "7914637115";
google_ad_width = 300;
google_ad_height = 250;
//-->
</script>
<script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript">
</script>
<div class="clearfix"></div>
</div> <!-- end adsense -->
</div>
<div class="sidebar-box widget_text" id="text-4"><span class="headings-sidebar">Buy me a Cup of Coffee</span>
</div>
<div class="sidebar-box widget_adsensewidget" id="adsensewidget-6"><span class="headings-sidebar"> </span>
<div style="overflow: hidden;">
<script type="text/javascript"><!--
google_ad_client = "ca-pub-4235063622069818";
/* newthinktank ad */
google_ad_slot = "7914637115";
google_ad_width = 300;
google_ad_height = 250;
//-->
</script>
<script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript">
</script>
<div class="clearfix"></div>
</div> <!-- end adsense -->
</div>
<div class="sidebar-box widget_adsensewidget" id="adsensewidget-11"><span class="headings-sidebar">Adsense</span> <!-- end adsense -->
</div>
<div class="sidebar-box widget_adsensewidget" id="adsensewidget-10"><span class="headings-sidebar">Amazon</span>
<div style="overflow: hidden;">
<script language="javascript" src="//c.amazon-adsystem.com/aax2/getads.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
//<![CDATA[
aax_getad_mpb({
"slot_uuid":"44a99997-d6dd-4f2e-a507-4985cf2ddf98"
});
//]]>
</script>
<div class="clearfix"></div>
</div> <!-- end adsense -->
</div>
</div>
</div>
</div>
#container {float: right; width: 950px; color: #84878e; padding-top: 15px;}
#wrapper2 { width: 950px; margin-left: auto; margin-right: auto; padding: 0px 0px 0px 0px; background-color: #FFF;}
body {margin-top: 0px; padding: 0; color: #84878e; background-color: #565656; background-image: url(images/bg.gif); background-repeat: repeat-x; font-family: Trebuchet MS; font-size: 11px;line-height: 18px;}
#left-div {width: 646px;float: left;}
#sidebar {float: left;padding-left: 0px; padding-right: 13px; width: 287px;}
.sidebar-box {padding-top: 5px; margin-bottom: 0px;}
/*media screen*/
body {background-color: #565656; background-image: url(images/bg.gif); background-repeat: repeat-x; font-family: Trebuchet MS; font-size: 11px; line-height: 18px;}
.headings-sidebar {color: #000; border: 1px solid #CDCDCD; font-size: 10px; font-weight: bold; text-transform: lowercase;
display: block; padding-top: 6px; padding-left: 10px; margin-bottom: 10px; width: 96%; height: 23px; background-color: #E9E9E9; background-image: url(images/heading-bg-2.gif);}
.clearfix::after {visibility: hidden; display: block; font-size: 0px; content: " "; clear: both; height: 0px;}
.clearfix::after {visibility: hidden; display: block; font-size: 0px; content: " "; clear: both; height: 0px;}
#sp_div_outer {background-image: url(images/NTTLogo.gif); background-repeat: no-repeat; background-position: top-right;}
a {outline: none;}
.sp_link_16, .sp_link_32 {cursor: pointer; display: block; overflow: hidden;}
.sp_link_16 {width: 16px;
height: 16px;}
a:link, a:visited {text-decoration: none; color: #0084ff;}
#ad35a0c84762cdddcb6be2992d3ded251 {background: url(http://www.newthinktank.com/wp-content/plugins/social-profilr-display-social-network-profile/images/li_16.png) no-repeat; padding-top: 1px;}
#a6012c089105dbd7d5d7d21e5975927a5 {background: url(http://www.newthinktank.com/wp-content/plugins/social-profilr-display-social-network-profile/images/tw_16.png) no-repeat; padding-top: 1px;}
#ae5305c1dcefac9c104df4a588ec56afc {background: url(http://www.newthinktank.com/wp-content/plugins/social-profilr-display-social-network-profile/images/yt_16.png) no-repeat; padding-top: 1px;}
#a1a983294f832b0532ff7cf24482d82f7 {background: url(http://www.newthinktank.com/wp-content/plugins/social-profilr-display-social-network-profile/images/fb_16.png) no-repeat; padding-top: 1px;}
#left-inside {float: left; padding: 0px 0px 0px 19px;}
.post-wrapper {background-color: #FFF; padding: 15px; width: 583px; border: 1px solid #EBEBEB;}
h1 {margin: 0px 0px 10px 0px;
font-weight: normal; font-size: 22px;}
.titles {line-height: 30px; font-size: 24px; margin-top: 0px;}
.titles {font-weight: normal; font-size: 24px; text-decoration: none;}
.titles a:link, .titles a:visited, .titles a:active {text-decoration: none; font-size: 20px; font-weight: bold; font-family: Trebuchet MS; text-transform: uppercase; margin-bottom: 10px; margin-top: 10px; display: block;}
/**
* SyntaxHighlighter
* http://alexgorbatchev.com/
*
* SyntaxHighlighter is donationware. If you are using it, please donate.
* http://alexgorbatchev.com/wiki/SyntaxHighlighter:Donate
*
* @version
* 2.1.364 (October 15 2009)
*
* @copyright
* Copyright (C) 2004-2009 Alex Gorbatchev.
*
* @license
* This file is part of SyntaxHighlighter.
*
* SyntaxHighlighter is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* SyntaxHighlighter is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with SyntaxHighlighter. If not, see <http://www.gnu.org/copyleft/lesser.html>.
*/
SyntaxHighlighter.brushes.Xml = function()
{
function process(match, regexInfo)
{
var constructor = SyntaxHighlighter.Match,
code = match[0],
tag = new XRegExp('(<|<)[\\s\\/\\?]*(?<name>[:\\w-\\.]+)', 'xg').exec(code),
result = []
;
if (match.attributes != null)
{
var attributes,
regex = new XRegExp('(?<name> [\\w:\\-\\.]+)' +
'\\s*=\\s*' +
'(?<value> ".*?"|\'.*?\'|\\w+)',
'xg');
while ((attributes = regex.exec(code)) != null)
{
result.push(new constructor(attributes.name, match.index + attributes.index, 'color1'));
result.push(new constructor(attributes.value, match.index + attributes.index + attributes[0].indexOf(attributes.value), 'string'));
}
}
if (tag != null)
result.push(
new constructor(tag.name, match.index + tag[0].indexOf(tag.name), 'keyword')
);
return result;
}
this.regexList = [
{ regex: new XRegExp('(\\<|<)\\!\\[[\\w\\s]*?\\[(.|\\s)*?\\]\\](\\>|>)', 'gm'), css: 'color2' }, // <![ ... [ ... ]]>
{ regex: SyntaxHighlighter.regexLib.xmlComments, css: 'comments' }, // <!-- ... -->
{ regex: new XRegExp('(<|<)[\\s\\/\\?]*(\\w+)(?<attributes>.*?)[\\s\\/\\?]*(>|>)', 'sg'), func: process }
];
};
SyntaxHighlighter.brushes.Xml.prototype = new SyntaxHighlighter.Highlighter();
SyntaxHighlighter.brushes.Xml.aliases = ['xml', 'xhtml', 'xslt', 'html'];
