English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

2007-07-19 08:52:41 · 4 answers · asked by raul g 1 in Computers & Internet Programming & Design

4 answers

This might help:

http://www.mysql.com/products/enterprise/unlimited.html?gclid=CKHBsdmztI0CFQhvHgodcGMcsg

2007-07-19 08:59:13 · answer #1 · answered by Halo 5 · 0 0

Its not a language to use
its a fom of Database/and server

you use the SQL database from a program
the data base is formatted by code
telling it how many fields
field rules and initialization size
of the database

2007-07-19 08:58:33 · answer #2 · answered by Anonymous · 0 0

MySQL is not a language as such. You access it using given codes (Perl or PhP).
You really need only a few functions.
This is a full "course" o MySQL (Free of Charge)!
Here they are:
function dbconnect()
{
$link = mysql_connect("localhost", "username", "password") or die(" Could not connect : " . mysql_error());
mysql_select_db("dbasename") or die("Could not select database");
return($link);
}

function makedbtable()
{
$tablename = "stories";
$link = dbconnect();
$cmdd = "DROP TABLE IF EXISTS " . $tablename;
mysql_query($cmdd) or die("Query failed : " . mysql_error());
$cmdd = "CREATE TABLE `".$tablename."` (
`number` VARCHAR(10) NOT NULL,
`title` VARCHAR(100) NOT NULL,
`text` LONGTEXT
) TYPE = MYISAM" ;
mysql_query($cmdd) or die("Query failed : " . mysql_error());
mysql_close($link);
}
function addstories($_POST) // edition, date, title, resume, fname
{
while(list($name,$value) = each($_POST))
$$name=$value;
$link=dbconnect();
$txt = 'VALUES ("'.$number.'","'.$title.'",
"'.$text.'")';
$sql = 'INSERT INTO `stories` ( `number`,`title`,
`text`) ' . $txt;
$result = mysql_query($sql) or die("Query failed : " . mysql_error());
mysql_close($link);
return ($result);
}
function delstories($_POST)
{
while(list($name,$value) = each($_POST))
$$name=$value;
$link=dbconnect();
$query="DELETE FROM `stories` WHERE `title` = '" . $title . "' AND `number`= '".$number."' LIMIT 1 ";
$list = mysql_query($query) or die("Query failed : " . mysql_error());
mysql_close($link);
}
function getentries()
{
$link=dbconnect();
$query="SELECT * FROM `stories` WHERE 1";
$list = mysql_query($query) or die("Query failed : " . mysql_error());
while ($lst = mysql_fetch_array($list))
{
echo ($lst[0]."
");
echo ($lst[1]."
");
echo ($lst[2]."
");
}
mysql_free_result($list);
mysql_close($link);
}
?>
Of course there are more, but it is not essential to know them at this time.

2007-07-19 21:59:46 · answer #3 · answered by just "JR" 7 · 0 0

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

You need to able to find answers for yourself to get anywhere in IT. google is your friend.

2007-07-19 08:58:22 · answer #4 · answered by Anonymous · 1 0

fedest.com, questions and answers