mysql - 如何从 mysql(Xampp) 上的不同表中搜索数据。我正在使用 vb.net

Question

我的数据库 mysql(Xampp)、tbl_classic、tbl_signature、tbl_fusion、tbl_blends 上有 4 个表，每个表有 5 列 ID、FlavorItems、FlavorQuantity、MediumPrice、LargePrice。如何在所有表中搜索 FlavorItems 的值？

    Dim sql1 As String = ("Select * From tbl_classicmilktea where FlavorItems = @FlavorItems")

    cmd = New MySqlCommand(sql1, cn)
    cmd.Parameters.Add("@FlavorItems", MySqlDbType.VarChar).Value = txtSearch.Text

    Dim adapter As New MySqlDataAdapter(cmd)

    cn.Open()

    Dim table As New DataTable()

    Try
        adapter.Fill(table)

        If table.Rows.Count() > 0 Then
            ' Return only 1 row.
            txtNo.Text = table.Rows(0)(0).ToString()
            txtFlavorItems.Text = table.Rows(0)(1).ToString()
            dudQuantity.Text = table.Rows(0)(2).ToString()
            txtMedium.Text = table.Rows(0)(3).ToString()
            txtLarge.Text = table.Rows(0)(3).ToString()
        End If
    Catch Ex As Exception
        MessageBox.Show("NO Data Found")
    End Try

    cn.Close()
End Sub

标签： mysqlvb.net