linuxÔõôִÐÐsql
ÔÚ linux ϵͳÖÐÖ´ÐÐ sql Óï¾äÓÐÈýÖÖÒªÁ죺ʹÓà mysql ÏÂÁîÐй¤¾ß£¨×°Öà mysql ¿Í»§¶Ë¡¢µÇ¼ mysql ЧÀÍÆ÷¡¢Ö´ÐÐ sql Óï¾ä£©Ê¹Óà python mysqldb ¿â£¨µ¼Èë¿â¡¢ÅþÁ¬Êý¾Ý¿â¡¢Ö´ÐÐ sql Óï¾ä£©Ê¹Óà php mysqli ¿â£¨µ¼Èë¿â¡¢ÅþÁ¬Êý¾Ý¿â¡¢Ö´ÐÐ sql Óï¾ä£©
ÔÚ Linux ÖÐÖ´ÐÐ SQL
ÔÚ Linux ϵͳÖÐÖ´ÐÐ SQL Óï¾äÓÐÒÔϼ¸ÖÖÒªÁ죺
ÒªÁì 1£ºÊ¹ÓÃÏÂÁîÐй¤¾ß
1.1. ×°Öà MySQL ¿Í»§¶Ë
sudo apt-get install mysql-client
µÇ¼ºó¸´ÖÆ
1.2. µÇ¼ MySQL ЧÀÍÆ÷
mysql -u [̞] -p
µÇ¼ºó¸´ÖÆ
1.3. Ö´ÐÐ SQL Óï¾ä
mysql> SELECT * FROM table_name;
µÇ¼ºó¸´ÖÆ
ÒªÁì 2£ºÊ¹Óà Python ¿â
2.1. ×°ÖÃ Python MySQLdb ¿â
sudo pip install mysqlclient
µÇ¼ºó¸´ÖÆ
2.2. µ¼Èë¿â²¢ÅþÁ¬µ½Êý¾Ý¿â
import mysql.connector mydb = mysql.connector.connect( host="localhost", user="username", password="password", database="database_name", ) mycursor = mydb.cursor()
µÇ¼ºó¸´ÖÆ
2.3. Ö´ÐÐ SQL Óï¾ä
mycursor.execute("SELECT * FROM table_name") results = mycursor.fetchall()
µÇ¼ºó¸´ÖÆ
ÒªÁì 3£ºÊ¹Óà PHP ¿â
3.1. ×°ÖÃ PHP MySQLi ¿â
sudo apt-get install php7.4-mysqli
µÇ¼ºó¸´ÖÆ
3.2. µ¼Èë¿â²¢ÅþÁ¬µ½Êý¾Ý¿â
<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "database_name"; // ½¨ÉèÅþÁ¬ $conn = new mysqli($servername, $username, $password, $dbname); // ¼ì²éÅþÁ¬ if ($conn->connect_error) { die("ÅþÁ¬Ê§°Ü: " . $conn->connect_error); }
µÇ¼ºó¸´ÖÆ
3.3. Ö´ÐÐ SQL Óï¾ä
$sql = "SELECT * FROM table_name"; $result = $conn->query($sql); // Ñ»·ÅÌÎÊЧ¹û if ($result->num_rows > 0) { // Êä³öÊý¾Ý while($row = $result->fetch_assoc()) { echo "id: " . $row["id"] . " - Name: " . $row["name"] . "<br>"; } } else { echo "0 results"; }
µÇ¼ºó¸´ÖÆ
ÒÔÉϾÍÊÇlinuxÔõôִÐÐsqlµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