Portal Home > Knowledgebase > Articles Database > Mysql
Mysql
Posted by aakburns, 09-11-2005, 10:02 PM |
Hi, I'm learning all i can right now.
Can someone briefly tell me exactly what Mysql is and what it does?
Thanks for any help
-Arik
|
Posted by andren, 09-12-2005, 12:06 AM |
It's a database. It stores the data you (or an application) hands it. All data is stored in tables, but you can ask it to check all tables. Databses that store only tables are called relational databases. SQL (Structured Query Language) is a language that was developed to talk to applications that store tables. Therefore MySQL. Of couse you can also ask it to hand data back to you - and that 's where its really useful, because it is very fast at finding things you told it to remember.
|
Posted by aakburns, 09-12-2005, 12:39 AM |
So would a forum use mysql? As a way to find posts from different users and things along those lines?
|
Posted by omaha.stylee, 09-12-2005, 02:37 AM |
that would be correct. a forum uses a database hosted on the mysql server.
|
Posted by mripguru, 09-12-2005, 10:44 AM |
www.mysql.com
|
Posted by ByteMaster, 09-12-2005, 02:12 PM |
Think of a database like this. As an example, your address book. That is a database. Each name in it with all of the info associated with the name, is a RECORD. Each name, address, phone and so on are FIELDS and are part of each RECORD. All fo these comprise a DATABASE.
You could think of a book of recipes as a database as well. You get the idea.
MySQL is a brand of database. Microsoft Access, Microsoft SQL Server, Postgre, Oracle, and more, are other 'brands'. MySQL is the most common database used in UNIX based web hosting, mostly because it is free and has an enormous user and development following. It is very stable and user feindly. Especially if the host you choose has a GUI front end to it such as phpMyAdmin.
|
Posted by aakburns, 09-12-2005, 11:37 PM |
Hmm, so if i have mysql enabled on my hosting server, that will allow for anyone to run something such as a php forum that runs using mysql? This thread has really help'd me to understand this.
Thanks everyone
-Arik
|
Posted by andren, 09-12-2005, 11:53 PM |
Not the visitors, only actual users on the server can run a forum. Visitors can read and post if give them permission to do so.
|
Posted by Cool Surfer, 09-14-2005, 10:55 AM |
your members or visitors on ur forum cant actually see the sql
of ur forum. It runs in the background. U can say that the forum
is a graphical interface of the sql it uses.
Never give anyone ur sql name n password. Its risky.
U can install IIS server with php n mysql and learn a lot more
about these simple yet very important questions.
also check out this site
|
Add to Favourites Print this Article
Also Read