what is MySQL?

Wind90Mph

Feb 12 2005, 12:28 AM

What is MySQL? and how do I use it? and what is it used for? :?:

ShadowSpectrum

Feb 12 2005, 01:30 AM

MySQL is a database language used to create databases for forums and the such. Many hosting services offer 1 or more MySQL databases.

Wind90Mph

Feb 12 2005, 02:25 AM

ah ok, so kind of like HTML?

that answers the first question, what about the eother 2?

and how do I use it? and what is it used for?

DarthBob

Feb 12 2005, 03:43 AM

QUOTE

ah ok, so kind of like HTML?

that answers the first question, what about the eother 2?

and how do I use it? and what is it used for?

You don't use HTML you use either PHP or Perl.

You use it via SQL (SQL = Structured Query Language) querys with PHP or PERL. It can be used to store information to be used to present something. The best example is of this phpBB, which stores all the posts and users on an MySQL database.

A example of the syntax for using it within PHP would be:

CODE

$connection = @mysql_connect("localhost", "database user", "database password") or die(mysql_error());

$db = @mysql_select_db($db_name, $connection) or die(mysql_error());

$sql = "SQL query here";

$result = @mysql_query($connection, $sql) or die(mysql_error);

Wind90Mph

Feb 12 2005, 05:14 AM

QUOTE

ah ok, so kind of like HTML?

that answers the first question, what about the eother 2?

and how do I use it? and what is it used for?

CODE

ah..ok, that's understandable. I think I got it now. Thanks 8)

SSR

Feb 12 2005, 05:35 AM

ok i dont exactly know what myql is or does. bt your making it seem like this is the first time you;ve heard of it. but how does the admin Amoderator people that dont know how to even use the cpanel dont yous suppose to know some technical stuff?

Wind90Mph

Feb 12 2005, 03:36 PM

well, I sortof knew what it was, but I don't think that EVERYONE knows EVERYTHING about the cPanel. So the best way to know is to ask.

Recent Queries:-

what is mysql_connect() - 420.37 hr back. (2)
what is mysql databases and how do i use it - 443.87 hr back. (1)
what is mysql error - 457.26 hr back. (1)
what is my sql databases - 475.72 hr back. (1)
phpbb too many connections - 508.72 hr back. (1)
what is mysql used for - 489.36 hr back. (2)
what is it @mysql_select_db - 956.22 hr back. (1)

Similar Topics

Keywords : Mysql

what is the 'test' mysql table for? - (3)
just wondering... ^ thanks...

Update Suggestions - PHP and MySQL is outdated (2)

Too Many Connections With Mysql... - (3)

Just in the morning.... CODE *** FATAL *** Cannot connect to localhost --- MySQL said: Too
many connections Trouble has been reported to system administrator. Please try again later. Thank
you. Oh...Trap17.So many men~oh.wish a more better server. /laugh.gif' border='0'
style='vertical-align:middle' alt='laugh.gif' /> ...

MySQL Datatbase Problem - (2)

I have seen alot of questions on the forums about how to back-up your mysql databases since the free
hosting is going down. Even though some of you have been able to access cpanel (i still can on my
old free hosting, stoneddevilinc.vaio-hosting.com) and are thinking the databases have been deleted,
they have not. If you have read around about whats been going on, you would know that the Apache
server program on the vaio-hosting server is down right now. Admin has been trying to fix it with no
luck. MySQL and many other things, like your actual site, are not working si...

Why my MySql data base has ben deleted? - (65)

Why my MySql data base has ben deleted? seit: http://wiejski.vaio-hosting.com/index.php ...

Mysql Backup - (8)

Now that we know that free hosting will be gone, is there anyway that we can backup out Mysql
databases? Thanks...

Connect to MySQL failed? - (2)

Connect to MySQL (localhost,zero8_zero8) failed my site URL is http://zero8.vaio-hosting.com
why?...

Can I use mySQL of an other site ?? - (1)

