Kedu otu esi ele ọkwa na ụdị ozi nhazi tebụl data nke MySQL nchekwa data?

MySQL metadata

Ị nwere ike ịchọ ịma ụdị ozi atọ ndị a gbasara MySQL:

• Ozi nsonaazụ ajụjụ: Ọnụọgụ ndekọ nke ahọpụtara, kwalite ma ọ bụ hichapụ nkwupụta.
• Ozi gbasara ọdụ data na tebụl data: Nwere ozi nhazi nke nchekwa data yana tebụl data.
• Ozi nkesa MySQL: Nwere ọnọdụ nke ihe nkesa nchekwa data ugbu a, nọmba ụdị, wdg.

Na MySQL iwu ozugbo, anyị nwere ike nweta ozi nkesa dị n'elu ngwa ngwa.Mana ọ bụrụ na ị na-eji asụsụ scripting dị ka Perl ma ọ bụ PHP, ịkwesịrị ịkpọ otu ọrụ interface iji nweta ya.Ọzọ anyị ga-ewebata n'ụzọ zuru ezu.

Nweta ọnụọgụ ndekọ nke nkwupụta ajụjụ metụtara

Ọmụmaatụ PERL

N'edemede DBI, ọnụọgụ ndekọ nke nkwupụta ahụ metụtara na-eweghachite site na ọrụ ndị a na-eme ( ) ma ọ bụ mebie():

# 方法 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);

Ihe atụ PHP

Na PHP, ị nwere ike iji ọrụ mysqli_affected_rows( ) iji nweta ọnụọgụ ndekọ nke ajụjụ metụtara.

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

Ndepụta nke ọdụ data na tebụl data

Ị nwere ike nweta ndepụta nke ọdụ data na tebụl na sava MySQL ngwa ngwa.Ọ bụrụ na ịnweghị ikike zuru oke, nsonaazụ ga-alaghachi efu.
Ị nwekwara ike iji SHOW TABLES ma ọ bụ Gosi nkwupụta DATABASES iji nweta ndepụta ọdụ data na tebụl data.

Ọmụmaatụ PERL

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

Ihe atụ PHP

Ihe atụ na-esonụ na-ewepụta ọdụ data niile na sava 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);
?>

Nweta metadata nkesa

Enwere ike iji nkwupụta iwu ndị a na ngwa ngwa MySQL ma ọ bụ na scripts, dị ka script PHP.