Kodi mungawone bwanji zomwe zili ndi nambala yamtundu wamtundu wa data ya MySQL database?

MySQL metadata

Mungafune kudziwa mitundu itatu yotsatirayi ya MySQL:

• Zotsatira zafunso: Chiwerengero cha zolembedwa zomwe zakhudzidwa ndi mawu a SELECT, UPDATE kapena DELETE.
• Zambiri za nkhokwe ndi ma data table: Lili ndi zambiri zamapangidwe a database ndi tebulo la data.
• Zambiri za seva ya MySQL: Lili ndi momwe seva ya database ilipo, nambala ya mtundu, ndi zina.

Mu MySQL command prompt, titha kupeza mosavuta zomwe zili pamwambapa.Koma ngati mugwiritsa ntchito chilankhulo cholembera monga Perl kapena PHP, muyenera kuyimbira mawonekedwe apadera kuti mumve.Kenako tifotokoza mwatsatanetsatane.

Pezani chiwerengero cha zolemba zomwe zakhudzidwa ndi mawu afunso

Chitsanzo cha PERL

M'zolemba za DBI, kuchuluka kwa zolembedwa zomwe zakhudzidwa ndi mawuwo zimabwezedwa ndi ntchito do( ) kapena execute ( ):

# 方法 1
# 使用do( ) 执行  $query 
my $count = $dbh->do ($query);
# 如果发生错误会输出 0
printf "%d 条数据被影响\n", (defined ($count) ? $count : 0);
# 方法 2
# 使用prepare( ) 及 execute( ) 执行  $query 
my $sth = $dbh->prepare ($query);
my $count = $sth->execute ( );
printf "%d 条数据被影响\n", (defined ($count) ? $count : 0);

PHP chitsanzo

Mu PHP, mungagwiritse ntchito mysqli_affected_rows() ntchito kuti mupeze chiwerengero cha zolemba zomwe zakhudzidwa ndi funso.

$result_id = mysqli_query ($conn_id, $query);
# 如果查询失败返回 
$count = ($result_id ? mysqli_affected_rows ($conn_id) : 0);
print ("$count 条数据被影响\n");

Mndandanda wa nkhokwe ndi matebulo a data

Mutha kupeza mosavuta mndandanda wazosewerera ndi matebulo mu seva ya MySQL.Ngati mulibe zilolezo zokwanira, zotsatira zake zidzakhala zopanda pake.
Mukhozanso kugwiritsa ntchito mawu a SHOW TABLES kapena SHOW DATABASES kuti mupeze mndandanda wa nkhokwe ndi matebulo a data.

Chitsanzo cha PERL

# 获取当前数据库中所有可用的表。
my @tables = $dbh->tables ( );
foreach $table (@tables ){
   print "表名 $table\n";
}

PHP chitsanzo

Chitsanzo chotsatirachi chimatulutsa zolemba zonse pa seva ya MySQL:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
$db_list = mysqli_query($conn, 'SHOW DATABASES');
while ($db = mysqli_fetch_object($db_list))
{
 echo $db->Database . "<br />";
}
mysqli_close($conn);
?>

Pezani metadata ya seva

Mawu otsatirawa angagwiritsidwe ntchito pa MySQL command prompt kapena m'malemba, monga PHP scripts.