MariaDB [prestamos]> show tables; +---------------------+ | Tables_in_prestamos | +---------------------+ | cliente | | condicionesprestamo | | historialprestamo | | multas | | multprest | | pago | | planpago | | prestamo | | refclient | | referencias | +---------------------+ 10 rows in set (0.002 sec) MariaDB [prestamos]> describe cliente; +-----------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+--------------+------+-----+---------+-------+ | id_cliente | int(11) | NO | PRI | NULL | | | nombre | varchar(60) | NO | | NULL | | | apellidos | varchar(60) | NO | | NULL | | | telefono | varchar(15) | YES | | NULL | | | numero_identificacion | int(11) | NO | | NULL | | | direccion | varchar(200) | NO | | NULL | | +-----------------------+--------------+------+-----+---------+-------+ 6 rows in set (0.055 sec) MariaDB [prestamos]> describe condicionesprestamo; +------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------+------+-----+---------+-------+ | codigo_condicion | int(11) | NO | PRI | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | tasa_interes | int(2) | NO | | NULL | | | plazo_dias | int(11) | NO | | NULL | | +------------------+---------+------+-----+---------+-------+ 4 rows in set (0.054 sec) MariaDB [prestamos]> describehistorialprestamo; 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 'describehistorialprestamo' at line 1 MariaDB [prestamos]> describe historialprestamo; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | codigo_historial | int(11) | NO | PRI | NULL | | | id_cliente | int(11) | NO | MUL | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | estado_actual | varchar(100) | NO | | NULL | | | comentarios | varchar(100) | NO | | NULL | | +------------------+--------------+------+-----+---------+-------+ 5 rows in set (0.074 sec) MariaDB [prestamos]> describe multas; +-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | codigo_multa | int(11) | NO | PRI | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | fecha_multa | date | NO | | NULL | | | monto_multa | float | NO | | NULL | | | razon | varchar(100) | NO | | NULL | | | estado_multa | varchar(50) | NO | | NULL | | | id_cliente | int(11) | NO | MUL | NULL | | +-----------------+--------------+------+-----+---------+-------+ 7 rows in set (0.047 sec) MariaDB [prestamos]> describe multprest; +-----------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------+------+-----+---------+-------+ | codigo_prestamo | int(11) | NO | MUL | NULL | | | codigo_multa | int(11) | NO | MUL | NULL | | +-----------------+---------+------+-----+---------+-------+ 2 rows in set (0.044 sec) MariaDB [prestamos]> describe pago; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | codigo_pago | int(11) | NO | PRI | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | monto_pagado | float | NO | | NULL | | | fecha_pago | date | NO | | NULL | | | metodo_pago | varchar(20) | NO | | NULL | | | cuotas_restantes | int(11) | NO | | NULL | | +------------------+-------------+------+-----+---------+-------+ 6 rows in set (0.050 sec) MariaDB [prestamos]> describe planpago; +-----------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------+------+-----+---------+-------+ | codigo_plan | int(11) | NO | PRI | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | monto_cuota | float | NO | | NULL | | | cantidad_cuotas | int(5) | NO | | NULL | | +-----------------+---------+------+-----+---------+-------+ 4 rows in set (0.045 sec) MariaDB [prestamos]> describe prestamo; +-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | codigo_prestamo | int(11) | NO | PRI | NULL | | | id_cliente | int(11) | NO | MUL | NULL | | | monto_prestado | float | NO | | NULL | | | fecha_solicitud | date | NO | | NULL | | | estado | varchar(100) | NO | | NULL | | +-----------------+--------------+------+-----+---------+-------+ 5 rows in set (0.074 sec) MariaDB [prestamos]> describe refclient; +--------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------+------+-----+---------+-------+ | id_cliente | int(11) | NO | MUL | NULL | | | codigo_referencias | int(11) | NO | MUL | NULL | | +--------------------+---------+------+-----+---------+-------+ 2 rows in set (0.025 sec) MariaDB [prestamos]> describe referencias; +--------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+---------+-------+ | codigo_referencias | int(11) | NO | PRI | NULL | | | id_cliente | int(11) | NO | MUL | NULL | | | nombre_referente | varchar(60) | NO | | NULL | | | relacion | varchar(100) | NO | | NULL | | | telefono | int(11) | NO | | NULL | | +--------------------+--------------+------+-----+---------+-------+ 5 rows in set (0.036 sec) MariaDB [prestamos]> create table garantias -> (id_garantia int not null primary key, -> codigo_prestamo int not null, -> tipo_garantia varchar(50) not null, -> descripcion varchar(100) not null, -> valorEstimado decimal(10,2) not null, -> estado_garantia varchar(50) not null, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade); Query OK, 0 rows affected (0.052 sec) MariaDB [prestamos]> describe garantias; +-----------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------+------+-----+---------+-------+ | id_garantia | int(11) | NO | PRI | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | tipo_garantia | varchar(50) | NO | | NULL | | | descripcion | varchar(100) | NO | | NULL | | | valorEstimado | decimal(10,2) | NO | | NULL | | | estado_garantia | varchar(50) | NO | | NULL | | +-----------------+---------------+------+-----+---------+-------+ 6 rows in set (0.048 sec) MariaDB [prestamos]> create table renegociaciones -> (id_renegociacion int not null primary key, -> codigo_prestamo int not null, -> fecha_renegociacion date not null, -> nueva_tasainteres decimal (5,2) not null, -> nuevo_plazo int not null, -> observaciones varchar(100), -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade); Query OK, 0 rows affected (0.073 sec) MariaDB [prestamos]> describe renegociaciones; +---------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+-----+---------+-------+ | id_renegociacion | int(11) | NO | PRI | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | fecha_renegociacion | date | NO | | NULL | | | nueva_tasainteres | decimal(5,2) | NO | | NULL | | | nuevo_plazo | int(11) | NO | | NULL | | | observaciones | varchar(100) | YES | | NULL | | +---------------------+--------------+------+-----+---------+-------+ 6 rows in set (0.052 sec) MariaDB [prestamos]> create table cobradores -> (id_cobrador int not null primary key, -> codigo_prestamo int not null, -> nombre1 varchar(80) not null, -> nombre2 varchar(80), -> apellido1 varchar(80) not null, -> apellido2 varchar(80), -> ; 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 '' at line 7 MariaDB [prestamos]> create table zonas -> (id_municipio int not null primary key, -> nombre varchar(80) not null, -> id_cliente int not null, -> codigo_prestamo int not null, -> foreign key(id_cliente) references cliente(id_cliente) on delete cascade on update cascade, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade); Query OK, 0 rows affected (0.091 sec) MariaDB [prestamos]> describe zonas; +-----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+-------+ | id_municipio | int(11) | NO | PRI | NULL | | | nombre | varchar(80) | NO | | NULL | | | id_cliente | int(11) | NO | MUL | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+-------+ 4 rows in set (0.049 sec) MariaDB [prestamos]> create table cobradores -> (id_cobrador int not null primary key, -> nombre1 varchar(80) not null, -> nombre2 varchar(80), -> apellido1 varchar(80) not null, -> apellido2 varchar(80), -> codigo_prestamo int not null, -> id_municipio int not null, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade, -> foreign key(id_municipio) references zonas(id_municipio) on delete cascade on update cascade); Query OK, 0 rows affected (0.087 sec) MariaDB [prestamos]> describe cobradores; +-----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+-------+ | id_cobrador | int(11) | NO | PRI | NULL | | | nombre1 | varchar(80) | NO | | NULL | | | nombre2 | varchar(80) | YES | | NULL | | | apellido1 | varchar(80) | NO | | NULL | | | apellido2 | varchar(80) | YES | | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | id_municipio | int(11) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+-------+ 7 rows in set (0.050 sec) MariaDB [prestamos]> show tables; +---------------------+ | Tables_in_prestamos | +---------------------+ | cliente | | cobradores | | condicionesprestamo | | garantias | | historialprestamo | | multas | | multprest | | pago | | planpago | | prestamo | | refclient | | referencias | | renegociaciones | | zonas | +---------------------+ 14 rows in set (0.002 sec) MariaDB [prestamos]> select * from cliente; +------------+---------------+----------------+------------+-----------------------+----------------------+ | id_cliente | nombre | apellidos | telefono | numero_identificacion | direccion | +------------+---------------+----------------+------------+-----------------------+----------------------+ | 10 | Sandra Milena | S nchez L˘pez | 3012345678 | 187654321 | Itaguˇ | | 11 | Jorge | Mendoza | 3187654321 | 987654330 | San Antonio de Prado | | 20 | Fernando | G˘mez | 3045678910 | 187654322 | San Antonio de Prado | | 30 | Carlos Andr‚s | Gaviria Mesa | 3001234567 | 487654323 | San Antonio de Prado | | 40 | Laura | Cano | 3102345678 | 187654324 | Sabaneta | | 50 | Sara | Cardona Torres | 3123456789 | 487654325 | La Estrella | | 60 | Juan David | Garcˇa Posada | 3156789012 | 187654326 | Itaguˇ | | 70 | Marˇa In‚s | Betancur | 3198765432 | 187654327 | Sabaneta | | 80 | Claudia | Florez | 3112345678 | 487654328 | La estrella | | 90 | Luis | Piedrahita | 3134567890 | 187654329 | La estrella | +------------+---------------+----------------+------------+-----------------------+----------------------+ 10 rows in set (0.002 sec) MariaDB [prestamos]> select * from cobradores; Empty set (0.001 sec) MariaDB [prestamos]> select * from condiciones prestamo; ERROR 1146 (42S02): Table 'prestamos.condiciones' doesn't exist MariaDB [prestamos]> select * from condicionesprestamo; +------------------+-----------------+--------------+------------+ | codigo_condicion | codigo_prestamo | tasa_interes | plazo_dias | +------------------+-----------------+--------------+------------+ | 123 | 110 | 15 | 2 | | 212 | 660 | 15 | 2 | | 313 | 770 | 15 | 2 | | 321 | 550 | 15 | 2 | | 414 | 880 | 15 | 2 | | 456 | 111 | 15 | 2 | | 515 | 990 | 15 | 2 | | 654 | 440 | 15 | 2 | | 789 | 220 | 15 | 2 | | 987 | 330 | 15 | 2 | +------------------+-----------------+--------------+------------+ 10 rows in set (0.023 sec) MariaDB [prestamos]> select * from garantias; Empty set (0.001 sec) MariaDB [prestamos]> select * from historialprestamo; +------------------+------------+-----------------+---------------+----------------------------------------+ | codigo_historial | id_cliente | codigo_prestamo | estado_actual | comentarios | +------------------+------------+-----------------+---------------+----------------------------------------+ | 198 | 50 | 660 | En mora | Cliente en retraso de 2 meses | | 203 | 80 | 990 | Activo | Cliente en buen estado | | 221 | 40 | 550 | Activo | Cliente pagando pr‚stamo | | 286 | 10 | 110 | Activo | Cliente pagando pr‚stamo | | 301 | 10 | 110 | En mora | El cliente aun no ha realizado el pago | | 308 | 11 | 220 | Activo | Cliente pagando pr‚stamo | | 328 | 70 | 880 | Activo | Cliente pagando pr‚stamo | | 378 | 30 | 440 | Cerrado | Pr‚stamo pagado completamente | | 456 | 60 | 770 | Cerrado | Pr‚stamo pagado completamente | | 457 | 90 | 111 | Activo | Cliente pagando pr‚stamo | | 465 | 20 | 330 | Activo | Cliente en buen estado | +------------------+------------+-----------------+---------------+----------------------------------------+ 11 rows in set (0.023 sec) MariaDB [prestamos]> select * from multas; +--------------+-----------------+-------------+-------------+-----------------+--------------+------------+ | codigo_multa | codigo_prestamo | fecha_multa | monto_multa | razon | estado_multa | id_cliente | +--------------+-----------------+-------------+-------------+-----------------+--------------+------------+ | 199 | 660 | 2024-07-01 | 100000 | Retraso de pago | Pendiente | 50 | | 299 | 990 | 2024-10-01 | 150000 | Retraso de pago | Pendiente | 80 | | 399 | 550 | 2024-08-15 | 50000 | Pago tardˇo | Pagada | 40 | | 499 | 110 | 2024-04-25 | 20000 | Pago parcial | Pagada | 10 | | 599 | 220 | 2024-03-18 | 75000 | Retraso de pago | Pagada | 11 | | 699 | 880 | 2024-09-20 | 120000 | Retraso de pago | Pagada | 70 | | 799 | 111 | 2024-02-28 | 80000 | Pago tardˇo | Pendiente | 90 | +--------------+-----------------+-------------+-------------+-----------------+--------------+------------+ 7 rows in set (0.003 sec) MariaDB [prestamos]> select * from multprest; +-----------------+--------------+ | codigo_prestamo | codigo_multa | +-----------------+--------------+ | 660 | 199 | | 990 | 299 | | 550 | 399 | | 110 | 499 | | 220 | 599 | | 880 | 699 | | 111 | 799 | +-----------------+--------------+ 7 rows in set (0.023 sec) MariaDB [prestamos]> select * from pago; +-------------+-----------------+--------------+------------+---------------+------------------+ | codigo_pago | codigo_prestamo | monto_pagado | fecha_pago | metodo_pago | cuotas_restantes | +-------------+-----------------+--------------+------------+---------------+------------------+ | 1 | 110 | 143750 | 2024-10-15 | Efectivo | 1 | | 2 | 111 | 11500 | 2024-10-20 | Transferencia | 3 | | 3 | 220 | 383300 | 2024-10-01 | Efectivo | 5 | | 4 | 330 | 164285 | 2024-09-01 | Efectivo | 5 | | 5 | 440 | 129375 | 2024-09-10 | Efectivo | 0 | | 6 | 550 | 150000 | 2024-10-15 | Transferencia | 1 | | 7 | 660 | 246400 | 2024-08-15 | Transferencia | 8 | | 8 | 770 | 172500 | 2024-10-15 | Efectivo | 0 | | 9 | 880 | 268300 | 2024-09-15 | Transferencia | 10 | | 10 | 990 | 122600 | 2024-10-30 | Transferencia | 2 | +-------------+-----------------+--------------+------------+---------------+------------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> select * from planpago; +-------------+-----------------+-------------+-----------------+ | codigo_plan | codigo_prestamo | monto_cuota | cantidad_cuotas | +-------------+-----------------+-------------+-----------------+ | 1001 | 110 | 143750 | 4 | | 1101 | 111 | 11500 | 4 | | 2202 | 220 | 383300 | 6 | | 3303 | 330 | 164285 | 7 | | 4404 | 440 | 129375 | 4 | | 5505 | 550 | 150000 | 2 | | 6606 | 660 | 246400 | 7 | | 7707 | 770 | 172500 | 1 | | 8808 | 880 | 268300 | 15 | | 9909 | 990 | 122600 | 3 | +-------------+-----------------+-------------+-----------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> select * from prestamo; +-----------------+------------+----------------+-----------------+------------+ | codigo_prestamo | id_cliente | monto_prestado | fecha_solicitud | estado | +-----------------+------------+----------------+-----------------+------------+ | 110 | 10 | 500000 | 2024-05-15 | En mora | | 111 | 90 | 400000 | 2024-10-05 | Aprobado | | 220 | 11 | 2000000 | 2024-08-10 | Aprobado | | 330 | 20 | 1000000 | 2024-10-20 | En proceso | | 440 | 30 | 450000 | 2024-07-16 | Pagado | | 550 | 40 | 300000 | 2024-08-12 | Aprobado | | 660 | 50 | 1500000 | 2024-06-18 | En mora | | 770 | 60 | 150000 | 2024-07-25 | Pagado | | 880 | 70 | 3500000 | 2024-08-03 | Aprobado | | 990 | 80 | 320000 | 2024-10-25 | En proceso | +-----------------+------------+----------------+-----------------+------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> select * from refclient; +------------+--------------------+ | id_cliente | codigo_referencias | +------------+--------------------+ | 50 | 118 | | 80 | 222 | | 40 | 116 | | 10 | 112 | | 11 | 113 | | 70 | 221 | | 30 | 115 | | 60 | 119 | | 90 | 223 | | 20 | 114 | +------------+--------------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> select * from referencias; +--------------------+------------+----------------------+----------+------------+ | codigo_referencias | id_cliente | nombre_referente | relacion | telefono | +--------------------+------------+----------------------+----------+------------+ | 112 | 10 | Marˇa L˘pez | Amiga | 2147483647 | | 113 | 11 | Camilo Mendoza | Hermano | 2147483647 | | 114 | 20 | Lucˇa G˘mez | Madre | 2147483647 | | 115 | 30 | Felipe Garcˇa | Amigo | 2147483647 | | 116 | 40 | Alejandra Ruiz | Amiga | 2147483647 | | 117 | 40 | Manuel Soto | Tˇo | 2147483647 | | 118 | 50 | Elena Cardona Torres | Hermana | 2147483647 | | 119 | 60 | Juli n Posada | Primo | 2147483647 | | 221 | 70 | Valeria Gil Betancur | Hija | 2147483647 | | 222 | 80 | Miguel Dˇaz | Amigo | 2147483647 | | 223 | 90 | Vanesa Piedrahita | Prima | 2147483647 | +--------------------+------------+----------------------+----------+------------+ 11 rows in set (0.001 sec) MariaDB [prestamos]> select * from renegociaciones; Empty set (0.001 sec) MariaDB [prestamos]> select * from zonas; Empty set (0.001 sec) MariaDB [prestamos]> insert into zonas (id_zona, nombre, id_cliente, codigo_prestamo) values -> (1, 'Itagui', 10, 110), -> (2, 'San Antonio de Prado', 11, 220 ), -> (3, 'San Antonio de Prado', 20, 330), -> (4, 'San Antonio de Prado', 30, 440), -> (5, 'Sabaneta', 40, 550), -> (6, 'La Estrella', 50, 660), -> (7, 'Itagui', 60, 770), -> (8, 'Sabaneta', 70, 880), -> (9, 'La Estrella', 80, 990), -> (10, 'La Estrella', 90, 111); ERROR 1054 (42S22): Unknown column 'id_zona' in 'field list' MariaDB [prestamos]> insert into zonas (id_municipio, nombre, id_cliente, codigo_prestamo) values -> (1, 'Itagui', 10, 110), -> (2, 'San Antonio de Prado', 11, 220 ), -> (3, 'San Antonio de Prado', 20, 330), -> (4, 'San Antonio de Prado', 30, 440), -> (5, 'Sabaneta', 40, 550), -> (6, 'La Estrella', 50, 660), -> (7, 'Itagui', 60, 770), -> (8, 'Sabaneta', 70, 880), -> (9, 'La Estrella', 80, 990), -> (10, 'La Estrella', 90, 111); Query OK, 10 rows affected (0.038 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [prestamos]> select * from zonas; +--------------+----------------------+------------+-----------------+ | id_municipio | nombre | id_cliente | codigo_prestamo | +--------------+----------------------+------------+-----------------+ | 1 | Itagui | 10 | 110 | | 2 | San Antonio de Prado | 11 | 220 | | 3 | San Antonio de Prado | 20 | 330 | | 4 | San Antonio de Prado | 30 | 440 | | 5 | Sabaneta | 40 | 550 | | 6 | La Estrella | 50 | 660 | | 7 | Itagui | 60 | 770 | | 8 | Sabaneta | 70 | 880 | | 9 | La Estrella | 80 | 990 | | 10 | La Estrella | 90 | 111 | +--------------+----------------------+------------+-----------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> insert into garantias (id_garantia, codigo_prestamo, tipo_garantia, descripci˘n, valorEstimado, estado_garantia) values -> (1111,110, 'Electrodom‚stico', 'Horno Microondas', 650000, 'Disponible' ), -> (1212, 111, 'Tecnologˇa', 'Celular', 520000, 'En posesi˘n'), -> (1313, 220, 'Electrodom‚stico', 'Televisor', 2600000, 'En posesi˘n'), -> (1414, 330, 'Joyas', 'Cadenas y reloj', 1300000, 'En espera'), -> (1515, 440, 'Electrodom‚stico', 'Televisor', 585000, 'Devuelto'), -> (1616, 550, 'Tecnologˇa','Tablet', 390000, 'En posesi˘n'), -> (1717, 660, 'Transporte', 'Bicicleta',1950000, 'Disponible'), -> (1818, 770, 'Hogar', 'Olla arrocera ',195000, 'Devuelto'), -> (1919, 880, 'Transporte', 'Moto', 4550000, 'En posesi˘n'), -> (2020, 990, 'Tecnologˇa', 'Celular', 416000, 'En espera'); ERROR 1054 (42S22): Unknown column 'descripci˘n' in 'field list' MariaDB [prestamos]> insert into garantias (id_garantia, codigo_prestamo, tipo_garantia, descripcion, valorEstimado, estado_garantia) values -> (1111,110, 'Electrodom‚stico', 'Horno Microondas', 650000, 'Disponible' ), -> (1212, 111, 'Tecnologˇa', 'Celular', 520000, 'En posesi˘n'), -> (1313, 220, 'Electrodom‚stico', 'Televisor', 2600000, 'En posesi˘n'), -> (1414, 330, 'Joyas', 'Cadenas y reloj', 1300000, 'En espera'), -> (1515, 440, 'Electrodom‚stico', 'Televisor', 585000, 'Devuelto'), -> (1616, 550, 'Tecnologˇa','Tablet', 390000, 'En posesi˘n'), -> (1717, 660, 'Transporte', 'Bicicleta',1950000, 'Disponible'), -> (1818, 770, 'Hogar', 'Olla arrocera ',195000, 'Devuelto'), -> (1919, 880, 'Transporte', 'Moto', 4550000, 'En posesi˘n'), -> (2020, 990, 'Tecnologˇa', 'Celular', 416000, 'En espera'); Query OK, 10 rows affected (0.030 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [prestamos]> select * from garantias; +-------------+-----------------+------------------+------------------+---------------+-----------------+ | id_garantia | codigo_prestamo | tipo_garantia | descripcion | valorEstimado | estado_garantia | +-------------+-----------------+------------------+------------------+---------------+-----------------+ | 1111 | 110 | Electrodom‚stico | Horno Microondas | 650000.00 | Disponible | | 1212 | 111 | Tecnologˇa | Celular | 520000.00 | En posesi˘n | | 1313 | 220 | Electrodom‚stico | Televisor | 2600000.00 | En posesi˘n | | 1414 | 330 | Joyas | Cadenas y reloj | 1300000.00 | En espera | | 1515 | 440 | Electrodom‚stico | Televisor | 585000.00 | Devuelto | | 1616 | 550 | Tecnologˇa | Tablet | 390000.00 | En posesi˘n | | 1717 | 660 | Transporte | Bicicleta | 1950000.00 | Disponible | | 1818 | 770 | Hogar | Olla arrocera | 195000.00 | Devuelto | | 1919 | 880 | Transporte | Moto | 4550000.00 | En posesi˘n | | 2020 | 990 | Tecnologˇa | Celular | 416000.00 | En espera | +-------------+-----------------+------------------+------------------+---------------+-----------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> insert into renegociacion (id_renegociacion, codigo_prestamo, fecha_renegociacion, nueva_tasainteres, nuevo_plazo, observaciones) values -> (2121, 110, '2024-05-30', 15, 3, 'P‚rdida de empleo'), -> (2222, 110, '2024-06-15', 15, 2, 'Enfermedad'), -> (2323, 111, '2024-10-15', 15, 3, 'Retraso de pago'), -> (2424, 220 '2024-09-15', 15, 3, 'Deuda imprevista'), -> (2525, 330 '2024-11-05', 15,3, 'P‚rdida de empleo'), -> (2626, 440 '2024-08-30', 15, 3, 'Nuevo Pr‚stamo'), -> (2727, 440 '2024-10-15', 15,3, 'Emergencia familiar'), -> (2828, 660 '2024-08-15', 15, 3, 'Error en pago anterior'), -> (2929, 770, '2024-11-10', 15, 3, 'Reestructuraci˘n financiera'), -> (3030, 880, '2024-09-30', 15,3 , 'Retraso de pago'); 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 ''2024-09-15', 15, 3, 'Deuda imprevista'), (2525, 330 '2024-11-05', 15,3, 'P‚...' at line 5 MariaDB [prestamos]> insert into renegociacion (id_renegociacion, codigo_prestamo, fecha_renegociacion, nueva_tasainteres, nuevo_plazo, observaciones) values -> (2121, 110, '2024-05-30', 15, 3, 'P‚rdida de empleo'), -> (2222, 110, '2024-06-15', 15, 2, 'Enfermedad'), -> (2323, 111, '2024-10-15', 15, 3, 'Retraso de pago'), -> (2424, 220, '2024-09-15', 15, 3, 'Deuda imprevista'), -> (2525, 330, '2024-11-05', 15,3, 'P‚rdida de empleo'), -> (2626, 440, '2024-08-30', 15, 3, 'Nuevo Pr‚stamo'), -> (2727, 440, '2024-10-15', 15,3, 'Emergencia familiar'), -> (2828, 660, '2024-08-15', 15, 3, 'Error en pago anterior'), -> (2929, 770, '2024-11-10', 15, 3, 'Reestructuraci˘n financiera'), -> (3030, 880, '2024-09-30', 15,3 , 'Retraso de pago'); ERROR 1146 (42S02): Table 'prestamos.renegociacion' doesn't exist MariaDB [prestamos]> insert into renegociacions (id_renegociacion, codigo_prestamo, fecha_renegociacion, nueva_tasainteres, nuevo_plazo, observaciones) values -> (2121, 110, '2024-05-30', 15, 3, 'P‚rdida de empleo'), -> (2222, 110, '2024-06-15', 15, 2, 'Enfermedad'), -> (2323, 111, '2024-10-15', 15, 3, 'Retraso de pago'), -> (2424, 220, '2024-09-15', 15, 3, 'Deuda imprevista'), -> (2525, 330, '2024-11-05', 15,3, 'P‚rdida de empleo'), -> (2626, 440, '2024-08-30', 15, 3, 'Nuevo Pr‚stamo'), -> (2727, 440, '2024-10-15', 15,3, 'Emergencia familiar'), -> (2828, 660, '2024-08-15', 15, 3, 'Error en pago anterior'), -> (2929, 770, '2024-11-10', 15, 3, 'Reestructuraci˘n financiera'), -> (3030, 880, '2024-09-30', 15,3 , 'Retraso de pago'); ERROR 1146 (42S02): Table 'prestamos.renegociacions' doesn't exist MariaDB [prestamos]> insert into renegociaciones (id_renegociacion, codigo_prestamo, fecha_renegociacion, nueva_tasainteres, nuevo_plazo, observaciones) values -> (2121, 110, '2024-05-30', 15, 3, 'P‚rdida de empleo'), -> (2222, 110, '2024-06-15', 15, 2, 'Enfermedad'), -> (2323, 111, '2024-10-15', 15, 3, 'Retraso de pago'), -> (2424, 220, '2024-09-15', 15, 3, 'Deuda imprevista'), -> (2525, 330, '2024-11-05', 15,3, 'P‚rdida de empleo'), -> (2626, 440, '2024-08-30', 15, 3, 'Nuevo Pr‚stamo'), -> (2727, 440, '2024-10-15', 15,3, 'Emergencia familiar'), -> (2828, 660, '2024-08-15', 15, 3, 'Error en pago anterior'), -> (2929, 770, '2024-11-10', 15, 3, 'Reestructuraci˘n financiera'), -> (3030, 880, '2024-09-30', 15,3 , 'Retraso de pago'); Query OK, 10 rows affected (0.016 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [prestamos]> select * from renegociaciones; +------------------+-----------------+---------------------+-------------------+-------------+-----------------------------+ | id_renegociacion | codigo_prestamo | fecha_renegociacion | nueva_tasainteres | nuevo_plazo | observaciones | +------------------+-----------------+---------------------+-------------------+-------------+-----------------------------+ | 2121 | 110 | 2024-05-30 | 15.00 | 3 | P‚rdida de empleo | | 2222 | 110 | 2024-06-15 | 15.00 | 2 | Enfermedad | | 2323 | 111 | 2024-10-15 | 15.00 | 3 | Retraso de pago | | 2424 | 220 | 2024-09-15 | 15.00 | 3 | Deuda imprevista | | 2525 | 330 | 2024-11-05 | 15.00 | 3 | P‚rdida de empleo | | 2626 | 440 | 2024-08-30 | 15.00 | 3 | Nuevo Pr‚stamo | | 2727 | 440 | 2024-10-15 | 15.00 | 3 | Emergencia familiar | | 2828 | 660 | 2024-08-15 | 15.00 | 3 | Error en pago anterior | | 2929 | 770 | 2024-11-10 | 15.00 | 3 | Reestructuraci˘n financiera | | 3030 | 880 | 2024-09-30 | 15.00 | 3 | Retraso de pago | +------------------+-----------------+---------------------+-------------------+-------------+-----------------------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> update zonas set id_municipio = 1 where nombre = 'Itagui'; ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY' MariaDB [prestamos]> MariaDB [prestamos]> updatezonas set id_municipio = 2 where nombre = 'San Antonio de Prado'; 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 'updatezonas set id_municipio = 2 where nombre = 'San Antonio de Prado'' at line 1 MariaDB [prestamos]> MariaDB [prestamos]> update zonas set d_municipio = 3 where nombre = 'Sabaneta'; ERROR 1054 (42S22): Unknown column 'd_municipio' in 'field list' MariaDB [prestamos]> MariaDB [prestamos]> update zonas set id_municipio = 4 where nombre = 'La Estrella'; ERROR 1062 (23000): Duplicate entry '4' for key 'PRIMARY' MariaDB [prestamos]> update zonas set id_municipio = 1 where nombre = 'Itagui'; ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY' MariaDB [prestamos]> delete from zonas; Query OK, 10 rows affected (0.030 sec) MariaDB [prestamos]> insert into zonas (id_municipio, nombre, id_cliente, codigo_prestamo) values -> -> (1, 'Itagui', 10, 110), -> -> (2, 'San Antonio de Prado', 11, 220 ), -> -> (2, 'San Antonio de Prado', 20, 330), -> -> (2, 'San Antonio de Prado', 30, 440), -> -> (3, 'Sabaneta', 40, 550), -> -> (4, 'La Estrella', 50, 660), -> -> (1, 'Itagui', 60, 770), -> -> (3, 'Sabaneta', 70, 880), -> -> (4, 'La Estrella', 80, 990), -> -> (4, 'La Estrella', 90, 111); 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 '-> (1, 'Itagui', 10, 110), -> (2, 'San Antonio de Prado', 11, 220 ), ...' at line 2 MariaDB [prestamos]> insert into zonas (id_municipio, nombre, id_cliente, codigo_prestamo) values -> (1, 'Itagui', 10, 110), -> (2, 'San Antonio de Prado', 11, 220), -> (2, 'San Antonio de Prado', 20, 330), -> (2, 'San Antonio de Prado', 30, 440), -> (3, 'Sabaneta', 40, 550), -> (4, 'La Estrella', 50, 660), -> (1, 'Itagui', 60, 770), -> (3, 'Sabaneta', 70, 880), -> (4, 'La Estrella', 80, 990), -> (4, 'La Estrella', 90, 111); ERROR 1062 (23000): Duplicate entry '2' for key 'PRIMARY' MariaDB [prestamos]> alter table zonas drop primary key; ERROR 1025 (HY000): Error on rename of '.\prestamos\#sql-9a8_9' to '.\prestamos\zonas' (errno: 150 "Foreign key constraint is incorrectly formed") MariaDB [prestamos]> drop table if exists zonas; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails MariaDB [prestamos]> drop zonas; 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 'zonas' at line 1 MariaDB [prestamos]> drop table zonas; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails MariaDB [prestamos]> drop cobradores; 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 'cobradores' at line 1 MariaDB [prestamos]> drop table cobradores; Query OK, 0 rows affected (0.034 sec) MariaDB [prestamos]> drop table zonas; Query OK, 0 rows affected (0.038 sec) MariaDB [prestamos]> create table zonas -> (id_municipio int auo_increment not null primary key, -> nombre varchar(80) not null, -> id_cliente int not null, -> codigo_prestamo int not null, -> foreign key(id_cliente) references cliente(id_cliente) on delete cascade on update cascade, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade); 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 'not null primary key, nombre varchar(80) not null, id_cliente int not null,...' at line 2 MariaDB [prestamos]> create table zonas -> -> (id_municipio int auto_increment not null primary key, -> nombre varchar(80) not null, -> id_cliente int not null, -> codigo_prestamo int not null, -> foreign key(id_cliente) references cliente(id_cliente) on delete cascade on update cascade, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade); Query OK, 0 rows affected (0.058 sec) MariaDB [prestamos]> describe zonas; +-----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+----------------+ | id_municipio | int(11) | NO | PRI | NULL | auto_increment | | nombre | varchar(80) | NO | | NULL | | | id_cliente | int(11) | NO | MUL | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+----------------+ 4 rows in set (0.033 sec) MariaDB [prestamos]> create table cobradores -> (id_cobrador int not null primary key, -> nombre1 varchar(80) not null, -> nombre2 varchar(80), -> apellido1 varchar(80) not null, -> apellido2 varchar(80), -> codigo_prestamo int not null, -> id_municipio int not null, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade, -> foreign key(id_municipio) references zonas(id_municipio) on delete cascade on update cascade); Query OK, 0 rows affected (0.101 sec) MariaDB [prestamos]> describe cobradores; +-----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+-------+ | id_cobrador | int(11) | NO | PRI | NULL | | | nombre1 | varchar(80) | NO | | NULL | | | nombre2 | varchar(80) | YES | | NULL | | | apellido1 | varchar(80) | NO | | NULL | | | apellido2 | varchar(80) | YES | | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | id_municipio | int(11) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+-------+ 7 rows in set (0.049 sec) MariaDB [prestamos]> insert into zonas (id_municipio, nombre, id_cliente, codigo_prestamo) values -> -> (1, 'Itagui', 10, 110), -> -> (2, 'San Antonio de Prado', 11, 220 ), -> -> (2, 'San Antonio de Prado', 20, 330), -> -> (2, 'San Antonio de Prado', 30, 440), -> -> (3, 'Sabaneta', 40, 550), -> -> (4, 'La Estrella', 50, 660), -> -> (1, 'Itagui', 60, 770), -> -> (3, 'Sabaneta', 70, 880), -> -> (4, 'La Estrella', 80, 990), -> -> (4, 'La Estrella', 90, 111); 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 '-> (1, 'Itagui', 10, 110), -> (2, 'San Antonio de Prado', 11, 220 ), ...' at line 2 MariaDB [prestamos]> insert into zonas (id_municipio, nombre, id_cliente, codigo_prestamo) values -> (1, 'Itagui', 10, 110), -> (2, 'San Antonio de Prado', 11, 220), -> (2, 'San Antonio de Prado', 20, 330), -> (2, 'San Antonio de Prado', 30, 440), -> (3, 'Sabaneta', 40, 550), -> (4, 'La Estrella', 50, 660), -> (1, 'Itagui', 60, 770), -> (3, 'Sabaneta', 70, 880), -> (4, 'La Estrella', 80, 990), -> (4, 'La Estrella', 90, 111); ERROR 1062 (23000): Duplicate entry '2' for key 'PRIMARY' MariaDB [prestamos]> insert into zonas (nombre, id_cliente, codigo_prestamo) values -> ('Itagui', 10, 110), -> ('San Antonio de Prado', 11, 220), -> ('San Antonio de Prado', 20, 330), -> ('San Antonio de Prado', 30, 440), -> ('Sabaneta', 40, 550), -> ('La Estrella', 50, 660), -> ('Itagui', 60, 770), -> ('Sabaneta', 70, 880), -> ('La Estrella', 80, 990), -> ('La Estrella', 90, 111); Query OK, 10 rows affected (0.032 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [prestamos]> select * from zonas; +--------------+----------------------+------------+-----------------+ | id_municipio | nombre | id_cliente | codigo_prestamo | +--------------+----------------------+------------+-----------------+ | 3 | Itagui | 10 | 110 | | 4 | San Antonio de Prado | 11 | 220 | | 5 | San Antonio de Prado | 20 | 330 | | 6 | San Antonio de Prado | 30 | 440 | | 7 | Sabaneta | 40 | 550 | | 8 | La Estrella | 50 | 660 | | 9 | Itagui | 60 | 770 | | 10 | Sabaneta | 70 | 880 | | 11 | La Estrella | 80 | 990 | | 12 | La Estrella | 90 | 111 | +--------------+----------------------+------------+-----------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> drop table cobradores; Query OK, 0 rows affected (0.019 sec) MariaDB [prestamos]> drop table zonas; Query OK, 0 rows affected (0.033 sec) MariaDB [prestamos]> create table municipios -> (id_municipio int auto_increment not null primary key, -> nombre varchar(80) not null); Query OK, 0 rows affected (0.042 sec) MariaDB [prestamos]> create table zonas -> (id_zona int auto_increment not null primary key, -> id_municipio int not null, -> id_cliente int not null, -> codigo_prestamo int not not null, -> foreign key(id_municipio) references municipios(id_municipio) on delete cascade on update cascade, -> foreign key(id_cliente) references cliente(id_cliente) on delete cascade on update cascade, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade); 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 'not null, foreign key(id_municipio) references municipios(id_municipio) on de...' at line 5 MariaDB [prestamos]> create table zonas -> ( -> id_zona int auto_increment not null primary key, -> id_municipio int not null, -> id_cliente int not null, -> codigo_prestamo int not null, -> foreign key(id_municipio) references municipios(id_municipio) on delete cascade on update cascade, -> foreign key(id_cliente) references cliente(id_cliente) on delete cascade on update cascade, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade -> ); Query OK, 0 rows affected (0.093 sec) MariaDB [prestamos]> describe zonas; +-----------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------+------+-----+---------+----------------+ | id_zona | int(11) | NO | PRI | NULL | auto_increment | | id_municipio | int(11) | NO | MUL | NULL | | | id_cliente | int(11) | NO | MUL | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | +-----------------+---------+------+-----+---------+----------------+ 4 rows in set (0.066 sec) MariaDB [prestamos]> describe municipios -> ; +--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+----------------+ | id_municipio | int(11) | NO | PRI | NULL | auto_increment | | nombre | varchar(80) | NO | | NULL | | +--------------+-------------+------+-----+---------+----------------+ 2 rows in set (0.054 sec) MariaDB [prestamos]> create table cobradores -> (id_cobrador int not null primary key, -> nombre1 varchar(80) not null, -> nombre2 varchar(80), -> apellido1 varchar(80) not null, -> apellido2 varchar(80), -> codigo_prestamo int not null, -> id_municipio int not null, -> foreign key(codigo_prestamo) references prestamo(codigo_prestamo) on delete cascade on update cascade, -> foreign key(id_municipio) references municipios(id_municipio) on delete cascade on update cascade); Query OK, 0 rows affected (0.056 sec) MariaDB [prestamos]> describe cobradores; +-----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+-------+ | id_cobrador | int(11) | NO | PRI | NULL | | | nombre1 | varchar(80) | NO | | NULL | | | nombre2 | varchar(80) | YES | | NULL | | | apellido1 | varchar(80) | NO | | NULL | | | apellido2 | varchar(80) | YES | | NULL | | | codigo_prestamo | int(11) | NO | MUL | NULL | | | id_municipio | int(11) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+-------+ 7 rows in set (0.058 sec) MariaDB [prestamos]> insert into municipios (nombre) values -> ('Itagui'), ('San Antonio de Prado'), ('Sabaneta'), ('La Estrella'); Query OK, 4 rows affected (0.025 sec) Records: 4 Duplicates: 0 Warnings: 0 MariaDB [prestamos]> select * from municipios; +--------------+----------------------+ | id_municipio | nombre | +--------------+----------------------+ | 1 | Itagui | | 2 | San Antonio de Prado | | 3 | Sabaneta | | 4 | La Estrella | +--------------+----------------------+ 4 rows in set (0.001 sec) MariaDB [prestamos]> insert into cobradores (id_cobrador, nombre1, nombre2, apellido1, apellido2, codigo_prestamo,id_municipio) values -> (4040, 'Pedro', '', 'G˘mez', 'Salazar', 110, 1 ), -> (4141, 'Felipe', '', 'Cano', '', 111, 2 ), -> (4040, 'Pedro', '', 'G˘mez', 'Salazar', 220, 2 ), -> (4343, 'Andr‚s','', 'Jaramillo', 'Estrada', 330, 2 ), -> (4343, 'Andr‚s','', 'Jaramillo', 'Estrada', 440, 3 ), -> (4545, 'Sebasti n ', '', 'Cardona', 'L˘pez', 550, 4 ), -> (4141, 'Felipe', '', 'Cano', '', 660, 1 ), -> (4545, 'Sebasti n ', '', 'Cardona', 'L˘pez', 770, 3 ), -> (4545, 'Sebasti n ', '', 'Cardona', 'L˘pez', 880, 4 ), -> (4646, 'Kevin', '', 'Vanegas', 'Mesa', 990, 4 ); ERROR 1062 (23000): Duplicate entry '4040' for key 'PRIMARY' MariaDB [prestamos]> insert into cobradores (id_cobrador, nombre1, nombre2, apellido1, apellido2, codigo_prestamo,id_municipio) values -> (4040, 'Pedro', '', 'G˘mez', 'Salazar', 110, 1 ), -> (4141, 'Felipe', '', 'Cano', '', 111, 2 ), -> (4242, 'Juan', 'Jos‚', 'Florez', '', 220, 2 ), -> (4343, 'Andr‚s','', 'Jaramillo', 'Estrada', 330, 2 ), -> (4444, 'Camilo','', 'G˘mez', '', 440, 3 ), -> (4545, 'Sebasti n ', '', 'Cardona', 'L˘pez', 550, 4 ), -> (4646, 'Julian', '', 'Cano', 'Aristizabal', 660, 1 ), -> (4747, 'Jonathan ', '', 'Carmona', 'Gonzalez', 770, 3 ), -> (4848, 'Mateo', 'David', 'Quintero', '', 880, 4 ), -> (4949, 'Kevin', '', 'Vanegas', 'Mesa', 990, 4 ); Query OK, 10 rows affected (0.025 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [prestamos]> select * from cobradores; +-------------+------------+---------+-----------+-------------+-----------------+--------------+ | id_cobrador | nombre1 | nombre2 | apellido1 | apellido2 | codigo_prestamo | id_municipio | +-------------+------------+---------+-----------+-------------+-----------------+--------------+ | 4040 | Pedro | | G˘mez | Salazar | 110 | 1 | | 4141 | Felipe | | Cano | | 111 | 2 | | 4242 | Juan | Jos‚ | Florez | | 220 | 2 | | 4343 | Andr‚s | | Jaramillo | Estrada | 330 | 2 | | 4444 | Camilo | | G˘mez | | 440 | 3 | | 4545 | Sebasti n | | Cardona | L˘pez | 550 | 4 | | 4646 | Julian | | Cano | Aristizabal | 660 | 1 | | 4747 | Jonathan | | Carmona | Gonzalez | 770 | 3 | | 4848 | Mateo | David | Quintero | | 880 | 4 | | 4949 | Kevin | | Vanegas | Mesa | 990 | 4 | +-------------+------------+---------+-----------+-------------+-----------------+--------------+ 10 rows in set (0.001 sec) MariaDB [prestamos]> exit