MySQL

Back to cv or Home

Here is a lovely, free, learning experience, if it stays around. Try it for your self
at http://www.analysisandsolutions.com/code/.
A simple, direct, easy approach to learning.
Of course you can go directly to the owner,
MySQL, or MySQL AB

Database have always been important, and there has been a lot of discussion as to what is the best form. Many original digital forms were what could only be called flat files. That is each line of data was of exactly equal length, and represented one record. A real digital square ;-)) Today a record can consist of an array of various, very disparate objects, so the 'flat' file has been largely abandoned, except in some mainframe environments.

Additionally, having a great list of records in a database is not very useful unless you can sort and selectively select records, producing a displayable sub-set. Structured Query Language, try here, SQL, grew up as the way to do this. See Microsoft's SQL Server as a powerful example. And SQL.org for a display of others, like PostgrSQL, Oracle, mSQL in addition to MySQL and MS.

I started coding databases with a great new product, of its time, dBase, by Ashton Tate. The product has evolved, including FoxPro, now owned by Borland, but in some coding way, little has changed. From the above simple code example, after creating the database, the command to connect to it remains the same ...
mysql> use DBNAME;

Of course, today that 'use' can connect to a remote server over Internet, and when a simple query like :-
mysql> select * from table01;
is run, the underlying connection protocols, security handling, etc, make a 'virtual' copy of the remote data collection available locally. Fantastic stuff, but just a simple extension in another way.

... some suggest, some of this will be replaced by XML, but don't hold your breath ... ;-))

Back to cv or Home

References: http://dev.mysql.com/doc/mysql/en/entering-queries.html ... Command line usage ...

Server product, like cPanel, see http://www.cpanel.net/ , include a MySQL icon - - which allow user management of databases ... the phpAdmin page allowed full modification of the databases, tables, and entries, including test running of queries ...