Scribd
Upload
37 views11 pages

Practica 2

The document details the creation of MySQL databases and tables by a user. It shows the user connecting to MySQL, creating a database called "02_practica_nadia", and then creating several tables within that database to store student data. The tables have different fields like name, email, address etc. and some have constraints like primary keys added. Records are also inserted into some of the tables.

Uploaded by

Isabella Cárdenas Jimenez
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
37 views11 pages

Practica 2

The document details the creation of MySQL databases and tables by a user. It shows the user connecting to MySQL, creating a database called "02_practica_nadia", and then creating several tables within that database to store student data. The tables have different fields like name, email, address etc. and some have constraints like primary keys added. Records are also inserted into some of the tables.

Uploaded by

Isabella Cárdenas Jimenez
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 11

Microsoft Windows [Versión 10.0.22631.

3085]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\nadia>cd C:\xampp\mysql\bin

C:\xampp\mysql\bin>mysql -u root localhost


ERROR 1049 (42000): Unknown database 'localhost'

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.4.32-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database "02_practica_nadia";


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'"02_practica_nadia"' at line 1
MariaDB [(none)]> create database 02_practica_nadia;
Query OK, 1 row affected (0.010 sec)

MariaDB [(none)]> use 02_practica_nadia


Database changed
MariaDB [02_practica_nadia]> create table ALUMNO1
-> (id int,
-> passwordalumno varchar(30),
-> nombrealumno varchar(49),
-> appaternoalumno varchar(20),
-> apmaternoalumno varchar(20),
-> emailalumno varchar(30),
-> calleynumero varchar(30),
-> colonia varchar(30),
-> alcaldia varchar(30),
-> estado varchar(30),
-> pais varchar(39),
-> cp int,
-> telefonocasa varchar(30),
-> telefonomovil varchar(30));
Query OK, 0 rows affected (0.411 sec)

MariaDB [02_practica_nadia]> create table ALUMNO


-> (id int,
-> passwordalumno varchar(30),
-> nombrealumno varchar(49),
-> appaternoalumno varchar(20),
-> apmaternoalumno varchar(20),
-> emailalumno varchar(30),
-> calleynumero varchar(30),
-> colonia varchar(30),
-> alcaldia enum('MILPA ALTA','XOCHIMILCO','TLAHUAC','TLALPAN'),
-> estado varchar(30),
-> pais varchar(39),
-> cp int,
-> telefonocasa varchar(30),
-> telefonomovil varchar(30));
Query OK, 0 rows affected (0.873 sec)

MariaDB [02_practica_nadia]> describe alumno


