PDA

Click to See Complete Forum and Search --> : What is SQL Database and how do I use it?

dell funk
10-07-2003, 09:32 AM
I know this is a dumb question, but I am paying for SQL Database and I know its useful. I am not sure how to use it, and what is the best purpose for it. What is so special about it. I am using a database to hold my email addresses my microsoft software. What is the advantage of keeping it on the SQL database,....or am I way off course??
Compguy Pete
10-07-2003, 11:32 AM
I would have to refer you to 2 sites below...

http://www.sqlcourse.com/
http://www.php.net/

Of all things start at this article...
http://sqlcourse.com/intro.html
SA Heat
10-08-2003, 09:59 PM
I was wondering how much does it cost? I was looking into getting it and I heard it was free at my sql.com. Can I run a Fantasy Fotball site with it? I would liek a program that I put in stats for a certain name and it puts it in all the cells with the same name. Any help in what i should be using?
PeOfEo
10-08-2003, 10:04 PM
You could have been paying for mssql and not mysql mssql is sql server, it runs off of windows and works with asp and asp.net, it will in most cases add a few bucks to your hosting plan.
Compguy Pete
10-08-2003, 10:07 PM
accually it is possible to buy MySQL on the same site you get the free version.

It depends on if you can read or not.
SA Heat
10-08-2003, 10:09 PM
Mysql is free right and can I use it as a data base? What I want to do is I run two leagues, and they are full of players with stats. I want something to where I can put in stats for say John Doe and it puts in the same stats for all named John Doe, would this be the program to do that with?
SA Heat
10-08-2003, 10:11 PM
Yeah I saw that catch about it being free and then at another link ya had to pay for it, quite trickory.
AdamBrill
10-08-2003, 10:35 PM
SA Heat, MySQL would work great for that...
PeOfEo
10-08-2003, 10:52 PM
It depends on the technolgy people. Depending on what you use you will be using mysql mssql or maybe oracle depeinding on how much cash u have
SA Heat
10-08-2003, 11:03 PM
AdamBrill, Is it a hard program to figure out? Will I have to learn some kind of language like java has its own lauguage?
pyro
10-08-2003, 11:06 PM
Using MySQL is quite easy (when used with PHP). It's just basically figuring out the SQL statement to query the database. The documentation/search at http://www.mysql.com/ will help you, once you get to the point.
SA Heat
10-08-2003, 11:10 PM
Thanks Pyro, I am downloading it now, I think, that whole entire web site can be confusing. I am hoping the program is no bigger than 10.7 megs because thats what i am downloading. I am going to work with it and try to figure it out, it would be so much easier on me if I can put in some stats for a name and it places the same stats for the matching name throught the site. Thanks
pyro
10-08-2003, 11:14 PM
You will probably also want to install phpMyAdmin (http://www.phpmyadmin.net), as that will make it much easier to set up/use the databases...
SA Heat
10-08-2003, 11:17 PM
Should I get 2.5.3 or 2.5.4?
pyro
10-08-2003, 11:28 PM
2.5.3 -- Unless you want to help the developers of any software test it out, always go for the latest stable version.
SA Heat
10-08-2003, 11:42 PM
one more question, I downloaded the PHP thing as well but the actual sql is taking longer to download. I went to unzip it and my pc won't read the install file because it doesnt reconize the program so what I am thinking is my sql has to be installed first ,right? After the sql is installed it should read the install file of the php, correct?
pyro
10-08-2003, 11:47 PM
One thing I assumed from the get-go that I perhaps shouldn't have is that you have a server installed on your computer? If you don't, none of what you downloaded will work (unless you are able to upload it to a server...)
SA Heat
10-08-2003, 11:59 PM
A server, as in web server? My web shell supports cgi-and php.
pyro
10-09-2003, 12:06 AM
Yes, but do you have access to be adding things to the server (such as MySQL)?
SA Heat
10-09-2003, 12:14 AM
I can upload things to my server. So I guess yes. I use a lot of forms on my site and they always work well. I did a test a while back to see if I had server side something by uploading a file and it read the time and date and it said I have something good. I hope thats what you are talking about.
pyro
10-09-2003, 07:55 AM
Uh, no. By the sounds of that, you won't be able to get MySQL installed. Try talking to your server administrator and see if he'll get it running for you.
diamonds
10-10-2003, 09:23 AM
Cant you install MySQL on your or an extra computer, than connect to it?
<?php
mysql_connect('123.456.7.89','username','password');
?>
pyro
10-10-2003, 09:33 AM
Yes, you can connect to an external MySQL database, but getting that all set up would probably be more of a pain than just switching hosts...
PeOfEo
10-10-2003, 08:49 PM
connecting to a remote data base is difficult I mean you cant do it your self with the server, what needs to happen is there needs to be a socket connected between the two machines and the ports have to be set as dedicated ones for the data base, yea it would be easier just to get on a server with mysql on it.