{"id":4463,"date":"2013-10-12T05:00:06","date_gmt":"2013-10-11T18:00:06","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=4463"},"modified":"2013-10-12T05:00:06","modified_gmt":"2013-10-11T18:00:06","slug":"linux-join-mysql-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/linux-join-mysql-primer-tutorial\/","title":{"rendered":"Linux join MySql Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"Linux join MySql Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/LinuxJoin_MySql_Primer-88of.jpg\" title=\"Linux join MySql Primer Tutorial\"   \/><\/a><p class=\"wp-caption-text\">Linux join MySql Primer Tutorial<\/p><\/div>\n<p>Today&#8217;s tutorial follows up on <a href='#zpitmappt' title='phpMyAdmin interface to MySql and PHP Primer Tutorial'>phpMyAdmin interface to MySql and PHP Primer Tutorial<\/a> in that we again use the brilliant phpMyAdmin to use MySql calls to create several tables and show that you can build a Linux or Unix based file system method of using some <a target=_blank title='RDBMS' href='http:\/\/en.wikipedia.org\/wiki\/Relational_database_management_system'>RDBMS<\/a> techniques to do with joining tables on a Linux command line to give a similar result to using MySql RDBMS on a database.    Why should that be interesting?   Well, to my mind, you don&#8217;t need to have a database, necessarily, for every data-based job you do, because, let&#8217;s face it, as good as the databases of today are, they use quite a bit of memory.   This is just some food for thought &#8230; am thinking <a target=_blank title='yum' href='https:\/\/www.google.com.au\/search?q=%22favourite+meal%22&#038;client=firefox-a&#038;hs=vXi&#038;rls=org.mozilla:en-US:official&#038;tbm=isch&#038;tbo=u&#038;source=univ&#038;sa=X&#038;ei=t2pCUvTvGsLOiAfZgYGwAQ&#038;ved=0CEsQsAQ&#038;biw=1280&#038;bih=619&#038;dpr=1'>???<\/a>.   Some cases in point at this domain here at www.rjmprogramming.com.au are:<\/p>\n<ul>\n<li><a target=_blank title='Learning Programming' href='http:\/\/www.rjmprogramming.com.au\/Learning\/Programming\/?isMobile=n'>Learning Programming<\/a><\/li>\n<li><a target=_blank title='Nimh' href='http:\/\/www.rjmprogramming.com.au\/Games\/Nimh\/?isMobile=n'>Nimh<\/a><\/li>\n<li><a target=_blank title='Battleships and Cruisers' href='http:\/\/www.rjmprogramming.com.au\/Games\/Battleshipsandcruisers\/?isMobile=n'>Battleships and Cruisers<\/a>&nbsp;<a target=_blank title='Battleships and Cruisers' href='http:\/\/www.rjmprogramming.com.au\/Games\/Battleshipsandcruisers\/?isMobile=n&#038;nowind=y'>(prompts you about initial wind sounds)<\/a><\/li>\n<\/ul>\n<p>So, for today&#8217;s <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/\" title='Click picture'>tutorial<\/a> we make use of the Linux (or Unix) command <a target=_blank title='Linux command join' href='http:\/\/commands.tips-linux.net\/commands\/linux-join'>join<\/a>.   Integration of such ideas into PHP would get you into the world of <a target=_blank title='fopen' href='http:\/\/php.net\/manual\/en\/function.fopen.php'>fopen<\/a> and <a target=_blank title='fclose' href='http:\/\/php.net\/manual\/en\/function.fread.php'>fread<\/a> and <a target=_blank title='fwrite' href='http:\/\/php.net\/manual\/en\/function.fwrite.php'>fwrite<\/a> and <a target=_blank title='fclose' href='http:\/\/php.net\/manual\/en\/function.fclose.php'>fclose<\/a> and <a target=_blank title='exec' href='http:\/\/php.net\/manual\/en\/function.exec.php'>exec<\/a> and <a target=_blank title='system' href='http:\/\/php.net\/manual\/en\/function.system.php'>system<\/a> and more.<\/p>\n<p>Here is some downloadable Linux (Mac Terminal) shell programming source code <a target=_blank title='LinuxJoin_MySql_Primer' href='http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/LinuxJoin_MySql_Primer._GETME'>LinuxJoin_MySql_Primer<\/a> as required.<\/p>\n<p>Here is some downloadable input SQL used to create and populate the MySql tables <a target=_blank title='file1_file2_file3.sql' href='http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/file1_file2_file3.sql_GETME'>file1_file2_file3.sql<\/a>, <a target=_blank title='address_stats.sql' href='http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/address_stats.sql_GETME'>address_stats.sql<\/a>  as required.<\/p>\n<p>Here are some downloadable input data files used at Linux <a target=_blank title='file1' href='http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/file1._GETME'>file1<\/a>,<a target=_blank title='file2' href='http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/file2._GETME'>file2<\/a>, <a target=_blank title='file3' href='http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/file3._GETME'>file3<\/a>, <a target=_blank title='address' href='http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/address._GETME'>address<\/a>, <a target=_blank title='stats' href='http:\/\/www.rjmprogramming.com.au\/Linux\/Tutorial\/join\/stats._GETME'>stats<\/a>  as required.<\/p>\n<hr \/>\n<p id='zpitmappt'>Previous <a href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=492' title='phpMyAdmin interface to MySql and PHP Primer Tutorial'>phpMyAdmin interface to MySql and PHP Primer Tutorial<\/a> is relevant and shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/phpMyAdmin\/iFrame.html\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"phpMyAdmin interface to MySql and PHP Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/phpMyAdmin\/phpMyAdmin.jpg\" title=\"phpMyAdmin interface to MySql and PHP Primer Tutorial\"   \/><\/a><p class=\"wp-caption-text\">phpMyAdmin interface to MySql and PHP Primer Tutorial<\/p><\/div>\n<p><strong><\/p>\n<p>Transcript:<\/p>\n<p><\/strong><\/p>\n<p>You never hear much about the data when you hear about great PHP products, but we<br \/>\n   all know it is the data that differentiates the quality of the end result.<\/p>\n<p>That is probably because database products like MySql, SqlServer, Oracle SQL, Advantage and Access<br \/>\n   are pretty good at what they do, and emphasise reliability rather than flashiness.<\/p>\n<p>MySql and PHP have a great open source interface with phpMyAdmin, which is so good,<br \/>\n  you forget that it is not the default MySql administrator&#8217;s interface product.<\/p>\n<p>Let&#8217;s have a look at this WordPress database and a bit of how it looks, looking<br \/>\n  through the prism of  <a target=_blank title='click picture' href='http:\/\/www.rjmprogramming.com.au\/phpMyAdmin\/iFrame.html'>phpMyAdmin<\/a> &#8230;\n<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d492' onclick='var dv=document.getElementById(\"d492\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?cat=47\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d492' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr \/>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d4463' onclick='var dv=document.getElementById(\"d4463\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?cat=47\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d4463' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Today&#8217;s tutorial follows up on phpMyAdmin interface to MySql and PHP Primer Tutorial in that we again use the brilliant phpMyAdmin to use MySql calls to create several tables and show that you can build a Linux or Unix based &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/linux-join-mysql-primer-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,9,12,29,37],"tags":[300,659,707,827,997,1319,1339],"class_list":["post-4463","post","type-post","status-publish","format-standard","hentry","category-data-integration","category-database","category-elearning","category-operating-system","category-tutorials","tag-database-data-integration","tag-join","tag-linux","tag-mysql","tag-programming","tag-tutorial","tag-unix"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/4463"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=4463"}],"version-history":[{"count":0,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/4463\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=4463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=4463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=4463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}