Rrc en 18:51 23 oct 2015

2015-10-23T18:51:39Z

Página nueva

__NOTOC__
* [[:#Update | Update]]
* [[:#Replace | Replace]]
* [[:#Delete | Delete]]

= Update =

<syntaxhighlight lang="sql" line="GESHI_FANCY_LINE_NUMBERS">

MariaDB [Prueba1]> CREATE TABLE Est_fruta ( id INT NOT NULL primary key auto_increment,
-> nombre varchar (50) not null,
-> estado varchar (15) not null );
Query OK, 0 rows affected (0.22 sec)

MariaDB [Prueba1]> INSERT INTO Est_fruta VALUES ( NULL, 'Manzanas', 'Maduro' );
Query OK, 1 row affected (0.04 sec)

MariaDB [Prueba1]> INSERT INTO Est_fruta VALUES ( NULL, 'Naranjas' , 'Podrido' );
Query OK, 1 row affected (0.03 sec)

MariaDB [Prueba1]> INSERT INTO Est_fruta VALUES ( NULL, 'Uvas' , 'Maduro' );
Query OK, 1 row affected (0.07 sec)

MariaDB [Prueba1]> INSERT INTO Est_fruta VALUES ( NULL, 'Platanos' , 'Podrido' );
Query OK, 1 row affected (0.06 sec)

MariaDB [Prueba1]> SELECT * FROM Est_fruta;
+----+----------+---------+
| id | nombre | estado |
+----+----------+---------+
| 1 | Manzanas | Maduro |
| 2 | Naranjas | Podrido |
| 3 | Uvas | Maduro |
| 4 | Platanos | Podrido |
+----+----------+---------+
4 rows in set (0.00 sec)

MariaDB [Prueba1]> UPDATE Est_fruta SET estado = 'Maduro';
Query OK, 0 rows affected (0.03 sec)
Rows matched: 4 Changed: 0 Warnings: 0

MariaDB [Prueba1]> SELECT * FROM Est_fruta;
+----+----------+--------+
| id | nombre | estado |
+----+----------+--------+
| 1 | Manzanas | Maduro |
| 2 | Naranjas | Maduro |
| 3 | Uvas | Maduro |
| 4 | Platanos | Maduro |
+----+----------+--------+
4 rows in set (0.00 sec)

MariaDB [Prueba1]> INSERT INTO Est_fruta VALUES ( NULL, 'Sandilla' , 'Maduro' );
Query OK, 1 row affected (0.05 sec)

MariaDB [Prueba1]> SELECT * FROM Est_fruta;
+----+----------+--------+
| id | nombre | estado |
+----+----------+--------+
| 1 | Manzanas | Maduro |
| 2 | Naranjas | Maduro |
| 3 | Uvas | Maduro |
| 4 | Platanos | Maduro |
| 5 | Sandilla | Maduro |
+----+----------+--------+
5 rows in set (0.01 sec)

MariaDB [Prueba1]> UPDATE Est_fruta SET nombre = 'Sandia' WHERE nombre = 'Sandilla';
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [Prueba1]> SELECT * FROM Est_fruta;
+----+----------+--------+
| id | nombre | estado |
+----+----------+--------+
| 1 | Manzanas | Maduro |
| 2 | Naranjas | Maduro |
| 3 | Uvas | Maduro |
| 4 | Platanos | Maduro |
| 5 | Sandia | Maduro |
+----+----------+--------+
5 rows in set (0.00 sec)

MariaDB [Prueba1]> CREATE TABLE Inv_fruta ( id int not null primary key auto_increment,
-> nombre varchar (50) not null,
-> color varchar (15) not null,
-> precio float not null,
-> cantidad int not null );
Query OK, 0 rows affected (0.26 sec)

MariaDB [Prueba1]> INSERT INTO Inv_fruta VALUES ( NULL, 'Manzanas', 'Rojo', 5.0, 25 );
Query OK, 1 row affected (0.04 sec)

MariaDB [Prueba1]> INSERT INTO Inv_fruta VALUES ( NULL, 'Naranjas' , 'Anaranja' , 7.5, 44 );
Query OK, 1 row affected (0.04 sec)

MariaDB [Prueba1]> INSERT INTO Inv_fruta VALUES ( NULL, 'Uvas' , 'Verde' , 12.5, 15 );
Query OK, 1 row affected (0.09 sec)

MariaDB [Prueba1]> INSERT INTO Inv_fruta VALUES ( NULL, 'Platanos' , 'Amarillo' , 1.5, 36 );
Query OK, 1 row affected (0.09 sec)

MariaDB [Prueba1]> SELECT * FROM Inv_fruta;
+----+----------+----------+--------+----------+
| id | nombre | color | precio | cantidad |
+----+----------+----------+--------+----------+
| 1 | Manzanas | Rojo | 5 | 25 |
| 2 | Naranjas | Anaranja | 7.5 | 44 |
| 3 | Uvas | Verde | 12.5 | 15 |
| 4 | Platanos | Amarillo | 1.5 | 36 |
+----+----------+----------+--------+----------+
4 rows in set (0.00 sec)

MariaDB [Prueba1]> UPDATE Inv_fruta SET cantidad = cantidad - 1 WHERE id = 1;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [Prueba1]> SELECT * FROM Inv_fruta;
+----+----------+----------+--------+----------+
| id | nombre | color | precio | cantidad |
+----+----------+----------+--------+----------+
| 1 | Manzanas | Rojo | 5 | 24 |
| 2 | Naranjas | Anaranja | 7.5 | 44 |
| 3 | Uvas | Verde | 12.5 | 15 |
| 4 | Platanos | Amarillo | 1.5 | 36 |
+----+----------+----------+--------+----------+
4 rows in set (0.00 sec)

MariaDB [Prueba1]> SELECT * FROM Est_fruta;
+----+----------+--------+
| id | nombre | estado |
+----+----------+--------+
| 1 | Manzanas | Maduro |
| 2 | Naranjas | Maduro |
| 3 | Uvas | Maduro |
| 4 | Platanos | Maduro |
| 5 | Sandia | Maduro |
+----+----------+--------+
5 rows in set (0.00 sec)

MariaDB [Prueba1]> UPDATE Est_fruta SET estado = 'Podrido' WHERE id = 3;
Query OK, 1 row affected (0.07 sec)
Rows matched: 1 Changed: 1 Warnings: 0

</syntaxhighlight>

= Replace =

<syntaxhighlight lang="sql" line="GESHI_FANCY_LINE_NUMBERS">

MariaDB [Prueba1]> REPLACE INTO Inv_fruta VALUES ( 3, 'Uvas', 'Purple', 12.0, 15 );
Query OK, 2 rows affected (0.05 sec)

REPLACE no es ANSI

MariaDB [Prueba1]> SELECT * FROM Inv_fruta;
+----+----------+----------+--------+----------+
| id | nombre | color | precio | cantidad |
+----+----------+----------+--------+----------+
| 1 | Manzanas | Rojo | 5 | 24 |
| 2 | Naranjas | Anaranja | 7.5 | 44 |
| 3 | Uvas | Purple | 12 | 15 |
| 4 | Platanos | Amarillo | 1.5 | 36 |
+----+----------+----------+--------+----------+
4 rows in set (0.00 sec)

MariaDB [Prueba1]> REPLACE INTO Inv_fruta VALUES ( 5, 'Manzanas', 'Verde', 5.0, 60 );
Query OK, 1 row affected (0.04 sec)

MariaDB [Prueba1]> SELECT * FROM Inv_fruta;
+----+----------+----------+--------+----------+
| id | nombre | color | precio | cantidad |
+----+----------+----------+--------+----------+
| 1 | Manzanas | Rojo | 5 | 24 |
| 2 | Naranjas | Anaranja | 7.5 | 44 |
| 3 | Uvas | Purple | 12 | 15 |
| 4 | Platanos | Amarillo | 1.5 | 36 |
| 5 | Manzanas | Verde | 5 | 60 |
+----+----------+----------+--------+----------+
5 rows in set (0.00 sec)

</syntaxhighlight>

= Delete =

<syntaxhighlight lang="sql" line="GESHI_FANCY_LINE_NUMBERS">

MariaDB [Prueba1]> SELECT * FROM color;
+----+----------+
| id | nombre |
+----+----------+
| 1 | Rojo |
| 2 | naranja |
| 3 | Purpura |
| 4 | Amarillo |
+----+----------+
4 rows in set (0.00 sec)

MariaDB [Prueba1]> DELETE FROM color;
Query OK, 4 rows affected (0.07 sec)

MariaDB [Prueba1]> SELECT * FROM color;
Empty set (0.00 sec)

MariaDB [Prueba1]> SELECT * FROM Est_fruta;
+----+----------+---------+
| id | nombre | estado |
+----+----------+---------+
| 1 | Manzanas | Maduro |
| 2 | Naranjas | Maduro |
| 3 | Uvas | Podrido |
| 4 | Platanos | Maduro |
| 5 | Sandia | Maduro |
+----+----------+---------+
5 rows in set (0.00 sec)

MariaDB [Prueba1]> DELETE FROM Est_fruta WHERE estado = 'Podrido';
Query OK, 1 row affected (0.03 sec)

MariaDB [Prueba1]> seMariaDB [Prueba1]> SELECT * FROM Est_fruta;
+----+----------+--------+
| id | nombre | estado |
+----+----------+--------+
| 1 | Manzanas | Maduro |
| 2 | Naranjas | Maduro |
| 4 | Platanos | Maduro |
| 5 | Sandia | Maduro |
+----+----------+--------+
4 rows in set (0.00 sec)

</syntaxhighlight>

[[Category:MariaDB Desde la Consola]]
[[Category: CursoMatiaDB]]

Curso de MariaDB Desde la Consola/Update Replace Delete - Historial de revisiones

Rrc en 18:51 23 oct 2015