-> ;
+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
| Field | Type
| Null | Key | Default | Extra |
+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
| id | int(11)
| YES | | NULL | |
| passwordalumno | varchar(30)
| YES | | NULL | |
| nombrealumno | varchar(49)
| YES | | NULL | |
| appaternoalumno | varchar(20)
| YES | | NULL | |
| apmaternoalumno | varchar(20)
| YES | | NULL | |
| emailalumno | varchar(30)
| YES | | NULL | |
| calleynumero | varchar(30)
| YES | | NULL | |
| colonia | varchar(30)
| YES | | NULL | |
| alcaldia | enum('MILPA ALTA','XOCHIMILCO','TLAHUAC','TLALPAN') | YES |
| NULL | |
| estado | varchar(30)
| YES (id int, ULL | |
| pais | varchar(39)
| YES | | NULL | |
| cp | int(11)
| YES | | NULL | |
| telefonocasa | varchar(30)
| YES | | NULL | |
| telefonomovil | varchar(30) | YES |
| NULL | |
+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
14 rows in set (0.048 sec)

MariaDB [02_practica_nadia]> create table ALUMNO2(id int,passwordalumno


varchar(30),nombrealumno varchar(49),appaternoalumno varchar(20),apmaternoalumno
varchar(20),emailalumno varchar(30),calleynumero varchar(30),colonia
varchar(30),alcaldia varchar(30),estado varchar(30),pais varchar(39),cp
int,telefonocasa varchar(30),telefonomovil varchar(30), unique(emailalumno));
Query OK, 0 rows affected (0.276 sec)

MariaDB [02_practica_nadia]> create table ALUMNO3(id int,passwordalumno


varchar(30),nombrealumno varchar(49),appaternoalumno varchar(20),apmaternoalumno
varchar(20),emailalumno varchar(30),calleynumero varchar(30),colonia
varchar(30),alcaldia varchar(30),estado varchar(30),pais varchar(39),cp
int,telefonocasa varchar(30),telefonomovil varchar(30), PRIMARY KEY
PK20(nombrealumno,emailalumno));
Query OK, 0 rows affected, 1 warning (0.356 sec)

MariaDB [02_practica_nadia]> drop table alumno1


-> ;
Query OK, 0 rows affected (0.393 sec)

MariaDB [02_practica_nadia]> create table ALUMNO4


-> (id int auto_increment,
-> passwordalumnoa varchar(30),
-> nombrealumnoa varchar(49),
-> appaternoalumnoa varchar(20),
-> apmaternoalumnoa varchar(20),
-> emailalumnoa varchar(30),
-> Ctrl-C -- exit!
Bye

C:\xampp\mysql\bin>use 02_practica_nadia
"use" no se reconoce como un comando interno o externo,
programa o archivo por lotes ejecutable.

C:\xampp\mysql\bin>myql -u root
"myql" no se reconoce como un comando interno o externo,
programa o archivo por lotes ejecutable.

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.4.32-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use 02_practica_nadia


Database changed
MariaDB [02_practica_nadia]> describe alumno2
-> ;
+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| passwordalumno | varchar(30) | YES | | NULL | |
| nombrealumno | varchar(49) | YES | | NULL | |
| appaternoalumno | varchar(20) | YES | | NULL | |
| apmaternoalumno | varchar(20) | YES | | NULL | |
| emailalumno | varchar(30) | YES | UNI | NULL | |
| calleynumero | varchar(30) | YES | | NULL | |
| colonia | varchar(30) | YES | | NULL | |
| alcaldia | varchar(30) | YES | | NULL | |
| estado | varchar(30) | YES | | NULL | |
| pais | varchar(39) | YES | | NULL | |
| cp | int(11) | YES | | NULL | |
| telefonocasa | varchar(30) | YES | | NULL | |
| telefonomovil | varchar(30) | YES | | NULL | |
+-----------------+-------------+------+-----+---------+-------+
14 rows in set (0.044 sec)

MariaDB [02_practica_nadia]> create table ALUMNO1


-> (id int auto_increment,
-> passwordalumnoa varchar(30),
-> nombrealumnoa varchar(49),
-> appaternoalumnoa varchar(20),
-> apmaternoalumnoa varchar(20),
-> emailalumnoa varchar(30),
-> calleynumeroa varchar(30),
-> coloniaa varchar(30),
-> alcaldiaa varchar(30),
-> estadoa varchar(30),
-> paisa varchar(39),
-> cpa int,
-> Ctrl-C -- exit!
Bye

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.4.32-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use 02_practica_nadia


Database changed

MariaDB [02_practica_nadia]> create table ALUMNO1(ida int auto_increment,


passwordalumnoa varchar(30), nombrealumnoa varchar(49), appaternoalumnoa
varchar(20), apmaternoalumnoa varchar(20),emailalumnoa varchar(30),calleynumeroa
varchar(30),coloniaa varchar(30),alcaldiaa varchar(30),estadoa varchar(30),paisa
varchar(39),cpa int,telefonocasaa varchar(30),telefonomovila varchar(30), primary
key pk20(ida));
Query OK, 0 rows affected, 1 warning (0.367 sec)

MariaDB [02_practica_nadia]> insert into alumno1


value(22,"abc123","nadia","cardenas","jimenez","nadiaisabelcardenasjimenez1234@gmai
l.com","general anaya #2","san antonio tecomitl",0,"ciudad de
mexico","mexico","12100","5554447102","5565432292");
Query OK, 1 row affected, 1 warning (0.813 sec)

MariaDB [02_practica_nadia]> insert into alumno2


value(22,"abc123","nadia","cardenas","jimenez","nadiaisabelcardenasjimenez1234@gmai
l.com","general anaya #2","san antonio tecomitl",0,"ciudad de
mexico","mexico","12100","5554447102","5565432292")
-> ;
Query OK, 1 row affected, 1 warning (0.080 sec)

MariaDB [02_practica_nadia]> insert into alumno2


value(22,"abc123","nadia","cardenas","jimenez","nadiaisabel1234@gmail.com","general
anaya #2","san antonio tecomitl",0,"ciudad de
mexico","mexico","12100","5554447102","5565432292");
Query OK, 1 row affected (0.421 sec)

MariaDB [02_practica_nadia]> describe alumno1


-> ;
+------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+----------------+
| ida | int(11) | NO | PRI | NULL | auto_increment |
| passwordalumnoa | varchar(30) | YES | | NULL | |
| nombrealumnoa | varchar(49) | YES | | NULL | |
| appaternoalumnoa | varchar(20) | YES | | NULL | |
| apmaternoalumnoa | varchar(20) | YES | | NULL | |
| emailalumnoa | varchar(30) | YES | | NULL | |
| calleynumeroa | varchar(30) | YES | | NULL | |
| coloniaa | varchar(30) | YES | | NULL | |
| alcaldiaa | varchar(30) | YES | | NULL | |
| estadoa | varchar(30) | YES | | NULL | |
| paisa | varchar(39) | YES | | NULL | |
| cpa | int(11) | YES | | NULL | |
| telefonocasaa | varchar(30) | YES | | NULL | |
| telefonomovila | varchar(30) | YES | | NULL | |
+------------------+-------------+------+-----+---------+----------------+
14 rows in set (0.132 sec)

MariaDB [02_practica_nadia]> insert into alumno1


value(23,"abc123","nadia","cardenas","jimenez","nadiaisabel1234@gmail.com","general
anaya #2","san antonio tecomitl",0,"ciudad de
mexico","mexico","12100","5554447102","5565432292");
Query OK, 1 row affected (0.178 sec)

MariaDB [02_practica_nadia]> describe alumno1


-> ;
+------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+----------------+
| ida | int(11) | NO | PRI | NULL | auto_increment |
| passwordalumnoa | varchar(30) | YES | | NULL | |
| nombrealumnoa | varchar(49) | YES | | NULL | |
| appaternoalumnoa | varchar(20) | YES | | NULL | |
| apmaternoalumnoa | varchar(20) | YES | | NULL | |
| emailalumnoa | varchar(30) | YES | | NULL | |
| calleynumeroa | varchar(30) | YES | | NULL | |
| coloniaa | varchar(30) | YES | | NULL | |
| alcaldiaa | varchar(30) | YES | | NULL | |
| estadoa | varchar(30) | YES | | NULL | |
| paisa | varchar(39) | YES | | NULL | |
| cpa | int(11) | YES | | NULL | |
| telefonocasaa | varchar(30) | YES | | NULL | |
| telefonomovila | varchar(30) | YES | | NULL | |
+------------------+-------------+------+-----+---------+----------------+
14 rows in set (10.453 sec)

MariaDB [02_practica_nadia]> describe alumno;


+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
| Field | Type | Null |
Key | Default | Extra |
+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
| id | int(11) | YES |
| NULL | |
| passwordalumno | varchar(30) | YES |
| NULL | |
| nombrealumno | varchar(49) | YES |
| NULL | |
| appaternoalumno | varchar(20) | YES |
| NULL | |
| apmaternoalumno | varchar(20) | YES |
| NULL | |
| emailalumno | varchar(30) | YES |
| NULL | |
| calleynumero | varchar(30) | YES |
| NULL | |
| colonia | varchar(30) | YES |
| NULL | |
| alcaldia | enum('MILPA ALTA','XOCHIMILCO','TLAHUAC','TLALPAN') | YES |
| NULL | |
| estado | varchar(30) | YES |
| NULL | |
| pais | varchar(39) | YES |
| NULL | |
| cp | int(11) | YES |
| NULL | |
| telefonocasa | varchar(30) | YES |
| NULL | |
| telefonomovil | varchar(30) | YES |
| NULL | |
+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
14 rows in set (0.187 sec)

MariaDB [02_practica_nadia]> describe alumno2;


+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| passwordalumno | varchar(30) | YES | | NULL | |
| nombrealumno | varchar(49) | YES | | NULL | |
| appaternoalumno | varchar(20) | YES | | NULL | |
| apmaternoalumno | varchar(20) | YES | | NULL | |
| emailalumno | varchar(30) | YES | UNI | NULL | |
| calleynumero | varchar(30) | YES | | NULL | |
| colonia | varchar(30) | YES | | NULL | |
| alcaldia | varchar(30) | YES | | NULL | |
| estado | varchar(30) | YES | | NULL | |
| pais | varchar(39) | YES | | NULL | |
| cp | int(11) | YES | | NULL | |
| telefonocasa | varchar(30) | YES | | NULL | |
| telefonomovil | varchar(30) | YES | | NULL | |
+-----------------+-------------+------+-----+---------+-------+
14 rows in set (0.028 sec)

MariaDB [02_practica_nadia]> describe alumno3;


+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| passwordalumno | varchar(30) | YES | | NULL | |
| nombrealumno | varchar(49) | NO | PRI | NULL | |
| appaternoalumno | varchar(20) | YES | | NULL | |
| apmaternoalumno | varchar(20) | YES | | NULL | |
| emailalumno | varchar(30) | NO | PRI | NULL | |
| calleynumero | varchar(30) | YES | | NULL | |
| colonia | varchar(30) | YES | | NULL | |
| alcaldia | varchar(30) | YES | | NULL | |
| estado | varchar(30) | YES | | NULL | |
| pais | varchar(39) | YES | | NULL | |
| cp | int(11) | YES | | NULL | |
| telefonocasa | varchar(30) | YES | | NULL | |
| telefonomovil | varchar(30) | YES | | NULL | |
+-----------------+-------------+------+-----+---------+-------+
14 rows in set (0.030 sec)

MariaDB [02_practica_nadia]> insert into alumno


value(22,"abc123","nadia","cardenas","jimenez","nadiaisabel1234@gmail.com","general
anaya #2","san antonio tecomitl",0,"ciudad de
mexico","mexico","12100","5554447102","5565432292");
Query OK, 1 row affected, 1 warning (0.769 sec)

MariaDB [02_practica_nadia]> describe alumno;


+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
| Field | Type | Null |
Key | Default | Extra |
+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
| id | int(11) | YES |
| NULL | |
| passwordalumno | varchar(30) | YES |
| NULL | |
| nombrealumno | varchar(49) | YES |
| NULL | |
| appaternoalumno | varchar(20) | YES |
| NULL | |
| apmaternoalumno | varchar(20) | YES |
| NULL | |
| emailalumno | varchar(30) | YES |
| NULL | |
| calleynumero | varchar(30) | YES |
| NULL | |
| colonia | varchar(30) | YES |
| NULL | |
| alcaldia | enum('MILPA ALTA','XOCHIMILCO','TLAHUAC','TLALPAN') | YES |
| NULL | |
| estado | varchar(30) | YES |
| NULL | |
| pais | varchar(39) | YES |
| NULL | |
| cp | int(11) | YES |
| NULL | |
| telefonocasa | varchar(30) | YES |
| NULL | |
| telefonomovil | varchar(30) | YES |
| NULL | |
+-----------------+-----------------------------------------------------+------
+-----+---------+-------+
14 rows in set (0.185 sec)

MariaDB [02_practica_nadia]> select * from alumno;


+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
| id | passwordalumno | nombrealumno | appaternoalumno | apmaternoalumno |
emailalumno | calleynumero | colonia | alcaldia |
estado | pais | cp | telefonocasa | telefonomovil |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | |
ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
1 row in set (0.002 sec)

MariaDB [02_practica_nadia]> select * from alumno1;


+-----+-----------------+---------------+------------------+------------------
+--------------------------------+------------------+----------------------
+-----------+------------------+--------+-------+---------------+----------------+
| ida | passwordalumnoa | nombrealumnoa | appaternoalumnoa | apmaternoalumnoa |
emailalumnoa | calleynumeroa | coloniaa |
alcaldiaa | estadoa | paisa | cpa | telefonocasaa | telefonomovila |
+-----+-----------------+---------------+------------------+------------------
+--------------------------------+------------------+----------------------
+-----------+------------------+--------+-------+---------------+----------------+
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabelcardenasjimenez1234 | general anaya #2 | san antonio tecomitl | 0
| ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
| 23 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | 0
| ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
+-----+-----------------+---------------+------------------+------------------
+--------------------------------+------------------+----------------------
+-----------+------------------+--------+-------+---------------+----------------+
2 rows in set (0.002 sec)

MariaDB [02_practica_nadia]> select * from alumno3;


Empty set (0.001 sec)

MariaDB [02_practica_nadia]> insert into alumno3


value(22,"abc123","nadia","cardenas","jimenez","nadiaisabel1234@gmail.com","general
anaya #2","san antonio tecomitl",0,"ciudad de
mexico","mexico","12100","5554447102","5565432292");
Query OK, 1 row affected (0.090 sec)

MariaDB [02_practica_nadia]> select * from alumno3;


+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
| id | passwordalumno | nombrealumno | appaternoalumno | apmaternoalumno |
emailalumno | calleynumero | colonia | alcaldia |
estado | pais | cp | telefonocasa | telefonomovil |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | 0 |
ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
1 row in set (0.001 sec)

MariaDB [02_practica_nadia]> insert into alumno3


value(30,"adbc123","diana","cardenas","jimenez","dianaguada98@gmail.com","general
anaya #2","san antonio tecomitl","MILPA ALTA","ciudad de
mexico","mexico","12100","5554447102","5565772292");
Query OK, 1 row affected (0.111 sec)

MariaDB [02_practica_nadia]> select * from alumno3;


+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+------------
+------------------+--------+-------+--------------+---------------+
| id | passwordalumno | nombrealumno | appaternoalumno | apmaternoalumno |
emailalumno | calleynumero | colonia | alcaldia |
estado | pais | cp | telefonocasa | telefonomovil |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+------------
+------------------+--------+-------+--------------+---------------+
| 30 | adbc123 | diana | cardenas | jimenez |
dianaguada98@gmail.com | general anaya #2 | san antonio tecomitl | MILPA ALTA |
ciudad de mexico | mexico | 12100 | 5554447102 | 5565772292 |
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | 0 |
ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+------------
+------------------+--------+-------+--------------+---------------+
2 rows in set (0.001 sec)

MariaDB [02_practica_nadia]> select * from alumno2;


+------+----------------+--------------+-----------------+-----------------
+--------------------------------+------------------+----------------------
+----------+------------------+--------+-------+--------------+---------------+
| id | passwordalumno | nombrealumno | appaternoalumno | apmaternoalumno |
emailalumno | calleynumero | colonia | alcaldia
| estado | pais | cp | telefonocasa | telefonomovil |
+------+----------------+--------------+-----------------+-----------------
+--------------------------------+------------------+----------------------
+----------+------------------+--------+-------+--------------+---------------+
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabelcardenasjimenez1234 | general anaya #2 | san antonio tecomitl | 0
| ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | 0
| ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
+------+----------------+--------------+-----------------+-----------------
+--------------------------------+------------------+----------------------
+----------+------------------+--------+-------+--------------+---------------+
2 rows in set (0.001 sec)

MariaDB [02_practica_nadia]> insert into alumno


value(32,"efd987","diana","cardenas","jimenez","dianaguada98@gmail.com","general
anaya #2","san antonio tecomitl",0,"ciudad de
mexico","mexico","12100","5554447102","5565772292");
Query OK, 1 row affected, 1 warning (0.153 sec)

MariaDB [02_practica_nadia]> select *from alumno;


+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
| id | passwordalumno | nombrealumno | appaternoalumno | apmaternoalumno |
emailalumno | calleynumero | colonia | alcaldia |
estado | pais | cp | telefonocasa | telefonomovil |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | |
ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
| 32 | efd987 | diana | cardenas | jimenez |
dianaguada98@gmail.com | general anaya #2 | san antonio tecomitl | |
ciudad de mexico | mexico | 12100 | 5554447102 | 5565772292 |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+----------
+------------------+--------+-------+--------------+---------------+
2 rows in set (0.001 sec)

MariaDB [02_practica_nadia]> select * from alumno1;


+-----+-----------------+---------------+------------------+------------------
+--------------------------------+------------------+----------------------
+-----------+------------------+--------+-------+---------------+----------------+
| ida | passwordalumnoa | nombrealumnoa | appaternoalumnoa | apmaternoalumnoa |
emailalumnoa | calleynumeroa | coloniaa |
alcaldiaa | estadoa | paisa | cpa | telefonocasaa | telefonomovila |
+-----+-----------------+---------------+------------------+------------------
+--------------------------------+------------------+----------------------
+-----------+------------------+--------+-------+---------------+----------------+
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabelcardenasjimenez1234 | general anaya #2 | san antonio tecomitl | 0
| ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
| 23 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | 0
| ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
+-----+-----------------+---------------+------------------+------------------
+--------------------------------+------------------+----------------------
+-----------+------------------+--------+-------+---------------+----------------+
2 rows in set (0.001 sec)

MariaDB [02_practica_nadia]> select * from alumno2;


+------+----------------+--------------+-----------------+-----------------
+--------------------------------+------------------+----------------------
+----------+------------------+--------+-------+--------------+---------------+
| id | passwordalumno | nombrealumno | appaternoalumno | apmaternoalumno |
emailalumno | calleynumero | colonia | alcaldia
| estado | pais | cp | telefonocasa | telefonomovil |
+------+----------------+--------------+-----------------+-----------------
+--------------------------------+------------------+----------------------
+----------+------------------+--------+-------+--------------+---------------+
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabelcardenasjimenez1234 | general anaya #2 | san antonio tecomitl | 0
| ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | 0
| ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
+------+----------------+--------------+-----------------+-----------------
+--------------------------------+------------------+----------------------
+----------+------------------+--------+-------+--------------+---------------+
2 rows in set (0.001 sec)

MariaDB [02_practica_nadia]> select * from alumno3;


+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+------------
+------------------+--------+-------+--------------+---------------+
| id | passwordalumno | nombrealumno | appaternoalumno | apmaternoalumno |
emailalumno | calleynumero | colonia | alcaldia |
estado | pais | cp | telefonocasa | telefonomovil |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+------------
+------------------+--------+-------+--------------+---------------+
| 30 | adbc123 | diana | cardenas | jimenez |
dianaguada98@gmail.com | general anaya #2 | san antonio tecomitl | MILPA ALTA |
ciudad de mexico | mexico | 12100 | 5554447102 | 5565772292 |
| 22 | abc123 | nadia | cardenas | jimenez |
nadiaisabel1234@gmail.com | general anaya #2 | san antonio tecomitl | 0 |
ciudad de mexico | mexico | 12100 | 5554447102 | 5565432292 |
+------+----------------+--------------+-----------------+-----------------
+---------------------------+------------------+----------------------+------------
+------------------+--------+-------+--------------+---------------+
2 rows in set (0.001 sec)

MariaDB [02_practica_nadia]>

EN ESTE CASO SE APLICARON DISTINTAS RESTRICCIONES PARA KA CREACION DE CADA TABLA,


EN SU MAXIMA APROVECHACION.
ANOTACIONES PERSONALES DE LOS COMANDOS.

You might also like