mysql数据库的可视化工具怎么用

发布网友发布时间：2022-04-24 00:06

共2个回答

懂视网时间：2022-04-30 02:30

VIEW ProductCustomers AS -> SELECT cust_name, cust_contact, prod_id -> FROM Customers, Orders, OrderItems -> WHERE Customers.cust_id = Orders.cust_id -> AND OrderItems.order_num = Orders.order_num; SELECT cust_name, cust_contact FROM ProductCustomers WHERE prod_id = ‘RGAN01‘; +---------------+--------------------+ | cust_name | cust_contact | +---------------+--------------------+ | Fun4All | Denise L. Stephens | | The Toy Store | Kim Howard | +---------------+--------------------+ SELECT CONCAT(vend_name, ‘ (‘, vend_country, ‘)‘) -> FROM Vendors ORDER BY vend_name; +--------------------------------------------+ | CONCAT(vend_name, ‘ (‘, vend_country, ‘)‘) | +--------------------------------------------+ | Bear Emporium (USA) | | Bears R Us (USA) | | Doll House Inc. (USA) | | Fun and Games (England) | | Furball Inc. (USA) | | Jouets et ours (France) | +--------------------------------------------+ CREATE VIEW VendorLocations AS -> SELECT CONCAT(vend_name, ‘ (‘, vend_country, ‘)‘) -> AS vend_title -> FROM Vendors; Query OK, 0 rows affected (0.02 sec) CREATE VIEW CustomersEmailList AS -> SELECT cust_id, cust_name, cust_email -> FROM Customers -> WHERE cust_email IS NOT NULL; Query OK, 0 rows affected (0.02 sec) CREATE VIEW OrderItemsExpandedPrice AS -> SELECT order_num, prod_id, quantity, item_price, quantity * item_price AS expanded_price -> FROM OrderItems; Query OK, 0 rows affected (0.01 sec) SELECT * FROM OrderItemsExpandedPrice; +-----------+---------+----------+------------+----------------+ | order_num | prod_id | quantity | item_price | expanded_price | +-----------+---------+----------+------------+----------------+ | 20005 | BR01 | 100 | 5.49 | 549.00 | | 20005 | BR03 | 100 | 10.99 | 1099.00 | | 20006 | BR01 | 20 | 5.99 | 119.80 | | 20006 | BR02 | 10 | 8.99 | 89.90 | | 20006 | BR03 | 10 | 11.99 | 119.90 | | 20007 | BR03 | 50 | 11.49 | 574.50 | | 20007 | BNBG01 | 100 | 2.99 | 299.00 | | 20007 | BNBG02 | 100 | 2.99 | 299.00 | | 20007 | BNBG03 | 100 | 2.99 | 299.00 | | 20007 | RGAN01 | 50 | 4.49 | 224.50 | | 20008 | RGAN01 | 5 | 4.99 | 24.95 | | 20008 | BR03 | 5 | 11.99 | 59.95 | | 20008 | BNBG01 | 10 | 3.49 | 34.90 | | 20008 | BNBG02 | 10 | 3.49 | 34.90 | | 20008 | BNBG03 | 10 | 3.49 | 34.90 | | 20009 | BNBG01 | 250 | 2.49 | 622.50 | | 20009 | BNBG02 | 250 | 2.49 | 622.50 | | 20009 | BNBG03 | 250 | 2.49 | 622.50 | +-----------+---------+----------+------------+----------------+

MySQL.VIEWS

标签：

热心网友时间：2022-04-29 23:38

在mysql的图形界面中，建数据库方法如下：
1、举例说明为了不影响其他的数据库表，新建一张数据库表t_worker_info，代码如下：
create
table
t_worker_info(
id
int(8)
primary
key
not
null
auto_increment,
w_id
int(10)
not
null,
w_name
varchar(20)
not
null,
w_age
int(3),
w_sex
varchar(10),
w_birth
varchar(20)
)。
2、创建t_worker_info后，查看一下数据结构，代码如下：
desc
t_worker_info。
3、双击选中的数据库，在views鼠标右键“create
view...”，打开编辑窗口，并在窗口中输入代码，代码如下：
create
view
`view_worker_info`
as
select
*
from
t_worker_info。
4、查看创建视图的基本信息，利用desc或describe语句，代码如下：
desc
view_worker_info。
5、查看视图信息，如存储引擎、数据长度等，如果上述指标都为null，说明视图是虚表，代码如下：
show
table
status
like
'view_worker_info'。
6、查看创建视图的详细信息，需要用到show
create
view
视图名，代码如下：
show
create
view
view_worker_info。