本文目錄一覽:
- 1、急需關於mysql數據庫知識。。基礎點,在哪可以下載到啊
- 2、mysql數據庫從下載到使用
- 3、怎麼下載MYSQL數據庫啊
- 4、mysql數據庫到底下載哪個
- 5、mysql數據庫下載地址?
- 6、我想要安裝mysql數據庫 都需要下載什麽東西?
急需關於mysql數據庫知識。。基礎點,在哪可以下載到啊
?php//$TEXT[‘phonebook-sure’]=’刪除’;
class F{
//—————————————-連接
function connect()
{
$con = mysql_connect(“localhost”,”root”,”123456″);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
else
{
echo “連接成功”;
}
}
//—————————————-關閉
function closeDB()
{
$con = mysql_connect(“localhost”,”root”,”123456″);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
else
{
echo “br/”;
echo “關閉成功”;
}
mysql_close($con);
}
//——————————增加(無參數):
function create()
{
$con = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“student”, $con);
$sql=”INSERT INTO parker (id, name)VALUES(‘$_POST[id]’,’$_POST[name]’)”;
if (!mysql_query($sql,$con))
{
//die(‘Error: ‘ . mysql_error());
echo “無添加信息”;
}
else
echo “插入成功!”;
}
//——————————增加(有參數):
function newCreate($id,$name)
{
$con = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“student”, $con);
$sql=”INSERT INTO parker (id, name)VALUES(‘$id’,’$name’)”;
if (!mysql_query($sql,$con))
{
//die(‘Error: ‘ . mysql_error());
echo “無添加信息”;
}
else
echo “插入成功,請刷新!”;
}
//————————————查詢(無參數)
function select()
{
$con = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“student”, $con);
$output=”刪除”;
$change=’修改’;
//查詢方法
$result = mysql_query(“SELECT * FROM parker”);
//得到結果集
echo’br /’;
echo “table border=’1′
tr
th id/th
thname/th
th刪除/th
th修改/th
/tr”;
while($row = mysql_fetch_array($result))
{
echo “tr”;
echo “td” . $row[‘id’] . “/td”;
echo “td” . $row[‘name’] . “/td”;
// echo “tdform action=’deal.php’ method=’post’ name=’form1’input type=’button’ name =’button’ value=’刪除’ onClick/form/td”;
// echo “tdform action=’deal.php’ method=’post’ name=’form1’input type=’button’ name =’button’ value=’刪除’ /form/td”;
// echo “td class=’tabval’a onclick=\”return confirm(‘”.$TEXT[‘phonebook-sure’].”‘);\” href=’phonebook.php?action=delid=”.$row[‘id’].”‘span class=’red'[“.$TEXT[‘phonebook-button1’].”]/span/a/td”;
// echo “a onclick\” href=’deal.php?action=del$id=”.$row[‘id’].”‘/a”;
echo “td class=’tabval’a onclick=\”return confirm(‘\” href=’deal.php?action=delid=”.$row[‘id’].”‘span class=’red'[“.’刪除’.”]/span/a/td”;
echo “td class=’tabval’a onclick=\”return confirm(‘\” href=’change.php?action=changeid=”.$row[‘id’].”‘span class=’red'[“.’修改’.”]/span/a/td”;
// echo “td”.$change.”/td”;
echo “/tr”;
}
/*echo “button onclick=”alert(‘”+?php echo $txt; ?+”‘)”/button”;*/
echo “/table”;
echo “查詢成功!”;
echo’br /’;
}
//——————————————-查詢(有參數)
function selectNew($id)
{
//print_r($_POST[‘id’]);
$id=$_POST[‘id’];
$con = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“student”, $con);
$output=”刪除”;
$change=’修改’;
//查詢方法
$result = mysql_query(“SELECT * FROM parker WHERE id=’$id'”);
//得到結果集
echo’br /’;
echo “table border=’1′
tr
th id/th
thname/th
/tr”;
while($row = mysql_fetch_array($result))
{
echo “tr”;
echo “td” . $row[‘id’] . “/td”;
echo “td” . $row[‘name’] . “/td”;
echo “/tr”;
}
echo “/table”;
//echo “查詢成功!”;
echo’br /’;
}
//————————-刪除(無參數)
function delete()
{
$con = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“student”, $con);
$sql=”DELETE FROM parker WHERE id=’$_POST[id]'”;
//mysql_query(“DELETE FROM parker WHERE id=’$_POST[id]'”);
//if (!mysql_query(“DELETE FROM parker WHERE id=’$_POST[id]'”))
// {
// die(‘Error: ‘ . mysql_error());
//}
//else
// echo “刪除成功”;
if (!mysql_query($sql,$con))
{
//die(‘Error: ‘ . mysql_error());
echo “無操作”;
}
else
{
echo “刪除!”;
}
}
//————————-刪除(有參數)
function newDelete($id)
{
$con = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“student”, $con);
//mysql_query(“DELETE FROM parker WHERE id=’$_POST[id]'”);
$sql=”DELETE FROM parker WHERE id=’$id'”;
if (!mysql_query($sql,$con))
{
//die(‘Error: ‘ . mysql_error());
echo “無操作”;
}
else
{
echo “刪除!”;
}
}
//————————————-更新
function update($id,$name)
{
$con = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“student”, $con);
mysql_query(“UPDATE parker SET name = ‘$name’WHERE id=’$id'”);
//if (!mysql_query(“UPDATE parker SET name = ‘$_POST[name]’WHERE id=’$_POST[id]'”))
// die(‘Error: ‘ . mysql_error());
//else
// echo “修改成功”;
}
//————————————統計表中有多少記錄(無參數)
function count()
{
$con = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“student”, $con);
//mysql_query(“select count(id) from parker”);
$sql=”SELECT COUNT(id) AS count FROM parker”;
$result=mysql_fetch_array(mysql_query($sql));
$count=$result[‘count’];
echo “$count”;
}
}
?
mysql數據庫從下載到使用
從網站下載下來的mysql-windows版本是完整的服務器端和客戶端的。一般都會同時裝的。如果是你本機:
mysql -u用戶 -p密碼 應該就能直接進入mysql的命令模式
如果是連其他機器:
mysql -u用戶 -p密碼 -h其他機器IP
怎麼下載MYSQL數據庫啊
去mysql官網,找到downloads 點擊(如圖) 然後在彈出頁面中間的下面找到
MySQL Community Server 下面一點就是幾個版本的鏈接
Current Release (Recommended) //推薦版本
MySQL 5.1—Generally Available (GA) release for production use
Beta Releases
MySQL 5.4—Beta
Upcoming Releases
Snapshots — source code snapshots of the development trees
Glassfish+MySQL bundle — developers edition
Older Releases //老版本
MySQL 5.0 — Previous GA release
MySQL 4.1 — Previous GA release
Archives of Older Releases
mysql數據庫到底下載哪個
下載mysql最新版本最好 ,然後再下載一個輔助工具 navicat for mysql
這是一個圖形界面的軟件 ,你可以在裡面建表就行Oracle的plsqldev軟件店功能一樣 ,非常的方便和快捷。這些軟件都是免費的
mysql數據庫下載地址?
mysql官方網站:裡面就有,直接解壓就可以用了,不用安裝,要是安裝用戶圖形管理界面,navicat就足夠了
我想要安裝mysql數據庫 都需要下載什麽東西?
phpmyadmin解壓後就能用了關鍵是他的配置文件中的設定,建議你百度一下phpmyadmin配置.
原創文章,作者:小藍,如若轉載,請註明出處:https://www.506064.com/zh-hant/n/227603.html