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⤋