语法
CREATE [OR REPLACE] VIEW view_name [(column_list)] AS select_statement
示例
# 先建表
CREATE TABLE t_order (`id` bigint(11) NOT NULL AUTO_INCREMENT,
`order_id` varchar(20) DEFAULT NULL,
`buyer_id` varchar(20) DEFAULT NULL,
`seller_id` varchar(20) DEFAULT NULL,
`order_snapshot` longtext DEFAULT NULL,
`order_detail` longtext DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `l_i_order` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 dbpartition by hash(`order_id`);
# 创建视图
create view t_detail as select order_id,order_detail from t_order;
# 查询视图
select * from t_detail;
![[NDK/JNI系列02] JNI的设计原理与数据类型](https://ucc.alicdn.com/pic/developer-ecology/lv5dhqr24gcj4_3b1bfded82714a9db2d0c260f3266f1f.png?x-oss-process=image/format,webp/resize,h_160,m_lfit)
