PRÁCTICA 4
SQL
Fecha de entrega: 16 de Noviembre del
2022
Por: David Kaleb Real Haro
Registro: 20300663
Grupo: 5F1
CENTRO DE ENSEÑANZA
TECNICA INDUSTRIAL
PLANTEL COLOMOS
Carrera: Desarrollo de
Software.
ASIGNATURA: BASE DE
DATOS 1
MAESTRA: ISAAC
RODRIGUEZ KARLA ARELI
1.
MariaDB [(none)]> use ceti1;
Database changed
MariaDB [ceti1]>
2.
MariaDB [ceti1]> select Registro, Nombre, Apep,apem from alumno where(registro>20300663);
+----------+---------------------+-------------+-----------+
| Registro | Nombre | Apep | apem |
+----------+---------------------+-------------+-----------+
| 20300668 | Diego Antonio | Rodrieguez | Anguiano |
| 20300674 | Fernando | Garc?a | Apolinar |
| 20300680 | Daniel | Lopez | Aguilera |
| 20300685 | Gabriela Alejandra | Arias | G?mez |
| 20300692 | Francisco Emiliano | Jimenez | Mejorada |
| 20300694 | Gustavo Miguel | Sedano | Ruvalcaba |
| 20300696 | Isaac Daniel | Chavez | Mares |
| 20300697 | Diego | Romero | Corvera |
| 20300705 | Daniel | Atilano | Romero |
| 20300799 | Jared Emiliano | Due?as | Flores |
| 20300827 | Diego Emiliano | Gonzalez | Martinez |
| 20300846 | Arely Jazm?n | Zavala | Ulloa |
| 20300849 | Melanie Astrid | Mendoza | Gonz?lez |
+----------+---------------------+-------------+-----------+
13 rows in set (0.002 sec)
MariaDB [ceti1]>
3.
MariaDB [ceti1]> select Registro,Domicilio, Nombre, Apep,apem from alumno
where(registro>=20300663);
+----------+---------------------------------------------------+---------------------+-------------+-----------+
| Registro | Domicilio | Nombre | Apep | apem |
+----------+---------------------------------------------------+---------------------+-------------+-----------+
| 20300663 | 1475 Durazno | David Kaleb | Real | Haro |
| 20300668 | 1406 calle dos bocas | Diego Antonio | Rodrieguez | Anguiano |
| 20300674 | Avenida Del almendro #121 | Fernando | Garc?a | Apolinar |
| 20300680 | Cedro 1995 | Daniel | Lopez | Aguilera |
| 20300685 | Acatempan 2211 | Gabriela Alejandra | Arias | G?mez |
| 20300692 | AV C #832 | Francisco Emiliano | Jimenez | Mejorada |
| 20300694 | Paseo de las acacias 3059 | Gustavo Miguel | Sedano | Ruvalcaba
|
| 20300696 | La Condesa 1790 | Isaac Daniel | Chavez | Mares |
| 20300697 | Paseo del bosque 1398 | Diego | Romero | Corvera |
| 20300705 | Calle Laureles #2693 | Daniel | Atilano | Romero |
| 20300799 | Palermo. Cod. Belmonte. Calle barol. Interior 226 | Jared Emiliano | Due?as |
Flores |
| 20300827 | Ca?ada 189, int 13 | Diego Emiliano | Gonzalez | Martinez |
| 20300846 | Calle Zamia #13 | Arely Jazm?n | Zavala | Ulloa |
| 20300849 | Fr?as #1040 | Melanie Astrid | Mendoza | Gonz?lez |
+----------+---------------------------------------------------+---------------------+-------------+-----------+
14 rows in set (0.001 sec)
MariaDB [ceti1]>
4.
MariaDB [ceti1]> Update Alumno set nombre='Areli' where (registro=20300668);
Query OK, 1 row affected (0.017 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ceti1]>
5.
MariaDB [ceti1]> select count(registro) from alumno where (registro<20300663) and (carrera=3);
+-----------------+
| count(registro) |
+-----------------+
| 6|
+-----------------+
1 row in set (0.001 sec)
MariaDB [ceti1]>
6.
MariaDB [ceti1]> select* from municipio where (Pk_municipio) between 10 and 20;
+--------------+----------------------+
| PK_Municipio | Nombre |
+--------------+----------------------+
| 10 | Atemajac de Brizuela |
| 11 | Atengo |
| 12 | Atenguillo |
| 13 | Atotonilco el Alto |
| 14 | Atoyac |
| 15 | Autlan de Navarro |
| 16 | Ayotlan |
| 17 | Ayutla |
| 18 | La Barca |
| 19 | Bola?os |
| 20 | Cabo Corrientes |
+--------------+----------------------+
11 rows in set (0.001 sec)
MariaDB [ceti1]>
7.
MariaDB [ceti1]> select Registro, Nombre, Apep,apem from alumno where(registro!=20300663);
+----------+---------------------+-------------+------------+
| Registro | Nombre | Apep | apem |
+----------+---------------------+-------------+------------+
| 19300107 | Misael | Cueva | R?bago |
| 19300115 | Sergio Yael | Cruz | Navarro |
| 20100320 | Perla Dayane | Raygoza | Pineda |
| 20100338 | Osman Azael | Rizo | Bocanegra |
| 20100348 | Gabriel Nahum | Acosta | Villanueva |
| 20100351 | Victor maximiliano | Gonzalez | Rodriguez |
| 20300668 | Areli | Rodrieguez | Anguiano |
| 20300674 | Fernando | Garc?a | Apolinar |
| 20300680 | Daniel | Lopez | Aguilera |
| 20300685 | Gabriela Alejandra | Arias | G?mez |
| 20300692 | Francisco Emiliano | Jimenez | Mejorada |
| 20300694 | Gustavo Miguel | Sedano | Ruvalcaba |
| 20300696 | Isaac Daniel | Chavez | Mares |
| 20300697 | Diego | Romero | Corvera |
| 20300705 | Daniel | Atilano | Romero |
| 20300799 | Jared Emiliano | Due?as | Flores |
| 20300827 | Diego Emiliano | Gonzalez | Martinez |
| 20300846 | Arely Jazm?n | Zavala | Ulloa |
| 20300849 | Melanie Astrid | Mendoza | Gonz?lez |
+----------+---------------------+-------------+------------+
19 rows in set (0.001 sec)
MariaDB [ceti1]>
8.
MariaDB [ceti1]> select nombre from carrera where nombre like 'Tecnologo%';
+---------------------------------------------------+
| nombre |
+---------------------------------------------------+
| Tecnologo en Construccion |
| Tecnologo en Control Automatico e Instrumentacion |
| Tecnologo en Desarrollo de Software |
| Tecnologo en Electronica y Comunicaciones |
| Tecnologo en Electromecanica |
| Tecnologo en Maquinas Herramienta |
| Tecnologo en Mecanica Automotriz |
| Tecnologo Quimico en Farmacos |
| Tecnologo en Calidad Total y Productividad |
| Tecnologo en Desarrollo Electronico |
| Tecnologo en Quimico en Alimentos |
| Tecnologo en Quimico Industrial |
+---------------------------------------------------+
12 rows in set (0.001 sec)
MariaDB [ceti1]>
9.
MariaDB [ceti1]> select nombre from profesor where nombre like '%a';
+-------------+
| nombre |
+-------------+
| ALEJANDRA |
| SONIA ERIKA |
| MARINA |
| LORENA |
| ERIKA |
+-------------+
5 rows in set (0.000 sec)
MariaDB [ceti1]>
10.
MariaDB [ceti1]> select nombre from carrera where nombre like '%d%';
+----------------------------------------------------------+
| nombre |
+----------------------------------------------------------+
| Tecnologo en Desarrollo de Software |
| Tecnologo en Calidad Total y Productividad |
| Tecnologo en Desarrollo Electronico |
| Tecnologo en Quimico Industrial |
| Ingenieria en Dise?o electronico y sistemas inteligentes |
| Ingenieria Industrial |
| Ingenieria en Tecnologia de software |
| Ingenieria en Desarrollo de Software |
+----------------------------------------------------------+
8 rows in set (0.000 sec)
MariaDB [ceti1]>
11.
MariaDB [ceti1]> select apep from alumno where apep like 'R%l_';
+-------+
| apep |
+-------+
| Real |
+-------+
1 row in set (0.001 sec)
MariaDB [ceti1]>
12.
MariaDB [ceti1]> select*from alumno where (registro=20300668) or (registro=20300799);
+----------+-----------------+-------------+----------+------------+---------------------------------------------------+------
-----+---------+
| Registro | Nombre | ApeP | ApeM | Celular | Domicilio |
Municipio | Carrera |
+----------+-----------------+-------------+----------+------------+---------------------------------------------------+------
-----+---------+
| 20300668 | Areli | Rodrieguez | Anguiano | 3325202306 | 1406 calle dos bocas
| 39 | 3|
| 20300799 | Jared Emiliano | Due?as | Flores | 3320301314 | Palermo. Cod. Belmonte. Calle
barol. Interior 226 | 120 | 3|
+----------+-----------------+-------------+----------+------------+---------------------------------------------------+------
-----+---------+
2 rows in set (0.001 sec)
MariaDB [ceti1]>
13.
MariaDB [ceti1]> select*from profesor where (fk_academia=3) or (fk_academia=4);
+--------+----------------+-------------+--------------+-------------+
| Nomina | Nombre | ApeP | ApeM | FK_Academia |
+--------+----------------+-------------+--------------+-------------+
| 6 | SERGIO | DELGADO | BECERRA | 4|
| 7 | KARLA ARELI | RODRIGUEZ | ISAAC | 4|
| 9 | SERGIO ANTONIO | ROMAN | ELLERBRACKE | 4|
| 11 | JORGE | CAMPA | PAMPLONA | 3|
| 13 | SONIA ERIKA | DE LA TORRE | IBA?EZ | 4|
+--------+----------------+-------------+--------------+-------------+
5 rows in set (0.001 sec)
MariaDB [ceti1]>
14.
MariaDB [ceti1]> delete from municipio where (PK_municipio=23);
Query OK, 1 row affected (0.011 sec)
MariaDB [ceti1]>
15.
MariaDB [ceti1]> delete from calificacion where (calificacion<50);
Query OK, 10 rows affected (0.031 sec)
MariaDB [ceti1]>
16.
MariaDB [ceti1]> drop database ceti1;
Query OK, 7 rows affected (0.801 sec)
MariaDB [(none)]>
