What is MySQL ? Can Anyone Explain Could someone explain this to me?

[enterthematrix 0]

Hey. I have a few questions about mySQL. I'm just starting out on using it and am curious to know: 1) What exactly is it? 2) Where is it stored? 3) Does my computer have to be on all the time for other people to use my site? 4) Where can I get one? 5) How can I access it? 6) What does mySQL stand for? 7) Is there anything else I should know about using it?Any help with this would be appriciated. Thanks!

[arunkumarhg 0]

Hey.  I have a few questions about mySQL.  I'm just starting out on using it and am curious to know:

  1) What exactly is it?

  2) Where is it stored?

  3) Does my computer have to be on all the time for other people to use my site?

  4) Where can I get one?

  5) How can I access it?

  6) What does mySQL stand for?

  7) Is there anything else I should know about using it?

Any help with this would be appriciated.  Thanks!

<{POST_SNAPBACK}>

Hi dear,

 

Q 1) What exactly is it?

A:MySql is an Open Source RDBMS (Relational Database Management System), comes for free (for No Cost).

 

Q 2) Where is it stored?

A :IT stores the databases and tables in to the folder Called "data" under MySql Folder, Suppose if you indtalled MySql in Folder "\dbms\mysql", Data is going to be stored in "\dbms\mysql\data\" folder. (Can you be More Clear on this Question)

 

Q 3) Does my computer have to be on all the time for other people to use my site?

A: Yes MySql Server Should Be running to access it.

(Why your are Going for Making you system as MySql Database Server, on Xisto you can get it )

 

Q 4) Where can I get one?

A :Visit http://dev.mysql.com/ or http://www.mysql.com/

 

Q 5) How can I access it?

A : All It Depends, if you want to access from you programm or directly from console.

 

i)If you are going to access with you programm then either you can have a ODBC Connection or use the library available for you programming language.

ii) If you want access from console, first you need to start MySql server, and conect to it (mysql -h yourhost -u username -p password)

 

Q 6) What does mySQL stand for?

A: My Structured Query Language

 

Q 7) Is there anything else I should know about using it?

A : a lot of things you need to know, Procedures, Cursors, PL/SQL, Innodb Concept,Syntax and many more. Visit mysql.com, or am on my way to start my own web site for it, just wait and see.

 

any thing else feel free to contact me on my mail "arunkumar.hg@gmail.com"

 

cheers

 

Arunkumar.H.G

[thedevil 0]

to arunkumarhg...is it possible to create a stored procedure in mysql... if it is possible how can i create one ????i need to know about cursors... what exactly it is... it is the same concept i find in MS FOXPRO cursors...(where cursors are the temporary tables to store data) or it is anything else...??

[arunkumarhg 0]

to arunkumarhg...

is it possible to create a stored procedure in mysql... if it is possible how can i create one ????

i need to know about cursors... what exactly it is... it is the same concept i find in MS FOXPRO cursors...(where cursors are the temporary tables to store data) or it is anything else...??

<{POST_SNAPBACK}>

Hi,

Yes MySql 5.0 onwards support Stored Procedures, and about cursors are those which acsts as Temporary ResultSets to hold Fetched Data,

 

But MySql 4.x and other version lesser than 5.0 won't support Stored Procedures.

 

Heres the simple Example of StoredProcedure

 

CREATE PROCEDURE `meta_controller`(OUT te Bigint(20))
Begin select rowid from TEMP_META_DATA into te; set te=te+1;
update TEMP_META_DATA set rowid=te;
End;

 

For more Information visit http://www.mysql.com/

 

(http://forums.xisto.com/no_longer_exists/ is on its way to track all these things)

 

Cheers

 

Arunkumar.H.G

[hajime 0]

Im just starting on MySQL too, may I ask what is a stored procedure??

[coder2000 0]

A stored procedure in SQL is a statement that is stored on the server. You can call it at any time using the name you gave it.

[enterthematrix 0]

I'm starting to get MySQL. But what about MySQL clusters? How do I set them up? (Read my other post for more info)

[kraizii88z 0]

I wanted to know all that stuff , too, about MySQL and what it's used for...It's daunting if you're clueless...like me, but i don't think i will use it because i have only a small site that's not getting hit up constantly

[Waiting 0]

well most hosting services have a mySQL 'database' in the cpanel of your site. Im not sure if you need a database or just mysql but if you need to create a database it should be in your cpanel

[Analyst 0]

One thing most people are not aware of is that you can get a windows DLL that will allow MS Access on a Windows System to connect to MYSQL on a Linux machine over the internet.

[vhortex 1]

I am using Mysql 4.x and I want to upgrade to mysql5...

anyways Thanks...

<{POST_SNAPBACK}>

On what kind of site are you going to use your mySQL server. I do have one on my own PC for testing with my ERP program made of pure JAVA..

 

As of now, I can only recommend the 4.x version since mySQL version 5 is still buggy and not good if you are going to expose the server to the public..

 

example:.. broacasting it to the net as backend for datab driven websites.

 

there are also some issues regarding the installer modules both in linux and windows and the safest way I can recommend is to install it manually.

 

Last time I check the site, they are testing the integrity of the new version..

[emersonbrum 0]

does mysql support cluster/grid ?could you give me an example of procedure and trigger ?I'm using phpmyadmin to administrate does it have another one ?thank you

[racunichu 0]

Is there any way to download a mysql in a server that does not have mysql?sorry im a noob

[vhortex 1]

does mysql support cluster/grid ?

could you give me an example of procedure and trigger ?

I'm using phpmyadmin to administrate does it have another one ?

 

thank you

<{POST_SNAPBACK}>

i dont know if it supports cluster/grid but you can check its website..

 

i think the website is mysql.com

 

about the admin software, even mysql have its default software called myadmin but for advance functions, try SQLyog at webyog.com

 

there are tons of admin software for mysql server but I mostly recommend sqlyog since it is the only program that made me leave my old handy dandy phpmyadmin.