MySql CSV Import Primer Tutorial

MySql CSV Import Primer Tutorial

MySql CSV Import Primer Tutorial

MySql is a brilliant database especially when it teams up with its partner in Web integration … PHP. It also is very friendly with CSV (comma separated values) files, and, like a lot of other database engines integrates CSV import integration ideas into its functionality especially if you incorporate it with phpMyAdmin. Read about MySql from Wikipedia below:

MySQL (/maɪ ˌɛskjuːˈɛl/ “My S-Q-L”,[3] officially, but also called /maɪ ˈsiːkwəl/ “My Sequel”) is (as of 2008) the world’s most widely used[4][5] open source relational database management system (RDBMS)[6] that runs as a server providing multi-user access to a number of databases. It is named after co-founder Michael Widenius’ daughter, My.[7] The SQL phrase stands for Structured Query Language.[3]

The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.[8]

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other ‘AMP’ stacks). LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python.” Free-software-open source projects that require a full-featured database management system often use MySQL.

For commercial use, several paid editions are available, and offer additional functionality. Applications which use MySQL databases include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in many high-profile, large-scale websites, including Wikipedia,[9] Google[10][11] (though not for searches), Facebook,[12][13][14] Twitter,[15] Flickr,[16] and YouTube.[17]

You can do a course in MySql, and you can pick things up. MySql and the beautiful incredible phpMyAdmin make this infinitely possible for PHP/MySql web environments.

Take a look at how easy it is to import CSV into MySql … am just using localhost:8889 as a MySql MAMP phpMyAdmin environment, and the tutorial starts showing you this environment.

The CSV data used is from GeoLite Free Downloadable Databases for whom I give thanks, because, as we all know, interesting data is INTERESTING!!

This tutorial shows you just how good PHP/MySql/phpMyAdmin are, and how breaking things down into common denominators (which is what I class SQL as) is good. By “common denominators” guess what I am saying is “protocols”. In this use of “protocols” in this sense, would include this list (but there are many more):

  • SQL
  • HTML
  • XML
  • JSON
  • SOAP
  • WSDL
  • CSV files
  • PDF files

Think we need to talk more about “protocols” in weeks to come?!

Click on picture above for the tutorial, on the picture, as usual. Hope you know that clicking on the @ causes the tutorial to be like a movie?! Otherwise use the horizontal scrollbar to move from left to right through the presentation.

Have a great day thinking about data … and those poor neglected but hardworking databases and database engines … or at the beach (but when you’re there think about where each atom of each molecule of each sand grain came from … back to data thoughts?!).

This product includes GeoLite data created by MaxMind, available from
//www.maxmind.com.

If this was interesting you may be interested in this too.

This entry was posted in Data Integration, Database, eLearning, Tutorials and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>