Yadda za a duba matsayi da sigar bayanin tsarin tsarin bayanan tsarin bayanan bayanan MySQL?

MySQL metadata

Kuna iya son sanin waɗannan nau'ikan bayanai guda uku masu zuwa game da MySQL:

• Bayanin sakamakon tambaya: Adadin bayanan da SELECT, UPDATE ko DELETE bayanin ya shafa.
• Bayani game da ma'ajin bayanai da teburin bayanai: Ya ƙunshi bayanan tsarin bayanai da teburin bayanai.
• Bayanin uwar garken MySQL: Ya ƙunshi halin yanzu na uwar garken bayanai, lambar sigar, da sauransu.

A cikin umarni na MySQL, za mu iya samun bayanan uwar garken da ke sama cikin sauƙi.Amma idan kuna amfani da yaren rubutun kamar Perl ko PHP, kuna buƙatar kiran takamaiman aikin dubawa don samunsa.Na gaba za mu gabatar da dalla-dalla.

Samo adadin bayanan da bayanin tambaya ya shafa

Misalin PERL

A cikin rubutun DBI, ana mayar da adadin bayanan da bayanin ya shafa ta ayyukan yi ( ) ko aiwatarwa ():

# 方法 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 misali

A cikin PHP, zaku iya amfani da aikin mysqli_affected_rows( ) don samun adadin bayanan da tambaya ta shafa.

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

Jerin bayanan bayanai da teburin bayanai

Kuna iya samun jerin bayanan bayanai da tebur cikin sauƙi a cikin uwar garken MySQL.Idan baku da isassun izini, sakamakon zai dawo da banza.
Hakanan zaka iya amfani da SHOW TABLES ko NUNA bayanan DATABASES don samun jerin bayanan bayanai da teburin bayanai.

Misalin PERL

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

PHP misali

Misali mai zuwa yana fitar da duk bayanan bayanai akan uwar garken 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);
?>

Samo metadata uwar garke

Ana iya amfani da bayanan umarni masu zuwa a saurin umarni na MySQL ko a cikin rubutun, kamar rubutun PHP.