Back to cv or Home
Here is a lovely, free, learning experience, if it stays
around. Try it for your self
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 ...