Maitiro ekuona chimiro uye vhezheni nhamba yedata tafura chimiro ruzivo rweMySQL dhatabhesi?

MySQL metadata

Iwe unogona kuda kuziva anotevera marudzi matatu eruzivo nezve MySQL:

• Ruzivo rwemhedzisiro yemibvunzo: Huwandu hwemarekodhi akabatwa neiyo SELECT, UPDATE kana DELETE chirevo.
• Ruzivo nezve databases uye data matafura: Iine ruzivo rwechimiro chedatabase uye data tafura.
• MySQL server ruzivo: Iine mamiriro aripo eiyo database server, nhamba yevhezheni, nezvimwe.

MuMySQL command prompt, tinogona kuwana nyore ruzivo rwesevha iri pamusoro.Asi kana iwe ukashandisa mutauro wekunyora wakaita sePerl kana PHP, unofanirwa kufonera chaiyo interface basa kuti uiwane.Tevere tichasuma zvakadzama.

Wana huwandu hwemarekodhi akabatwa neiyo query statement

PERL muenzaniso

Muzvinyorwa zveDBI, huwandu hwemarekodhi akabatwa nechirevo chinodzoserwa nemabasa do( ) kana kuuraya ( ):

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

MuPP, unogona kushandisa mysqli_affected_rows() basa kuti uwane nhamba yezvinyorwa zvakakanganiswa nemubvunzo.

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

Rondedzero yedatabase uye data matafura

Iwe unogona kuwana nyore rondedzero yedhatabhesi uye matafura muMySQL server.Kana iwe usina mvumo yakakwana, mhedzisiro inodzoka isina maturo.
Iwe unogona zvakare kushandisa SHOW TABLES kana SHOW DATABASES chirevo kuti uwane rondedzero yedhatabhesi uye data matafura.

PERL muenzaniso

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

PHP muenzaniso

Muenzaniso unotevera unoburitsa ese dhatabhesi paMySQL server:

<?
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);
?>

Tora server metadata

Zvinotevera zvirevo zvemirairo zvinogona kushandiswa paMySQL command prompt kana mune zvinyorwa, senge PHP zvinyorwa.