MySQL數(shù)據(jù)庫是一款強大的關系型數(shù)據(jù)庫,應用廣泛于WEB開發(fā)、數(shù)據(jù)存儲等領域,以下是一些常見的MySQL操作數(shù)據(jù)庫數(shù)據(jù)的方法:
1. 連接數(shù)據(jù)庫 $conn = mysqli_connect('localhost','root','password','database_name'); if (!$conn){ die('Could not connect: ' . mysqli_error()); } 2. 插入數(shù)據(jù) $sql = "INSERT INTO tablename (col1,col2,col3) VALUE ('$val1','$val2','$val3')"; if (mysqli_query($conn,$sql)){ echo "New record created successfully"; } else { echo "Error: " . $sql . "
" . mysqli_error($conn); } 3. 查詢數(shù)據(jù) $sql = "SELECT col1,col2,col3 FROM tablename"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) >0) { while($row = mysqli_fetch_assoc($result)) { echo "col1: " . $row["col1"]. " - col2: " . $row["col2"]. " - col3: " . $row["col3"]. "
"; } } else { echo "0 results"; } 4. 更新數(shù)據(jù) $sql = "UPDATE tablename SET col1='$newval' WHERE col2=$keyval"; if (mysqli_query($conn, $sql)) { echo "Record updated successfully"; } else { echo "Error updating record: " . mysqli_error($conn); } 5. 刪除數(shù)據(jù) $sql = "DELETE FROM tablename WHERE col1=$val"; if (mysqli_query($conn, $sql)) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . mysqli_error($conn); }
以上是一些常見的MySQL數(shù)據(jù)庫操作方法,在具體使用時,還需要結合實際需求進行豐富和使用。