I want to have 2 DB (1 for backup, it's in an other site) while i modify DB on my site, it's also
modify in backup site ! Please help me as soon as possible....

Do the paid service customers here have the mysql problem? - (3)

I am curious because I may want to go for the pay service instead of the free. Help me decide here
on this issue. Do the paid service customers here have the mysql problem?...

Lost my mySQL databases - (1)

All of a sudden, today when I opened my site, I found I had lost both my mySQL databases
/ohmy.gif' border='0' style='vertical-align:middle' alt='ohmy.gif' /> How did that happen??...

HELP! MySQL Data base compleatly erased!!! - (2)

i went to my site to post a message saying I would be gone for about a week and the site was down,
so I check on my MySQL data bases only it shows I have 0 Data bases :cry: :cry: :cry: :cry: :cry:
:cry: Ironicaly enough I forgot for the first time EVER to back it up :cry: :cry: :cry: :cry:
:cry: :cry: Luckly I've also had this problem on another host (though I had a back up) all that
needed to happen whas the sql servers needed to be restarted is there any way possible to get them
restarted? I tried also making a new DB but it wont work thats why I think they need t...

Problem with MYSQL server - (3)

I have had this happen many times and i wanted to know a possible solution. Here is the error
message: There seems to be a problem with the MySQL server, sorry for the inconvenience. We
should be back shortly. the site URL is http://www.gtanation.vaio-hosting.com/ Thanks FNH
for all of your help in the past though. (And that was serious, not sarcastically) Cody...

Problem with the MySQL server - (1)

Hi, is this normal? im getting this message in my website, what's wrong? :? "There seems to be
a problem with the MySQL server, sorry for the inconvenience. We should be back shortly." My
website is http://www.ameba86.vaio-hosting.com Help Please!...

MySQL down? - (1)

Is MySQL down? Or is it overloaded? I can't view it in cpanel either. Warning: mysql_connect():
Too many connections ... I cannot connect to the database because: Too many connections...

mysql infos - (2)

hello... what are the infos for the mysql databases ? Like the host, is it localhost ? and the
username ? And what does setting up users for the databases in cpanel does ? thanks in advance...

Setting Up Your MySQL & phpMyAdmin For The First Time - (3)

I have a very easy tutorial I have created, with screenshots too... Setting Up Your MySQL &
phpMyAdmin For The First Time I have posted it as a link because there are so many images, and
it saves on FNH bandwidth (See how considerate I am LOL).....
http://matrixdesigns.info/modules.php?name...wtutorial&pid=1 ...

MySql Tool - (0)

What are the best Open Source MySql developer tools?...

IPB Forum help on MySQL db - (2)

Im tryin to install an IPB forum in my cpanel and in mysql.php it has this, what should i put in the
""s? var $obj = array ( "sql_database" => "" ,
"sql_user" => "root" , "sql_pass" => "" ,
"sql_host" => "localhost", "sql_port" => ""
, "persistent" => "0" , "sql_tbl_prefix"
=> "ibf_" , "cached_queries" => array(), ...

MYSQL Login Script - (1)

I have a script just to connect to a database but it leaves the connection open. But what i want to
do is test to see if the server included it or if someone is visiting it. If someone is visiting
it, it might mean there using my script to use my database. So how do i test to see if the server
has included the script or if someone is visiting it?...

php and mySQL - (2)

Could someone give me an example of a php tutorial site? And could someone give me an example of
mySQL tut site?...

parse mysql table into array - (5)

i made a mysql db class and now i want to make a function that parses the table into an array, i
dont have that much php experience so can anyone help me? CODE if(!class_exists('cDB'))
{ class cDB { var $lDB; function cDB($name) { $this->lDB =
mysql_connect(); mysql_select_db($name, $this->lDB); } function table($name) {
//parse table array here } function __destruct() {
mysql_close($this->lDB); } } } ?> ...

MySQL Error 1046 - (0)

Anyone know how to get rid of this f***ing thing? I've got all my config set right, it can connect
to the database, but when I try to select the damn database it gives me this: QUOTE MySQL
Error: 1046 No Database Selected Here's the code for my database class, which I use to process
all my database activity. I've got it writing to a log, which says that it connects to the database
correctly, but won't select the database. CODE require_once("config.php"); class
database { var $handle; var $db; var $result; var $config; f...

Recomendation book about MySQL? - (1)

Is there anybody here that can recomend a good book about MySQL... please... not so advanced! A good
introduction to MySQL. Regards, davidw :roll:...

mySQL and MS Access - (3)

Can MS Access interface with mySQL? Does anyone know how to set it up? Is it even a good idea to?...

Importing mySQL database into Nuke - (1)

Hi there. Is therea way to import an already made database of my forum? I need to host my
forum, as I was hosting it from my pc, bu I wouldn't like to loose any entry in the database.
Thanks...

php tutorial - basics...up to mysql/file commands - (6)

the best way to start php is probably not adjusting a script IMO - that misses out a stage. - the
very first stage /biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' /> -
here... Why use php? because it allows things to be generated very quickly - without lots of html
pages. It enables users you choose to allow, to input their own content to the pages you want them
to. 1) save these files as anyfilename.php - pick your names, upload them to a php enabled server
and go to the url they are at... 2) understand , .php, //////, /* */, and ;...

PHP & MySql installed??? - (6)

hi, umm i was just wondering if PHP and MySql come installed on the server. If not, are they
supported on a free account? if so will i have to install it on my own? Thanks in advance for
help....

MySQL database setup in the host - (6)

I just got my free host website ready in freenukehosting. Is there anyway to create MySQL database
in the free hosting for my php photo album and forum, as its states there is MySQL database support
in the Free hosting service? Plz advise. Thx! :wink:...

mysql_error - (2)

when i add user to db in cpanel it say $dbh=mysql_connect ("localhost", "ruoning_xxx", "
") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db
("ruoning_yyy"); plz help me ! thanks...

GD? & Mysql - (8)

Hi, i'm new to cPanel and this hosting and i dont know what is the info. for the mysql, i created
new database but what is the info of it? (pass, host, user, etc.) And i tried to install a PHP
script but i need GD to install it, what should i do? the scrips says that there is no GD support in
this host... Please help, Leon....

Looking for mysql