我建立视图的语句如下:
CREATE OR REPLACE VIEW viewlog AS SELECT tbl1.iid, tbl2.title FROM `tbl1`,`tbl2` WHERE tbl1.iid = tbl2.iid;
现在希望在iid前增加一个did int auto_increment!
...全文
76613打赏收藏
mysql create view的时候能否建立一个自增变量?
我建立视图的语句如下: CREATE OR REPLACE VIEW viewlog AS SELECT tbl1.iid, tbl2.title FROM `tbl1`,`tbl2` WHERE tbl1.iid = tbl2.iid; 现在希望在iid前增加一个did int auto_increment!
不过这样太麻烦
mysql> select count(*) as did,t.id from t left outer join t as ttt on t.id>=tt
t.id group by id;
+-----+------+
| did | id |
+-----+------+
| 1 | 0001 |
| 2 | 0002 |
| 3 | 0003 |
+-----+------+
3 rows in set (0.00 sec)
这样解决 t表数据
mysql> select * from t;
+------+
| id |
+------+
| 0001 |
| 0002 |
| 0003 |
+------+
3 rows in set (0.00 sec)
在我的数据表`tbl1`和`tbl2`中,存在着两个字段tbl1.iid和tbl2.rid能够唯一表示SELECT tbl1.iid, tbl2.title FROM `tbl1`,`tbl2` WHERE tbl1.iid = tbl2.iid; 后结果集的记录,但我需要有一个字段能够唯一标示每一条记录,不一定非得是自增的!