1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| mysql> create table t1 (nom varchar(10));
Query OK, 0 rows affected (0.11 sec)
mysql> create table t2 (nom varchar(10));
Query OK, 0 rows affected (0.09 sec)
mysql> insert into t1 values ('toto'),('tata');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> insert into t2 values ('tutu'),('titi');
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> create view v as
-> select @rownum:=@rownum+1 as rk, t.nom
-> from (select nom from t1
-> union all
-> select nom from t2) t
-> cross join (SELECT @rownum:=0) r;
ERROR 1351 (HY000): View's SELECT contains a variable or parameter '
mysql> select @rownum:=@rownum+1 as rk, t.nom
-> from (select nom from t1
-> union all
-> select nom from t2) t
-> cross join (SELECT @rownum:=0) r
-> order by t.nom;
+------+------+
| rk | nom |
+------+------+
| 1 | tata |
| 2 | titi |
| 3 | toto |
| 4 | tutu |
+------+------+
4 rows in set (0.00 sec)
mysql> |
Partager