Diferència entre revisions de la pàgina «ASIX/M02/UF2/A09/E0»
Salta a la navegació
Salta a la cerca
| Línia 5: | Línia 5: | ||
-> SELECT * FROM sp where s=2; | -> SELECT * FROM sp where s=2; | ||
Query OK, 0 rows affected (0.03 sec)</source> | Query OK, 0 rows affected (0.03 sec)</source> | ||
| + | |||
| + | ==Comprovo el contingut que em mostra aquesta vista== | ||
| + | <source lang="mysqle">MariaDB [peces]> select * from vEnviamentsS2; | ||
| + | +----+-----+------+ | ||
| + | | s | p | cant | | ||
| + | +----+-----+------+ | ||
| + | | s2 | p10 | 300 | | ||
| + | | s2 | p4 | 200 | | ||
| + | | s2 | p5 | 200 | | ||
| + | | s2 | p6 | 100 | | ||
| + | | s2 | p7 | 400 | | ||
| + | | s2 | p8 | 200 | | ||
| + | | s2 | p9 | 130 | | ||
| + | +----+-----+------+ | ||
| + | 7 rows in set (0.00 sec)</source> | ||
Revisió del 15:30, 18 gen 2018
Crear una vista dels enviaments del proveïdor s2
Creo la vista vEnviamentsS2:
MariaDB [peces]> CREATE VIEW vEnviamentsS2 as
-> SELECT * FROM sp where s=2;
Query OK, 0 rows affected (0.03 sec)
Comprovo el contingut que em mostra aquesta vista
MariaDB [peces]> select * from vEnviamentsS2; +----+-----+------+ | s | p | cant | +----+-----+------+ | s2 | p10 | 300 | | s2 | p4 | 200 | | s2 | p5 | 200 | | s2 | p6 | 100 | | s2 | p7 | 400 | | s2 | p8 | 200 | | s2 | p9 | 130 | +----+-----+------+ 7 rows in set (0.00 sec)
