My SQL

Phate

Phate

Phate

Caporegime
Joined
1 Nov 2003
Posts
35,691
Location
Lisbon, Portugal
Hey people,

would someone mind giving me a breif description of what MySQL is, and what it's used for? always wondered.

Thanks :)
 
robc123 said:
Its a database
Click to expand...

yup what he said

MySQL is the language that creates and enters (as well as retrieving) information from a database.

it is used primarily on websites and normally in conjunction with PHP.

it is used on both linux and windows hosting (not forgetting glorious OSX) and is used in preference to ASP because its open source (i think - if its not its still cheaper than ASP)

helped?
 
MySQL is not only a database but an open source database licenced under the GPL (General Public Licence). This is why it has become so popular. Not only do you have access to the source code to modify it if you wish (and have the skills of course) but it means that you can use it for free and for whatever reason you want (although some restrictions are in place with regards commercial use and the GPL).
 
Actually Mysql is not a database it is a Database Management System. That allows you to create and edit multiple dbs and supports parts of the SQL language although not all features.

It allows backups to be made and database secruity to be maintained, the next step up from MS Access and the same level as MS SQL
 
Its basically used to store information in tables for internet applications such as Blogs, Chat scripts and Bulletin board just like this one and offers far better performance and functionarity over a flat file or text database system. Its more than likely that the posts that have been written here are all stored in a MySQL Database, or a PostgreSQL database which is simular.
 
chesterstu said:
Actually Mysql is not a database it is a Database Management System. That allows you to create and edit multiple dbs and supports parts of the SQL language although not all features.

It allows backups to be made and database secruity to be maintained, the next step up from MS Access and the same level as MS SQL
Click to expand...
I stand corrected :)
 
chesterstu said:
Actually Mysql is not a database it is a Database Management System. That allows you to create and edit multiple dbs and supports parts of the SQL language although not all features.

It allows backups to be made and database secruity to be maintained, the next step up from MS Access and the same level as MS SQL
Click to expand...

Bit petty, MySQL are a company who develop lots of different products which are database orientated. Doesnt mean they are all part of the same Management System. MySQL is a database form. The tools around it make up the Management System surely so you are not spot on.
 
Such a petty point, that it's worth debating?

Also, it's a Relational Database [Management System] which is quite a significant difference from an 'oldschool' database. :)
 
robc123 said:
Bit petty, MySQL are a company who develop lots of different products which are database orientated. Doesnt mean they are all part of the same Management System. MySQL is a database form. The tools around it make up the Management System surely so you are not spot on.
Click to expand...


If am not mistaken isn't the company actually called mysqlab
edit: Thought it was
About the company
 
Last edited:
http://www.mysql.com/company/ for information about MySQL the company

http://en.wikipedia.org/wiki/RDBMS for information about relational databases in general terms

http://en.wikipedia.org/wiki/Object_database for information about alternatives to a relational database

http://en.wikipedia.org/wiki/MySQL for information about the RDBMS developed and owned by MySQL AB

alternative RDBMS would be from Oracle 10g, Microsoft SQL Server, Postgress, Sybase and I guess at a push you could call Access a database (but that is puching it a bit)

is there any other homework that people would like us to do?

HT
 
You must log in or register to reply here.
Back
Top Bottom