MariaDB [(none)]> use AAplicacion_cadeenna; Database changed MariaDB [AAplicacion_cadeenna]> create table discente -> -> (Carnet varchar(12) not null, -> Nombre varchar(50) not null); Query OK, 0 rows affected (0.008 sec) MariaDB [AAplicacion_cadeenna]> show tables; +--------------------------------+ | Tables_in_aaplicacion_cadeenna | +--------------------------------+ | discente | +--------------------------------+ 1 row in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> describe discente; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | Carnet | varchar(12) | NO | | NULL | | | Nombre | varchar(50) | NO | | NULL | | +--------+-------------+------+-----+---------+-------+ 2 rows in set (0.013 sec) MariaDB [AAplicacion_cadeenna]> insert into discente(Carnet, Nombre)values('201126012075','ALVARADO RESTREPO ESTEBAN'), -> ('201110011075','ARENAS TAMAYO JOAN SEBASTIAN'), -> ('200910005075','BEDOYA BEDOYA DIEGO ALEXANDER'), -> ('201020006088','CARDONA CHICA DIEGO FERNANDO'), -> ('201116027075','CARMONA TABORDA JOHN ALEXANDER'), -> ('201320010075','CORREA CORREA ANGELICA MARIA'), -> ('201110016075','GOMEZ GOMEZ JULIO CESAR'), -> ('201110022075','HURTADO TAMAYO CARLOS ESTIBEN'), -> ('201220002075','LONDOĽO FONNEGRA JHONNY ALEXANDER'), -> ('201116037075','MANYOMA GARCIA HENSLLY'), -> ('201110020075','MARTINEZ VALENCIA JHON DENNIS'), -> ('201320021075','PEREZ YEISON FABIAN'), -> ('201220004088','SALAZAR BUSTAMANTE MERY JOHANNA'), -> ('201212005075','TORRES TONOCOLIA JENNIFER JULIETH'), -> ('201213002088','ZULUAGA LONDOĽO ANGELA CRISTINA'), -> ('201120011088','ASPRILLA LEUDO YILMAR'), -> ('201324002075','ASPRILLA MENA WALNHER YHAMYD'), -> ('201223000088','CALLE PUERTA LILIANA MARIA'), -> ('201210009088','COLLAZO PATIĽO ALEX FERNEY'), -> ('201224000088','GRANADA MESA VICTOR ALONSO'), -> ('201210005088','HERRERA CARDONA JUAN DANIEL'), -> ('201220016088','JARAMILLO CARDONA MARLON ALEXANDER'), -> ('201210043088','MARTINEZ VALENCIA JHONATAN ARLEY'), -> ('201210009075','MOSQUERA PALACIOS NELSON JHAIR'), -> ('201210007075','OCAMPO NARANJO LUIS FELIPE'), -> ('201210022088','OROZCO CARMONA DIDIER'), -> ('201222000075','RAMIREZ MONTOYA ANDRES'), -> ('201210012088','SALDARRIAGA ARAQUE ANDRES FELIPE'), -> ('201010002075','VANEGAS AGUDELO ETHAN ARLEY'), -> ('200910012075','ALZATE CARVAJAL RAFAEL ALEXANDER'), -> ('200910005075','BEDOYA BEDOYA DIEGO ALEXANDER'), -> ('201210030075','CAICEDO CABEZAS JOHE ALDREITH'), -> ('201126016075','MESA ROLDAN JAVIER ALBERTO'), -> ('201213000088','MONTOYA HENAO MARCELA'), -> ('201312004075','MUNERA CARDENAS JOHN JAIRO'), -> ('201320021075','PEREZ YEISON FABIAN'), -> ('201220022088','RAMIREZ MESA JULIAN ALBERTO'), -> ('201313006075','TEJADA CASTRO ANDRS FELIPE'), -> ('201212005075','TORRES TONOCOLIA JENNIFER JULIETH'), -> ('201220004075','VALLEJO MAZO PAOLA ANDREA'), -> ('200920001075','VARGAS ARTEAGA ALEXIS ALBERTO'), -> ('201212003075','ZAPATA ZUĽIGA ADRIANA PATRICIA'), -> ('201222005075','ANDRADE RIVERA JOHAN ALEXIS'), -> ('201310026075','ANGARITA TORRES IRAMA'), -> ('201312007075','CARO BEDOYA WALTER DAVIDSON'), -> ('201313001075','CUESTA CUERVO YURY LORENA'), -> ('201220006075','ECHAVARRIA RODRIGUEZ SANDRA MARIA'), -> ('201310008075','GIRALDO VERGARA YOLANDA MILENA'), -> ('201110017088','GRAJALES MUĽOZ VICTOR CAMILO'), -> ('201110005088','NARANJO DE LOS RIOS MONICA MARIA'), -> ('201214004075','RADA RODRIGUEZ SILVIO SEGUNDO'), -> ('201223003075','SERNA ESCOBAR JUAN CARLOS'), -> ('201222004075','VEGA MAZO OMAIRA MARIA'), -> ('200820040075','WALTON MAYA NATALIA MARIA'), -> ('200920009075','ATEHORTUA LONDOĽO JUAN CAMILO'), -> ('201220003075','BLANDON LONDOĽO CRISTIAN MAURICIO'), -> ('201020006088','CARDONA CHICA DIEGO FERNANDO'), -> ('201010005075','CASTRO HERNANDEZ MARIA CRISTINA'), -> ('201110019088','CASTRO NAVIA KARINA'), -> ('201020003088','CEBALLOS BETANCUR DANIEL STEVEN'), -> ('201110017088','GRAJALES MUĽOZ VICTOR CAMILO'), -> ('201222003075','RESTREPO GOMEZ RUBEN FERNANDO'), -> ('201110034075','RODRIGUEZ CARDONA YENY ANDREA'), -> ('201310016075','VALDERRAMA MAHECHA DIEGO ALEJANDRO'), -> ('201222007073','AREIZA VERA JOHN FREDY'), -> ('201110058073','BURGOS ECHEVERRY LISBETH'), -> ('201222008073','DOMINGUEZ GOMEZ LIBIA ESTELA'), -> ('201314005073','DURANGO RODRIGUEZ JESUS HUMBEIRO'); Query OK, 68 rows affected (0.010 sec) Records: 68 Duplicates: 0 Warnings: 0 MariaDB [AAplicacion_cadeenna]> select * from discente; +--------------+-------------------------------------+ | Carnet | Nombre | +--------------+-------------------------------------+ | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 201220002075 | LONDOĽO FONNEGRA JHONNY ALEXANDER | | 201116037075 | MANYOMA GARCIA HENSLLY | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201320021075 | PEREZ YEISON FABIAN | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201213002088 | ZULUAGA LONDOĽO ANGELA CRISTINA | | 201120011088 | ASPRILLA LEUDO YILMAR | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | | 201223000088 | CALLE PUERTA LILIANA MARIA | | 201210009088 | COLLAZO PATIĽO ALEX FERNEY | | 201224000088 | GRANADA MESA VICTOR ALONSO | | 201210005088 | HERRERA CARDONA JUAN DANIEL | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | | 201210022088 | OROZCO CARMONA DIDIER | | 201222000075 | RAMIREZ MONTOYA ANDRES | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | | 201213000088 | MONTOYA HENAO MARCELA | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | | 201320021075 | PEREZ YEISON FABIAN | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | | 201313006075 | TEJADA CASTRO ANDRS FELIPE | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 201212003075 | ZAPATA ZUĽIGA ADRIANA PATRICIA | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | | 201310026075 | ANGARITA TORRES IRAMA | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | | 201313001075 | CUESTA CUERVO YURY LORENA | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | | 201222004075 | VEGA MAZO OMAIRA MARIA | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | | 201220003075 | BLANDON LONDOĽO CRISTIAN MAURICIO | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | | 201110019088 | CASTRO NAVIA KARINA | | 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | | 201222007073 | AREIZA VERA JOHN FREDY | | 201110058073 | BURGOS ECHEVERRY LISBETH | | 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA | | 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO | +--------------+-------------------------------------+ 68 rows in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> insert into discente(Carnet, Nombre)values ('200910069073','FUENTES FLOREZ JESSICA VIVIANA'), -> ('201312008075','JARAMILLO LUIS FERNANDO'), -> ('201120004073','LOPERA GUTIERREZ ALBA MIREYLLE'), -> ('201120036073','MENA ARTEAGA JUAN NORBERTO'), -> ('201120028073','OSPINA DAVID DORA ALBA'), -> ('201214004075','RADA RODRIGUEZ SILVIO SEGUNDO'), -> ('200820036073','RIOS QUINCHIA TATIANA'), -> ('200920013073','SILVA ARIAS NANCY CRISTINA'), -> ('201312001088','VARELA BEDOYA DAISSY ANDREA') -> ('201324013073','VELEZ DIANA MARCELA'), -> ('200910007073','ZAPATA VALENCIA OLGA LUCIA'), -> ('201320024070','BOLAóO MADERA MAIRA MIRITH'), -> ('201320016070','GRISALES ISAZA PAOLA ANDREA'), -> ('201320005086','GUTTERREZ SEGURO BEATRIZ'), -> ('201320005073','HOYOS HENAO JORGE NILTON'), -> ('201320002073','LEON ESTEVEZ DEISY YOLIMA'), -> ('201320008060','LONDOóO MUóOZ MARISOL'), -> ('201320003072','LOPEZ BLANDON LUISA FERNANDA'), -> ('201320011073','LOPEZ JIMENEZ LILLYAM DE JESUS'), -> ('201320009070','MAZO MARIN ANA MARIA'), -> ('201320011059','MUóOZ LOPEZ JONATHATAN FELIPE'), -> ('201320013074','MURILLO MURILLO VIDAL CAMILO'), -> ('201320006073','RUIZ RIVERA ISABEL'), -> ('201320003070','TEJADA AGUIRRE ZAIRA CRISTINA'), -> ('201320013070','TIECK MACIAS NICOLAS'), -> ('201320006074','YEPES HENAO MONICA'); 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 '('201324013073','VELEZ DIANA MARCELA'), ('200910007073','ZAPATA VALENCIA OLGA...' at line 10 MariaDB [AAplicacion_cadeenna]> insert into discente(Carnet, Nombre)values('200910069073','FUENTES FLOREZ JESSICA VIVIANA'), -> ('201312008075','JARAMILLO LUIS FERNANDO'), -> ('201312008075','JARAMILLO LUIS FERNANDO'), -> ('201120004073','LOPERA GUTIERREZ ALBA MIREYLLE'), -> ('201120036073','MENA ARTEAGA JUAN NORBERTO'), -> ('201120028073','OSPINA DAVID DORA ALBA'), -> ('201214004075','RADA RODRIGUEZ SILVIO SEGUNDO'), -> ('200820036073','RIOS QUINCHIA TATIANA'), -> ('200920013073','SILVA ARIAS NANCY CRISTINA'), -> ('201312001088','VARELA BEDOYA DAISSY ANDREA') -> ('201324013073','VELEZ DIANA MARCELA'), -> ('200910007073','ZAPATA VALENCIA OLGA LUCIA'), -> ('201320024070','BOLAóO MADERA MAIRA MIRITH'), -> ('201320016070','GRISALES ISAZA PAOLA ANDREA'), -> ('201320005086','GUTTERREZ SEGURO BEATRIZ'), -> ('201320005073','HOYOS HENAO JORGE NILTON'), -> ('201320002073','LEON ESTEVEZ DEISY YOLIMA'), -> ('201320008060','LONDOóO MUóOZ MARISOL'), -> ('201320003072','LOPEZ BLANDON LUISA FERNANDA'), -> ('201320011073','LOPEZ JIMENEZ LILLYAM DE JESUS'), -> ('201320009070','MAZO MARIN ANA MARIA'), -> ('201320011059','MUóOZ LOPEZ JONATHATAN FELIPE'), -> ('201320013074','MURILLO MURILLO VIDAL CAMILO'), -> ('201320006073','RUIZ RIVERA ISABEL'), -> ('201320003070','TEJADA AGUIRRE ZAIRA CRISTINA'), -> ('201320013070','TIECK MACIAS NICOLAS'), -> ('201320006074','YEPES HENAO MONICA'); 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 '('201324013073','VELEZ DIANA MARCELA'), ('200910007073','ZAPATA VALENCIA OLGA...' at line 11 MariaDB [AAplicacion_cadeenna]> insert into discente(Carnet, Nombre)values('200910069073','FUENTES FLOREZ JESSICA VIVIANA'), -> ('201312008075','JARAMILLO LUIS FERNANDO'), -> ('201312008075','JARAMILLO LUIS FERNANDO'), -> ('201120004073','LOPERA GUTIERREZ ALBA MIREYLLE'), -> ('201120036073','MENA ARTEAGA JUAN NORBERTO'), -> ('201120028073','OSPINA DAVID DORA ALBA'), -> ('201214004075','RADA RODRIGUEZ SILVIO SEGUNDO'), -> ('200820036073','RIOS QUINCHIA TATIANA'), -> ('200920013073','SILVA ARIAS NANCY CRISTINA'), -> ('201312001088','VARELA BEDOYA DAISSY ANDREA'), -> ('201324013073','VELEZ DIANA MARCELA'), -> ('200910007073','ZAPATA VALENCIA OLGA LUCIA'), -> ('201320024070','BOLA˘O MADERA MAIRA MIRITH'), -> ('201320016070','GRISALES ISAZA PAOLA ANDREA'), -> ('201320005086','GUTTERREZ SEGURO BEATRIZ'), -> ('201320005073','HOYOS HENAO JORGE NILTON'), -> ('201320002073','LEON ESTEVEZ DEISY YOLIMA'), -> ('201320008060','LONDO˘O MU˘OZ MARISOL'), -> ('201320003072','LOPEZ BLANDON LUISA FERNANDA'), -> ('201320011073','LOPEZ JIMENEZ LILLYAM DE JESUS'), -> ('201320009070','MAZO MARIN ANA MARIA'), -> ('201320011059','MU˘OZ LOPEZ JONATHATAN FELIPE'), -> ('201320013074','MURILLO MURILLO VIDAL CAMILO'), -> ('201320006073','RUIZ RIVERA ISABEL'), -> ('201320003070','TEJADA AGUIRRE ZAIRA CRISTINA'), -> ('201320013070','TIECK MACIAS NICOLAS'), -> ('201320006074','YEPES HENAO MONICA'); Query OK, 27 rows affected (0.004 sec) Records: 27 Duplicates: 0 Warnings: 0 MariaDB [AAplicacion_cadeenna]> select * from discente; +--------------+-------------------------------------+ | Carnet | Nombre | +--------------+-------------------------------------+ | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 201220002075 | LONDOĽO FONNEGRA JHONNY ALEXANDER | | 201116037075 | MANYOMA GARCIA HENSLLY | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201320021075 | PEREZ YEISON FABIAN | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201213002088 | ZULUAGA LONDOĽO ANGELA CRISTINA | | 201120011088 | ASPRILLA LEUDO YILMAR | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | | 201223000088 | CALLE PUERTA LILIANA MARIA | | 201210009088 | COLLAZO PATIĽO ALEX FERNEY | | 201224000088 | GRANADA MESA VICTOR ALONSO | | 201210005088 | HERRERA CARDONA JUAN DANIEL | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | | 201210022088 | OROZCO CARMONA DIDIER | | 201222000075 | RAMIREZ MONTOYA ANDRES | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | | 201213000088 | MONTOYA HENAO MARCELA | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | | 201320021075 | PEREZ YEISON FABIAN | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | | 201313006075 | TEJADA CASTRO ANDRS FELIPE | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 201212003075 | ZAPATA ZUĽIGA ADRIANA PATRICIA | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | | 201310026075 | ANGARITA TORRES IRAMA | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | | 201313001075 | CUESTA CUERVO YURY LORENA | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | | 201222004075 | VEGA MAZO OMAIRA MARIA | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | | 201220003075 | BLANDON LONDOĽO CRISTIAN MAURICIO | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | | 201110019088 | CASTRO NAVIA KARINA | | 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | | 201222007073 | AREIZA VERA JOHN FREDY | | 201110058073 | BURGOS ECHEVERRY LISBETH | | 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA | | 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE | | 201120036073 | MENA ARTEAGA JUAN NORBERTO | | 201120028073 | OSPINA DAVID DORA ALBA | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 200820036073 | RIOS QUINCHIA TATIANA | | 200920013073 | SILVA ARIAS NANCY CRISTINA | | 201312001088 | VARELA BEDOYA DAISSY ANDREA | | 201324013073 | VELEZ DIANA MARCELA | | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | | 201320024070 | BOLA˘O MADERA MAIRA MIRITH | | 201320016070 | GRISALES ISAZA PAOLA ANDREA | | 201320005086 | GUTTERREZ SEGURO BEATRIZ | | 201320005073 | HOYOS HENAO JORGE NILTON | | 201320002073 | LEON ESTEVEZ DEISY YOLIMA | | 201320008060 | LONDO˘O MU˘OZ MARISOL | | 201320003072 | LOPEZ BLANDON LUISA FERNANDA | | 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS | | 201320009070 | MAZO MARIN ANA MARIA | | 201320011059 | MU˘OZ LOPEZ JONATHATAN FELIPE | | 201320013074 | MURILLO MURILLO VIDAL CAMILO | | 201320006073 | RUIZ RIVERA ISABEL | | 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA | | 201320013070 | TIECK MACIAS NICOLAS | | 201320006074 | YEPES HENAO MONICA | +--------------+-------------------------------------+ 95 rows in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> SELECT * FROM Discente -> WHERE SUBSTR(carnet, 6, 3) IN ('075', '088'); Empty set (0.001 sec) MariaDB [AAplicacion_cadeenna]> select carnet, nombre from discente where substr(carnet,10,3) in ('075','088'); +--------------+-------------------------------------+ | carnet | nombre | +--------------+-------------------------------------+ | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 201220002075 | LONDOĽO FONNEGRA JHONNY ALEXANDER | | 201116037075 | MANYOMA GARCIA HENSLLY | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201320021075 | PEREZ YEISON FABIAN | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201213002088 | ZULUAGA LONDOĽO ANGELA CRISTINA | | 201120011088 | ASPRILLA LEUDO YILMAR | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | | 201223000088 | CALLE PUERTA LILIANA MARIA | | 201210009088 | COLLAZO PATIĽO ALEX FERNEY | | 201224000088 | GRANADA MESA VICTOR ALONSO | | 201210005088 | HERRERA CARDONA JUAN DANIEL | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | | 201210022088 | OROZCO CARMONA DIDIER | | 201222000075 | RAMIREZ MONTOYA ANDRES | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | | 201213000088 | MONTOYA HENAO MARCELA | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | | 201320021075 | PEREZ YEISON FABIAN | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | | 201313006075 | TEJADA CASTRO ANDRS FELIPE | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 201212003075 | ZAPATA ZUĽIGA ADRIANA PATRICIA | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | | 201310026075 | ANGARITA TORRES IRAMA | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | | 201313001075 | CUESTA CUERVO YURY LORENA | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | | 201222004075 | VEGA MAZO OMAIRA MARIA | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | | 201220003075 | BLANDON LONDOĽO CRISTIAN MAURICIO | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | | 201110019088 | CASTRO NAVIA KARINA | | 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201312001088 | VARELA BEDOYA DAISSY ANDREA | +--------------+-------------------------------------+ 68 rows in set (0.000 sec) MariaDB [AAplicacion_cadeenna]> select Carnet, Nombre from discente where substr(Carnet,10,3) in ('075'); +--------------+-------------------------------------+ | Carnet | Nombre | +--------------+-------------------------------------+ | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 201220002075 | LONDOĽO FONNEGRA JHONNY ALEXANDER | | 201116037075 | MANYOMA GARCIA HENSLLY | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201320021075 | PEREZ YEISON FABIAN | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | | 201222000075 | RAMIREZ MONTOYA ANDRES | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | | 201320021075 | PEREZ YEISON FABIAN | | 201313006075 | TEJADA CASTRO ANDRS FELIPE | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 201212003075 | ZAPATA ZUĽIGA ADRIANA PATRICIA | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | | 201310026075 | ANGARITA TORRES IRAMA | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | | 201313001075 | CUESTA CUERVO YURY LORENA | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | | 201222004075 | VEGA MAZO OMAIRA MARIA | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | | 201220003075 | BLANDON LONDOĽO CRISTIAN MAURICIO | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | +--------------+-------------------------------------+ 47 rows in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> select COUNT(*) from discente where substr(Carnet,10,3) not in ('088'); +----------+ | COUNT(*) | +----------+ | 74 | +----------+ 1 row in set (0.000 sec) MariaDB [AAplicacion_cadeenna]> select COUNT(*) 'Iniciaron en 2012' from discente where substr(carnet,1,4) in ('2012'); +-------------------+ | Iniciaron en 2012 | +-------------------+ | 31 | +-------------------+ 1 row in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> select COUNT(*) 'Iniciaron Primer Semestre' from discente where substr(Carnet,5,1) in ('1'); +---------------------------+ | Iniciaron Primer Semestre | +---------------------------+ | 45 | +---------------------------+ 1 row in set (0.000 sec) MariaDB [AAplicacion_cadeenna]> select COUNT(*) 'Matriculados antes del 2013' from discente where substr(carnet,1,4) < ('2013'); +-----------------------------+ | Matriculados antes del 2013 | +-----------------------------+ | 64 | +-----------------------------+ 1 row in set (0.000 sec) MariaDB [AAplicacion_cadeenna]> select * from discente order by substr(carnet,1,4); +--------------+-------------------------------------+ | Carnet | Nombre | +--------------+-------------------------------------+ | 200820036073 | RIOS QUINCHIA TATIANA | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | | 200920013073 | SILVA ARIAS NANCY CRISTINA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | | 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE | | 201110019088 | CASTRO NAVIA KARINA | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | | 201116037075 | MANYOMA GARCIA HENSLLY | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201120028073 | OSPINA DAVID DORA ALBA | | 201120036073 | MENA ARTEAGA JUAN NORBERTO | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 201120011088 | ASPRILLA LEUDO YILMAR | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 201110058073 | BURGOS ECHEVERRY LISBETH | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | | 201222004075 | VEGA MAZO OMAIRA MARIA | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201220003075 | BLANDON LONDOĽO CRISTIAN MAURICIO | | 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA | | 201222007073 | AREIZA VERA JOHN FREDY | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | | 201222000075 | RAMIREZ MONTOYA ANDRES | | 201210022088 | OROZCO CARMONA DIDIER | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | | 201210005088 | HERRERA CARDONA JUAN DANIEL | | 201224000088 | GRANADA MESA VICTOR ALONSO | | 201210009088 | COLLAZO PATIĽO ALEX FERNEY | | 201213002088 | ZULUAGA LONDOĽO ANGELA CRISTINA | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | | 201213000088 | MONTOYA HENAO MARCELA | | 201220002075 | LONDOĽO FONNEGRA JHONNY ALEXANDER | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | | 201212003075 | ZAPATA ZUĽIGA ADRIANA PATRICIA | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201223000088 | CALLE PUERTA LILIANA MARIA | | 201320002073 | LEON ESTEVEZ DEISY YOLIMA | | 201320005086 | GUTTERREZ SEGURO BEATRIZ | | 201320005073 | HOYOS HENAO JORGE NILTON | | 201320016070 | GRISALES ISAZA PAOLA ANDREA | | 201320008060 | LONDO˘O MU˘OZ MARISOL | | 201320003072 | LOPEZ BLANDON LUISA FERNANDA | | 201320006074 | YEPES HENAO MONICA | | 201320013070 | TIECK MACIAS NICOLAS | | 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA | | 201320006073 | RUIZ RIVERA ISABEL | | 201320013074 | MURILLO MURILLO VIDAL CAMILO | | 201320011059 | MU˘OZ LOPEZ JONATHATAN FELIPE | | 201320009070 | MAZO MARIN ANA MARIA | | 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS | | 201320024070 | BOLA˘O MADERA MAIRA MIRITH | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201324013073 | VELEZ DIANA MARCELA | | 201313001075 | CUESTA CUERVO YURY LORENA | | 201313006075 | TEJADA CASTRO ANDRS FELIPE | | 201320021075 | PEREZ YEISON FABIAN | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | | 201310026075 | ANGARITA TORRES IRAMA | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | | 201320021075 | PEREZ YEISON FABIAN | | 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | | 201312001088 | VARELA BEDOYA DAISSY ANDREA | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | +--------------+-------------------------------------+ 95 rows in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> select carnet,nombre from discente where substr(carnet,10,3) in ('075') and substr(carnet,1,4) < ('2012'); +--------------+----------------------------------+ | carnet | nombre | +--------------+----------------------------------+ | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 201116037075 | MANYOMA GARCIA HENSLLY | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | +--------------+----------------------------------+ 17 rows in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> select min(substr(carnet,1,12)) from discente where substr(carnet,10,3) not in ('075','088'); +--------------------------+ | min(substr(carnet,1,12)) | +--------------------------+ | 200820036073 | +--------------------------+ 1 row in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> select carnet, nombre, if(carnet like '%088', '5% Descuento', 'No Descuento') 'Informaci˝n' from discente; +--------------+-------------------------------------+--------------+ | carnet | nombre | Informaci˝n | +--------------+-------------------------------------+--------------+ | 201126012075 | ALVARADO RESTREPO ESTEBAN | No Descuento | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | No Descuento | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | No Descuento | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | 5% Descuento | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | No Descuento | | 201320010075 | CORREA CORREA ANGELICA MARIA | No Descuento | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | No Descuento | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | No Descuento | | 201220002075 | LONDOĽO FONNEGRA JHONNY ALEXANDER | No Descuento | | 201116037075 | MANYOMA GARCIA HENSLLY | No Descuento | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | No Descuento | | 201320021075 | PEREZ YEISON FABIAN | No Descuento | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | 5% Descuento | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | No Descuento | | 201213002088 | ZULUAGA LONDOĽO ANGELA CRISTINA | 5% Descuento | | 201120011088 | ASPRILLA LEUDO YILMAR | 5% Descuento | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | No Descuento | | 201223000088 | CALLE PUERTA LILIANA MARIA | 5% Descuento | | 201210009088 | COLLAZO PATIĽO ALEX FERNEY | 5% Descuento | | 201224000088 | GRANADA MESA VICTOR ALONSO | 5% Descuento | | 201210005088 | HERRERA CARDONA JUAN DANIEL | 5% Descuento | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | 5% Descuento | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | 5% Descuento | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | No Descuento | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | No Descuento | | 201210022088 | OROZCO CARMONA DIDIER | 5% Descuento | | 201222000075 | RAMIREZ MONTOYA ANDRES | No Descuento | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | 5% Descuento | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | No Descuento | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | No Descuento | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | No Descuento | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | No Descuento | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | No Descuento | | 201213000088 | MONTOYA HENAO MARCELA | 5% Descuento | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | No Descuento | | 201320021075 | PEREZ YEISON FABIAN | No Descuento | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | 5% Descuento | | 201313006075 | TEJADA CASTRO ANDRS FELIPE | No Descuento | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | No Descuento | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | No Descuento | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | No Descuento | | 201212003075 | ZAPATA ZUĽIGA ADRIANA PATRICIA | No Descuento | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | No Descuento | | 201310026075 | ANGARITA TORRES IRAMA | No Descuento | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | No Descuento | | 201313001075 | CUESTA CUERVO YURY LORENA | No Descuento | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | No Descuento | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | No Descuento | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | 5% Descuento | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | 5% Descuento | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | No Descuento | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | No Descuento | | 201222004075 | VEGA MAZO OMAIRA MARIA | No Descuento | | 200820040075 | WALTON MAYA NATALIA MARIA | No Descuento | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | No Descuento | | 201220003075 | BLANDON LONDOĽO CRISTIAN MAURICIO | No Descuento | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | 5% Descuento | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | No Descuento | | 201110019088 | CASTRO NAVIA KARINA | 5% Descuento | | 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN | 5% Descuento | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | 5% Descuento | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | No Descuento | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | No Descuento | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | No Descuento | | 201222007073 | AREIZA VERA JOHN FREDY | No Descuento | | 201110058073 | BURGOS ECHEVERRY LISBETH | No Descuento | | 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA | No Descuento | | 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO | No Descuento | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | No Descuento | | 201312008075 | JARAMILLO LUIS FERNANDO | No Descuento | | 201312008075 | JARAMILLO LUIS FERNANDO | No Descuento | | 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE | No Descuento | | 201120036073 | MENA ARTEAGA JUAN NORBERTO | No Descuento | | 201120028073 | OSPINA DAVID DORA ALBA | No Descuento | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | No Descuento | | 200820036073 | RIOS QUINCHIA TATIANA | No Descuento | | 200920013073 | SILVA ARIAS NANCY CRISTINA | No Descuento | | 201312001088 | VARELA BEDOYA DAISSY ANDREA | 5% Descuento | | 201324013073 | VELEZ DIANA MARCELA | No Descuento | | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | No Descuento | | 201320024070 | BOLA˘O MADERA MAIRA MIRITH | No Descuento | | 201320016070 | GRISALES ISAZA PAOLA ANDREA | No Descuento | | 201320005086 | GUTTERREZ SEGURO BEATRIZ | No Descuento | | 201320005073 | HOYOS HENAO JORGE NILTON | No Descuento | | 201320002073 | LEON ESTEVEZ DEISY YOLIMA | No Descuento | | 201320008060 | LONDO˘O MU˘OZ MARISOL | No Descuento | | 201320003072 | LOPEZ BLANDON LUISA FERNANDA | No Descuento | | 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS | No Descuento | | 201320009070 | MAZO MARIN ANA MARIA | No Descuento | | 201320011059 | MU˘OZ LOPEZ JONATHATAN FELIPE | No Descuento | | 201320013074 | MURILLO MURILLO VIDAL CAMILO | No Descuento | | 201320006073 | RUIZ RIVERA ISABEL | No Descuento | | 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA | No Descuento | | 201320013070 | TIECK MACIAS NICOLAS | No Descuento | | 201320006074 | YEPES HENAO MONICA | No Descuento | +--------------+-------------------------------------+--------------+ 95 rows in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> select carnet, nombre, if(carnet like '%073', 'CONTADURIA', 'OTRA CARRERA') 'Informaci˝n' from discente; +--------------+-------------------------------------+--------------+ | carnet | nombre | Informaci˝n | +--------------+-------------------------------------+--------------+ | 201126012075 | ALVARADO RESTREPO ESTEBAN | OTRA CARRERA | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | OTRA CARRERA | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | OTRA CARRERA | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | OTRA CARRERA | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | OTRA CARRERA | | 201320010075 | CORREA CORREA ANGELICA MARIA | OTRA CARRERA | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | OTRA CARRERA | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | OTRA CARRERA | | 201220002075 | LONDOĽO FONNEGRA JHONNY ALEXANDER | OTRA CARRERA | | 201116037075 | MANYOMA GARCIA HENSLLY | OTRA CARRERA | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | OTRA CARRERA | | 201320021075 | PEREZ YEISON FABIAN | OTRA CARRERA | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | OTRA CARRERA | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | OTRA CARRERA | | 201213002088 | ZULUAGA LONDOĽO ANGELA CRISTINA | OTRA CARRERA | | 201120011088 | ASPRILLA LEUDO YILMAR | OTRA CARRERA | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | OTRA CARRERA | | 201223000088 | CALLE PUERTA LILIANA MARIA | OTRA CARRERA | | 201210009088 | COLLAZO PATIĽO ALEX FERNEY | OTRA CARRERA | | 201224000088 | GRANADA MESA VICTOR ALONSO | OTRA CARRERA | | 201210005088 | HERRERA CARDONA JUAN DANIEL | OTRA CARRERA | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | OTRA CARRERA | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | OTRA CARRERA | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | OTRA CARRERA | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | OTRA CARRERA | | 201210022088 | OROZCO CARMONA DIDIER | OTRA CARRERA | | 201222000075 | RAMIREZ MONTOYA ANDRES | OTRA CARRERA | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | OTRA CARRERA | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | OTRA CARRERA | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | OTRA CARRERA | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | OTRA CARRERA | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | OTRA CARRERA | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | OTRA CARRERA | | 201213000088 | MONTOYA HENAO MARCELA | OTRA CARRERA | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | OTRA CARRERA | | 201320021075 | PEREZ YEISON FABIAN | OTRA CARRERA | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | OTRA CARRERA | | 201313006075 | TEJADA CASTRO ANDRS FELIPE | OTRA CARRERA | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | OTRA CARRERA | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | OTRA CARRERA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | OTRA CARRERA | | 201212003075 | ZAPATA ZUĽIGA ADRIANA PATRICIA | OTRA CARRERA | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | OTRA CARRERA | | 201310026075 | ANGARITA TORRES IRAMA | OTRA CARRERA | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | OTRA CARRERA | | 201313001075 | CUESTA CUERVO YURY LORENA | OTRA CARRERA | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | OTRA CARRERA | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | OTRA CARRERA | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | OTRA CARRERA | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | OTRA CARRERA | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | OTRA CARRERA | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | OTRA CARRERA | | 201222004075 | VEGA MAZO OMAIRA MARIA | OTRA CARRERA | | 200820040075 | WALTON MAYA NATALIA MARIA | OTRA CARRERA | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | OTRA CARRERA | | 201220003075 | BLANDON LONDOĽO CRISTIAN MAURICIO | OTRA CARRERA | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | OTRA CARRERA | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | OTRA CARRERA | | 201110019088 | CASTRO NAVIA KARINA | OTRA CARRERA | | 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN | OTRA CARRERA | | 201110017088 | GRAJALES MUĽOZ VICTOR CAMILO | OTRA CARRERA | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | OTRA CARRERA | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | OTRA CARRERA | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | OTRA CARRERA | | 201222007073 | AREIZA VERA JOHN FREDY | CONTADURIA | | 201110058073 | BURGOS ECHEVERRY LISBETH | CONTADURIA | | 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA | CONTADURIA | | 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO | CONTADURIA | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | CONTADURIA | | 201312008075 | JARAMILLO LUIS FERNANDO | OTRA CARRERA | | 201312008075 | JARAMILLO LUIS FERNANDO | OTRA CARRERA | | 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE | CONTADURIA | | 201120036073 | MENA ARTEAGA JUAN NORBERTO | CONTADURIA | | 201120028073 | OSPINA DAVID DORA ALBA | CONTADURIA | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | OTRA CARRERA | | 200820036073 | RIOS QUINCHIA TATIANA | CONTADURIA | | 200920013073 | SILVA ARIAS NANCY CRISTINA | CONTADURIA | | 201312001088 | VARELA BEDOYA DAISSY ANDREA | OTRA CARRERA | | 201324013073 | VELEZ DIANA MARCELA | CONTADURIA | | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | CONTADURIA | | 201320024070 | BOLA˘O MADERA MAIRA MIRITH | OTRA CARRERA | | 201320016070 | GRISALES ISAZA PAOLA ANDREA | OTRA CARRERA | | 201320005086 | GUTTERREZ SEGURO BEATRIZ | OTRA CARRERA | | 201320005073 | HOYOS HENAO JORGE NILTON | CONTADURIA | | 201320002073 | LEON ESTEVEZ DEISY YOLIMA | CONTADURIA | | 201320008060 | LONDO˘O MU˘OZ MARISOL | OTRA CARRERA | | 201320003072 | LOPEZ BLANDON LUISA FERNANDA | OTRA CARRERA | | 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS | CONTADURIA | | 201320009070 | MAZO MARIN ANA MARIA | OTRA CARRERA | | 201320011059 | MU˘OZ LOPEZ JONATHATAN FELIPE | OTRA CARRERA | | 201320013074 | MURILLO MURILLO VIDAL CAMILO | OTRA CARRERA | | 201320006073 | RUIZ RIVERA ISABEL | CONTADURIA | | 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA | OTRA CARRERA | | 201320013070 | TIECK MACIAS NICOLAS | OTRA CARRERA | | 201320006074 | YEPES HENAO MONICA | OTRA CARRERA | +--------------+-------------------------------------+--------------+ 95 rows in set (0.000 sec) MariaDB [AAplicacion_cadeenna]> select * from discente where substr(carnet,10,3) in ('075') and nombre like '%i%'; +--------------+-------------------------------------+ | Carnet | Nombre | +--------------+-------------------------------------+ | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 201116037075 | MANYOMA GARCIA HENSLLY | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201320021075 | PEREZ YEISON FABIAN | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | | 201222000075 | RAMIREZ MONTOYA ANDRES | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | | 201320021075 | PEREZ YEISON FABIAN | | 201313006075 | TEJADA CASTRO ANDRS FELIPE | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 201212003075 | ZAPATA ZUĽIGA ADRIANA PATRICIA | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | | 201310026075 | ANGARITA TORRES IRAMA | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201222004075 | VEGA MAZO OMAIRA MARIA | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200920009075 | ATEHORTUA LONDOĽO JUAN CAMILO | | 201220003075 | BLANDON LONDOĽO CRISTIAN MAURICIO | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201312008075 | JARAMILLO LUIS FERNANDO | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | +--------------+-------------------------------------+ 38 rows in set (0.001 sec) MariaDB [AAplicacion_cadeenna]> mysqldump -B -uroot -p AAplicacion_cadena>C:\Users\haidi\OneDrive\Escritorio/BDParcial/cadena.sql ERROR: Unknown command '\U'. General information about MariaDB can be found at http://mariadb.org List of all client commands: Note that all text commands must be first on line and end with ';' ? (\?) Synonym for `help'. clear (\c) Clear the current input statement. connect (\r) Reconnect to the server. Optional arguments are db and host. delimiter (\d) Set statement delimiter. edit (\e) Edit command with $EDITOR. ego (\G) Send command to MariaDB server, display result vertically. exit (\q) Exit mysql. Same as quit. go (\g) Send command to MariaDB server. help (\h) Display this help. nopager (\n) Disable pager, print to stdout. notee (\t) Don't write into outfile. pager (\P) Set PAGER [to_pager]. Print the query results via PAGER. print (\p) Print current command. prompt (\R) Change your mysql prompt. quit (\q) Quit mysql. rehash (\#) Rebuild completion hash. source (\.) Execute an SQL script file. Takes a file name as an argument. status (\s) Get status information from the server. system (\!) Execute a system shell command. tee (\T) Set outfile [to_outfile]. Append everything into given outfile. use (\u) Use another database. Takes database name as argument. charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets. warnings (\W) Show warnings after every statement. nowarning (\w) Don't show warnings after every statement. For server side help, type 'help contents' -> mysqldump -B -uroot -p AAplicacion_cadena>C:/Users/haidi/OneDrive/Escritorio/BDParcial/cadena.sql -> mysqldump -B -uroot -p AAplicacion_cadeenna>c:/xampp/biblioteca.sql -> exit -> ; 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 'mysqldump -B -uroot -p AAplicacion_cadena>C:\Users mysqldump -B -uroot -p AAp...' at line 1 MariaDB [AAplicacion_cadeenna]> exit