视图上无法创建索引

最新推荐文章于 2023-07-09 21:16:32 发布

weixin_30268921

最新推荐文章于 2023-07-09 21:16:32 发布

阅读量314

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zhaoyangjian724/p/6199919.html

mysql> create view v_test as select * from test;
Query OK, 0 rows affected (0.15 sec)

mysql> desc v_test;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| id    | int(11)  | YES  |     | NULL    |       |
| name  | char(10) | YES  |     | NULL    |       |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.07 sec)

mysql> create index v_test_idx1 on v_test(id);
ERROR 1347 (HY000): 'zjzc.v_test' is not BASE TABLE

转载于:https://www.cnblogs.com/zhaoyangjian724/p/6199919.html