enterthematrix
Dec 13 2004, 01:35 AM
| | 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! |
Reply
arunkumarhg
Dec 13 2004, 04:20 AM
QUOTE(enterthematrix @ Dec 13 2004, 02:35 AM) 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! 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 Astahost you can get it ) Q 4) Where can I get one? A :Visit http://www.mysql.org or http://www.mysql.comQ 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
Reply
thedevil
Dec 16 2004, 03:31 AM
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...??
Reply
arunkumarhg
Dec 16 2004, 04:08 AM
QUOTE(thedevil @ Dec 16 2004, 04:31 AM) 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...?? 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 SQL 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://www.arunzone.com is on its way to track all these things) Cheers Arunkumar.H.G
Reply
hajime
Dec 30 2004, 04:38 PM
Im just starting on MySQL too, may I ask what is a stored procedure??
Reply
coder2000
Dec 30 2004, 10:52 PM
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.
Reply
enterthematrix
Jan 10 2005, 10:47 PM
I'm starting to get MySQL. But what about MySQL clusters? How do I set them up? (Read my other post for more info)
Reply
kraizii88z
Feb 3 2005, 08:26 AM
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
Reply
Waiting
Feb 14 2005, 09:43 PM
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
Reply
Analyst
Apr 19 2005, 08:38 AM
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.
Reply
vhortex
May 4 2005, 02:08 AM
QUOTE(emersonbrum @ Apr 26 2005, 07:26 AM) 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 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.
Reply
racunichu
Apr 30 2005, 04:57 AM
Is there any way to download a mysql in a server that does not have mysql? sorry im a noob
Reply
emersonbrum
Apr 25 2005, 11:26 PM
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
Reply
Recent Queries:--
transfer data from temporary table in php rows - 220.89 hr back. (1)
-
what does mysql stands for - 304.71 hr back. (1)
Similar Topics
Keywords : mysql, explain
- Small Issues About Mysql Connector/j 5.1
(2)
Login System
I want to make a login system using Mysql. I am amateur in these thing (6) I want to make a login system using Mysql. I am amateur in these things so please explain in detail
like spoon feeding. I have already made a database in http://www.sitebooth.com now what type of
table I should make and and the website or PHP for it . If you think i hav chosen wrong site please
give any better database hosting site. Please help me Best Regards Pritesh Gupta....
Which Language Is Easy And Secure Today For Web Development
is PHP MYSQL is easy and Secure ? (2) Web development Application now a day using PHP MySQL Mostly as i observed on discussion topics on
Forums friends switch to PHP MYSqL, Did PHP MYSQL is Easy and Secure for todays environment what
you are say about this Hacking tracking stolen password are very much popular now a days his website
hacked by X person so many time comes to news please emphasis on security issue when you go to
develop any web tools . what is the right way to tight security on PHP what thing i kept in mind
which logic i use that any one can not hack webtools. when i was use java/j2ee languag....
Mysql Overhead
(3) Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
press of a button but i'd like to know what happens when i optimize a table. Also when you make
a new table you can limit the size of VARCHAR to a number, that number would be the number
characters allowed in that column per entry. I'd like to know how the limit works for texts, is
it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....
What You Need Before You Can Create A Text-based Game..
Using PHP, HTML and MySQL (7) Please comment and rate, after you finished reading! /smile.gif" style="vertical-align:middle"
emoid=":)" border="0" alt="smile.gif" />
################################################################# Change log: Aug 22 2008: The
Tutorial Was Created. V1.0.0 Aug 30 2008: Added XHTML and a small CSS part. Also corrected some
small things and added this change log. V2.0.0
################################################################# OK.. Many people here want to
create text based games. Many of you ask us here on the forums: "how to create a text-based game....
Mysql Multiple Tables
(1) It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
structure that they have added. You can select multiple tables within one sql query. Example of a
basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
all of the rows in the table. Normally you will try to not select the entire table from the database
unless you absolutely want all of the table. I would recommend against it; just gra....
Any Website Provide Free Host Mysql Host?
(4) any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....
How To: Display A Members/user List.
With PHP, Mysql, and HTML. (3) Alright, some of you might want to display your User's or Members on your site. Notes: 1.This
is to fit in with Feelay's register and Log-in scripts you can find in the tutorial section. 2.I
made this to show the members of my site who is a member and what their ID is. First off, we must
set up a connection to our MySQL Database. CODE $con =
mysql_connect("localhost","database_username","database_username_password"); if (!$con) {
die('Could not connect: ' . mysql_error()); } What it does: 1.It is starting a PHP
document. 2.Next it sets....
Mysql On Computer
XD (9) I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
want and upload it when i get hosted =)....
Can You Link Game Maker With Mysql/php
Title says it :D (0) Hello, I am new to this service and i think I am going to like it =). Anyway, my main question is
can you link executable games made by gamemaker (i have pro) to a database? And can i use the php
server i get here to transfer data to that game? If so i would appreciate a little help with it
because I am new to both =). Also is there anyway to get a www.mywebsite.com via credits from
astahost? Finally is there any group here that works with gamemaker? we might have small contests
or so /tongue.gif" style="vertical-align:middle" emoid=":P" border="0" alt="tongue.gif" /....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ....
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
Mysql With My Own Server
few questions (4) Hi, I've only just joined the forum Can you link the mysql database here to your own website?
If so how would I go about it Thanks =D....
Login System Using A Mysql Db
How do i do this? (5) Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect: ' .
mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person (username, password) VALUES
('$_POST ','$_POST ')";if (!mysql_query($sql,$con)) { die('Error: ' .
mysql_error()); } echo "1 record added";mysql_close($con) ?> Now my question is, how do i creat....
Php Tutorial: Making A Shoutbox
Requirements: PHP, MySQL (12) Hi everyone, I'm going to tell you how to make a simple shoutbox using PHP and MySQL. To start
off, open up mysql in the command line, or phpmyadmin, and create a database called shoutbox. Next,
enter the following sql into the command line, or the phpmyadmin sql box, while using the shoutbox
database: CODE create table messages(author varchar(30), message text, time timestamp, mid int
auto_increment, primary key(mid)); This creates the table we need to store the messages, note the
"mid" column, this gives each message a seperate id number, we'll see why ....
Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking )
A small tutorial to explain integrating php, ajax and MySQL Database (11) Hi all.. I'm back with a new small tutorial! Introducation A tutorial to integrate
Ajax, Php And Database ( Im using MySQL) + Visitor Tracking! Here you can enter values to some
input fields, and by clicking some enter button, ( or u can call the function on some other event)
those values will be sent to the database, along with visitor details ( IP Address, Input Value,
Visitor Agent etc)! Those values will be stored in some database and you can retrieve the same using
some simple php code and even deleted some rows from those databases! Requiremen....
Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom)
150 MB space, 10000 MB Bandwidth, php, mysql, CPanel (10) Hello Members, We are proud to introduce a new member to Xisto group of sites.
Qupis : Free Web Hosting 150 MB space, 5000 MB Bandwidth, php,
mysql, CPanel (Latest). Emails, FTP, Addon domains, Parked Domains etc.
http://www.Qupis.com
Feel free to add your reviews and comments about it. -AstaHost
Management ....
Navcat For MySQL
is Navcat any good? (9) Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....
PHP & MySQL: Displaying Content From A Given ID
(6) Okay so I got this sample link (not working): http://www.acosta.com/joo.asp?id=654 Now suppose
I have a PHP file that would use MySql in order to get all values in the row where id 654 is found.
Here's a sample DB: Table: demnyc ______________________________________ | id |
Name | Age | Email | *----------------------------------------------------* | 1
| Albert | 17 | no email |
*----------------------------------------------------* | 2 | YaPow | 888 |
no email | |__________....
MySQL, Multiple Tables
(24) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
CuteNews: PHP-based Blog System - No MySQL
(11) I don't know if you guys have heard about CuteNews, but I think it's an awesome blogging
system. If you don't know where to get it or how to set it up, here is a quick run-down.
Download the zip file (virus free) from http://www.mysharebox.com/dl.php?key=8276639 . 1) Unzip
the file. 2) Make a folder titled "cutenews". 3) Upload the contents of the cutenews folder into the
one you've just created. 4) CHMOD the file index.php to 777. 5) CHMOD the folder "data" to 777.
6) Then CHMOD all the files and folders inside of "data" to 777. 7) Go to http://YO....
Important: Basics Of Using PHP And MySQL
(10) I generally notice confusion with new users to PHP and or MySQL and first of all I believe that
unlike HTML which is automatically associated with a IE browser in a Microsoft system. HTML is
automatically rendered with whatever browser is the default browser, be it Internet Expolrer Firefox
Netscape or any other browser that has been set. PHP is a different matter to view the output of a
PHP file it must be run on a webserver, and if you do not have one set up on your local PC it simply
will not work. (Note serverside langauge requies a server) HTML is client side and ....
MySQL Output Database Question
(18) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
MySQL For EasyPHP Users
Does anyone use this program? (5) I installed a program called EasyPHP because it was an easy install and I wanted to be able to learn
php and still be able to down the road learn MySQL. But I can't figure out how to use MySQL.
Does anyone out there use this program that could tell me alittle about it. Alot of the product
site is written in a different language, but everything on the program is english so that is good.
Any help would be appreciated.....
[PHP + MySQL] Encrypting Data
To protect the password of your DB, for example. (11) Hi! This is my 2nd code of PHP + MySQL. This code is VERY simple: it encript the data in the MySQL
DB. Here we go! ------------------------------------------------------------------------ CODE
$password = "abc"; $new_password = md5($password); echo $new_password; ?> The password "abc"
was codfied using md5() This will be: 900150983cd24fb0d6963f7d28e17f72 CODE $normal_pass =
"abc"; $encripted_pass = "900150983cd24fb0d6963f7d28e17f72"; if(md5($normal_pass) ==
$encripted_pass) echo "Login Sucessful!"; else echo "Incorrect password."; ?> This c....
Need Help With A PHP - MySQL Registration Script
Wont INSERT into the database (13) hey well can some one helpme make this code work it won't INSERT INTO THE DATABSE CODE #
register1.php # common include file to MySQL include("DB.PHP"); $Username=$_POST ; $Password=$_POST
; $Name=$_POST ; $Last=$_POST ; $Sex=$_POST ; $Month=$_POST ; $Day=$_POST ; $Year=$_POST ;
$Adresse=$_POST ; $City=$_POST ; $State=$_POST ; $Zipcode=$_POST ; $Country=$_POST ; $Phone=$_POST ;
$Email=$_POST ; $Father_Name=$_POST ; $Mother_Name=$_POST ; $Parent_Phone=$_POST ;
$Parent_Email=$_POST ; $Level=$_POST ; $Academic=$_POST ; $Image_Link=$_POST ; $sql9="INSERT INTO
U....
Recover Tables From A MySQL .frm File
(8) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
MySQL Realtime Replication
how to replicate mysql in realtime (4) i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....
MySQL - Trouble With Bulk Insert Statements
(3) I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
can have it tell me if there where any errors all the statements are executed? Thanks for your
help.....
Looking for mysql, explain
|
*SIMILAR VIDEOS*
Searching Video's for mysql, explain
| Similar | | Small Issues About Mysql Connector/j 5.1 |
| Login System - I want to make a login system using Mysql. I am amateur in these thing |
| Which Language Is Easy And Secure Today For Web Development - is PHP MYSQL is easy and Secure ? |
| Mysql Overhead |
| What You Need Before You Can Create A Text-based Game.. - Using PHP, HTML and MySQL |
| Mysql Multiple Tables |
| Any Website Provide Free Host Mysql Host? |
| How To: Display A Members/user List. - With PHP, Mysql, and HTML. |
| Mysql On Computer - XD |
| Can You Link Game Maker With Mysql/php - Title says it :D |
| Mysql Database Entry By Excel Sheets |
| Mysql Database Management |
| Mysql And User File_priv |
| Mysql With My Own Server - few questions |
| Login System Using A Mysql Db - How do i do this? |
| Php Tutorial: Making A Shoutbox - Requirements: PHP, MySQL |
| Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking ) - A small tutorial to explain integrating php, ajax and MySQL Database |
| Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom) - 150 MB space, 10000 MB Bandwidth, php, mysql, CPanel |
| Navcat For MySQL - is Navcat any good? |
| PHP & MySQL: Displaying Content From A Given ID |
| MySQL, Multiple Tables |
| CuteNews: PHP-based Blog System - No MySQL |
| Important: Basics Of Using PHP And MySQL |
| MySQL Output Database Question |
| MySQL For EasyPHP Users - Does anyone use this program? |
| [PHP + MySQL] Encrypting Data - To protect the password of your DB, for example. |
| Need Help With A PHP - MySQL Registration Script - Wont INSERT into the database |
| Recover Tables From A MySQL .frm File |
| MySQL Realtime Replication - how to replicate mysql in realtime |
| MySQL - Trouble With Bulk Insert Statements |
|
advertisement
|
|
