CUsers SENADownloads Basesdatosciclis

C:\Users\SENA\Downloads\Basesdatosciclismo\backupBdClase_16.
sql
C:\Users\SENA\Downloads\Basesdatosciclismo
C:\Users\SENA\Downloads\Jugueteria\backup_jugueteria.sql
Setting environment for using XAMPP for Windows.

SENA@BOSAPRRDCFSD586 c:\xampp
# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 30
Server version: 10.4.28-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 Jugueteria_Nueva;

Query OK, 1 row affected (0.001 sec)
MariaDB [(none)]> exit

Bye
# mysql dump -u root -p JugueteriaPasoPaso >C:\Users\SENA\Downloads\Jugueteria\
Seguimiento.txt
# mysql -u root -p Jugueteria_Nueva < C:\Users\SENA\Downloads\Jugueteria\
backup_jugueteria.sql
Enter password:
#
# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 32
Server version: 10.4.28-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 Jugueteria_Nueva

Database changed
MariaDB [Jugueteria_Nueva]> show tables;
+----------------------------+
| Tables_in_jugueteria_nueva |
+----------------------------+
| cliente |
| empleado |
| fact_comp |
| fact_produc |
| fact_vent |
| factura |
| garantia |
| marca |
| pers_rol |
| persona |
| producto |
| proveedor |
| roles |
| tipdocu |
| tipoclte |
| tipoproduc |
+----------------------------+
16 rows in set (0.001 sec)
MariaDB [Jugueteria_Nueva]> insert into tipdocu

-> values('cc','cedula de ciudadania',1);

-> values('ce','cedula de extranjeria',1);

-> values('ti','tarjeta de identidad',1);

-> values('rut','registro unico tributario',1);
MariaDB [Jugueteria_Nueva]>
MariaDB [Jugueteria_Nueva]> select* from tipdocu;
+---------+---------------------------+----------------+
| tip_doc | descrip | estado_tip_doc |
+---------+---------------------------+----------------+
| cc | cedula de ciudadania | 1 |
| ce | cedula de extranjeria | 1 |
| rut | registro unico tributario | 1 |
| ti | tarjeta de identidad | 1 |
+---------+---------------------------+----------------+
MariaDB [Jugueteria_Nueva]> insert into roles
-> values('A','empleado');

-> values('B','proveedor');

-> values('C','cliente');
MariaDB [Jugueteria_Nueva]> select* from roles;
+---------+-------------+
| cod_rol | descrip_rol |
+---------+-------------+
| A | empleado |
| B | proveedor |
| C | cliente |
+---------+-------------+
MariaDB [Jugueteria_Nueva]> insert into tipoproduc
-> values(10,'cumpleaños',1);
Query OK, 1 row affected, 1 warning (0.001 sec)

-> values(11,'baby shower',2);

-> values(12,'grado',3);

-> values(13,'bautizo',4);

-> values(14,'primera comunion',5);

-> values (15,'toda ocasion',6);
MariaDB [Jugueteria_Nueva]> insert into garantia
-> values (21,'sin garantia');
MariaDB [Jugueteria_Nueva]> insert into garantia

-> values (22,'un dia');
MariaDB [Jugueteria_Nueva]> insert into marca
-> values (30,'nacional');
MariaDB [Jugueteria_Nueva]> insert into marca

-> values(31, 'importado');
MariaDB [Jugueteria_Nueva]> insert into tipoclte
-> values (40,'mayorista');
MariaDB [Jugueteria_Nueva]> insert into tipoclte

-> values (41,'minorista');
MariaDB [Jugueteria_Nueva]> insert into producto
-> values (20001,'GLOBO AZUL CELESTE PQT X 12
UND',4500,4000,100,50,200,30,22,10);
MariaDB [Jugueteria_Nueva]> insert into producto

-> values (20002,'GLOBO BURBUJA 18 PULG X UND',5000,3000,100,50,200,31,22,10),
-> (20003,'GLOBO CORAZON R12 PQT X 12 UND',8500,6000,100,50,200,31,22,10),
-> (20004,'GLOBO DORADO R12 METALIZADO PQT X 12
UND',5500,3000,100,50,200,30,22,10),
-> (20005,'GLOBO LETRA 80 CM UND',4500,3000,100,50,200,31,22,10),
-> (20006,'LETRERO FELIZ CUMPLEAÑOS UND',24000,20000,100,50,200,31,21,10),
-> (20007,'SERPENTINAS PQT X 3 UND',3000,2000,100,50,200,30,21,10),
-> (20008,'MANTEL FIESTA',7000,4000,100,50,200,30,21,10),
-> (20009,'PLATO DESECHABLE CUADRADO PQT X 8
UND',7500,5000,100,50,200,30,21,10),
-> (20010,'PLATO DESECHABLE REDONDO PQT X 8
UND',5000,3000,100,50,200,30,21,10),
-> (20011,'VASO DESECHABLE 9 ONZ PQT X 12 UND',3000,1500,100,50,200,30,21,10),
-> (20012,'PHOTOCALL EMOTICONES PQT X 6 UND',9500,5500,100,50,200,31,21,10),
-> (20013,'CONFETTI SPRAY UND',6000,4000,100,50,200,31,21,10),
-> (20014,'VELA VOLCAN UND',2000,1000,100,50,200,30,22,10);
Query OK, 13 rows affected, 1 warning (0.001 sec)
Records: 13 Duplicates: 0 Warnings: 1
MariaDB [Jugueteria_Nueva]> insert into persona
-> values (50,'cc','JUAN PABLO','RODRIGUEZ','CALLE
54',7223574,'JP@HOTMAIL.COM'),
-> (51,'ce','CARLOS ANDRES','RODRIGUEZ','CALLE 55',2098760,'CR@HOTMAIL.COM'),
-> (52,'ti','CLAUDIA LILIANA','PERES','CALLE 56',7774948,'CP@GMAIL.COM'),
-> (53,'ce','SOFIA','TORRES','CALLE 57',7316711,'ST@GMAIL.COM'),
-> (54,'cc','LEONARDO','PINEDA PERES','CALLE 58',7415623,'LP@GMAIL.COM'),
-> (55,'cc','LAURA LILIANA','PERES PINEDA','CALLE
59',3112025689,'LLP@HOTMAIL.COM'),
-> (56,'cc','FABIAN ANDRES','RODRIGUEZ','CALLE 60',3054123698,'FAR@GMAIL.COM'),
-> (57,'cc','CLAUDIA','MARTINEZ TORRES','CALLE
61',3002589654,'CTM@HOTMAIL.COM'),
-> (58,'ti','DIANA MILENA','TORRES TORRES','CALEE 62',2098563,'DMT@GMAIL.COM'),
-> (59,'cc','JAVIER LEONARDO','PINEDA URIBE','CALLE
63',3215478651,'JLP@GMAIL.COM'),
-> (60,'ce','MARLY','PERES','CALLE 64',7225698,'MP@HOTMAIL.COM'),
-> (61,'cc','SANDRA','TORRES PERES','CALLE 65',321587635,'STP@HOTMAIL.COM'),
-> (62,'cc','PEDRO JOSE','LINARES','CALLE 66',2986532,'PJL@GMAIL.COM');
Query OK, 13 rows affected, 4 warnings (0.004 sec)
MariaDB [Jugueteria_Nueva]> insert into persona

-> values(63,'cc','LAURA ANDREA','SANCHEZ','CALLE 67',2986539,'LAS@GMAIL.COM');
MariaDB [Jugueteria_Nueva]> insert into pers_rol
-> values (50,'cc','A',1);
-> values (51,'ce','B',1);
-> values (52,'ti','A',1);
-> values (53,'ce','C',1);
-> values (53,'ce','B',1);
-> values (54,'cc','C',1),
-> (55,'cc','C',1),
-> (56,'cc','B',1),
-> (57,'cc','C',1),
-> (58,'ti','C',1),
-> (59,'cc','C',1);
Query OK, 6 rows affected (0.001 sec)
-> values (60,'ce','C',1);
-> values (60,'ce','B',1);
-> values (61,'cc','A',1),
-> (62,'cc','A',1);
-> values (63,'cc','C',1);
MariaDB [Jugueteria_Nueva]> insert into factura
-> values (001,('2019/03/15'),58000,'16%',67280),
-> (002,('2019/03/15'),105500,'16%',122380),
-> (003,('2019-03-15'),126500,'16%',146740),
-> (004,('2019-03-15'),68500,'16%',79460),
-> (005,('2019-03-16'),188000,'16%',218080),
-> (006,('2019-03-16'),158500,'16%',183860),
-> (007,('2019-03-16'),202500,'16%',234900),
-> (008,('2019-03-16'),117000,'16%',135720),
-> (009,('2019-03-16'),190000,'16%',220400),
-> (010,('2019-03-16'),116000,'16%',134560),
-> (011,('2019-03-16'),101000,'16%',117160),
-> (012,('2019-03-16'),111000,'16%',128760);
MariaDB [Jugueteria_Nueva]> insert into empleado
-> values (50,'cc',1200000),
-> (52,'ti',1200000),
-> (61,'cc',1200000),
-> (62,'cc',1200000);
MariaDB [Jugueteria_Nueva]> insert into cliente
-> values (53,'ce',40);
-> values (54,'cc',41);
-> values (55,'cc',41);
-> values (57,'cc',40);

-> values (58,'ti',41);

-> values (59,'cc',40),
-> (60,'ce',41),
-> (63,'cc',40);
MariaDB [Jugueteria_Nueva]> insert into proveedor
-> values (51,'ce'),
-> (53,'ce'),
-> (56,'cc'),
-> (60,'ce');
MariaDB [Jugueteria_Nueva]> insert into fact_comp
-> values(009,'cc',50,51,'ce');

-> values (010,'ti',52,53,'ce');

-> values (011,'cc',61,56,'cc');

-> values (012,'cc',62,60,'ce');
MariaDB [Jugueteria_Nueva]> insert into fact_vent
-> values (001,'cc',50,53,'ce');
-> values (002,'cc',50,54,'cc');
-> values (003,'ti',52,55,'cc');
-> values (004,'ti',52,57,'cc');
MariaDB [Jugueteria_Nueva]> insert fact_vent
-> values (005,'cc',61,58,'ti');
-> values (006,'cc',61,59,'cc');
-> values (007,'cc',62,63,'cc');
-> values (008,'cc',62,63,'cc');
MariaDB [Jugueteria_Nueva]> insert into fact_produc
-> values (001,20001,2,9000);

-> values (001,20002,3,15000);

-> values (001,20003,4,34000);

-> values (002,20004,8,44000),
-> (002,20005,3,13500),
-> (002,20006,2,48000);

-> values (003,20007,8,24000),
-> (003,20008,5,35000),
-> (003,20009,9,67500);

-> values (004,20010,5,25000),
-> (004,20011,5,15000),
-> (004,20012,3,28500);
-> values (005,20001,8,36000),
-> (005,20002,8,40000),
-> (005,20003,8,68000),
-> (005,20004,8,44000);
-> values (006,20005,5,22500),
-> (006,20006,2,48000),
-> (006,20007,6,18000),
-> (006,20008,10,70000);
-> values (007,20009,10,75000),
-> (007,20010,10,50000),
-> (007,20011,10,30000),
-> (007,20012,5,47500);
-> values (008,20003,6,51000),
-> (008,20004,6,33000),
-> (008,20005,2,9000),
-> (008,20006,1,24000);
-> values (009,20001,10,40000),
-> (009,20002,10,30000),
-> (009,20003,10,60000),
-> (009,20004,10,30000),
-> (009,20005,10,30000);
-> values (010,20006,1,20000),
-> (010,20007,8,16000),
-> (010,20008,10,40000),
-> (010,20009,5,25000),
-> (010,20010,5,15000);
-> values (011,20011,10,15000),
-> (011,20012,8,44000),
-> (011,20013,5,20000),
-> (011,20014,2,2000),
-> (011,20001,5,20000);
-> values (012,20004,8,24000),
-> (012,20005,3,9000),
-> (012,20006,1,20000),
-> (012,20007,9,18000),
-> (012,20008,10,40000);
MariaDB [Jugueteria_Nueva]> select * from garantia;

+----------+--------------+
| id_garan | tiempo_garan |
+----------+--------------+
| 21 | sin garantia |
| 22 | un dia |
+----------+--------------+
MariaDB [Jugueteria_Nueva]> select * fraom producto;
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 'fraom
producto' at line 1
MariaDB [Jugueteria_Nueva]> select * from producto;
+---------------+------------------------------------------+-----------------
+------------------+-----------+---------+---------+-------+----------+----------+
| serial_produc | descrip_product | valor_unitventa |
valor_unitcompra | cantexist | cantmin | cantmax | marca | garantia | tiproduc |
+---------------+------------------------------------------+-----------------
+------------------+-----------+---------+---------+-------+----------+----------+
| 20001 | GLOBO AZUL CELESTE PQT X 12 UND | 4500 |
4000 | 100 | 50 | 200 | 30 | 22 | 10 |
| 20002 | GLOBO BURBUJA 18 PULG X UND | 5000 |
3000 | 100 | 50 | 200 | 31 | 22 | 10 |
| 20003 | GLOBO CORAZON R12 PQT X 12 UND | 8500 |
6000 | 100 | 50 | 200 | 31 | 22 | 10 |
| 20004 | GLOBO DORADO R12 METALIZADO PQT X 12 UND | 5500 |
3000 | 100 | 50 | 200 | 30 | 22 | 10 |
| 20005 | GLOBO LETRA 80 CM UND | 4500 |
3000 | 100 | 50 | 200 | 31 | 22 | 10 |
| 20006 | LETRERO FELIZ CUMPLEA?OS UND | 24000 |
20000 | 100 | 50 | 200 | 31 | 21 | 10 |
| 20007 | SERPENTINAS PQT X 3 UND | 3000 |
2000 | 100 | 50 | 200 | 30 | 21 | 10 |
| 20008 | MANTEL FIESTA | 7000 |
4000 | 100 | 50 | 200 | 30 | 21 | 10 |
| 20009 | PLATO DESECHABLE CUADRADO PQT X 8 UND | 7500 |
5000 | 100 | 50 | 200 | 30 | 21 | 10 |
| 20010 | PLATO DESECHABLE REDONDO PQT X 8 UND | 5000 |
3000 | 100 | 50 | 200 | 30 | 21 | 10 |
| 20011 | VASO DESECHABLE 9 ONZ PQT X 12 UND | 3000 |
1500 | 100 | 50 | 200 | 30 | 21 | 10 |
| 20012 | PHOTOCALL EMOTICONES PQT X 6 UND | 9500 |
5500 | 100 | 50 | 200 | 31 | 21 | 10 |
| 20013 | CONFETTI SPRAY UND | 6000 |
4000 | 100 | 50 | 200 | 31 | 21 | 10 |
| 20014 | VELA VOLCAN UND | 2000 |
1000 | 100 | 50 | 200 | 30 | 22 | 10 |
+---------------+------------------------------------------+-----------------
+------------------+-----------+---------+---------+-------+----------+----------+
MariaDB [Jugueteria_Nueva]> select * from tipProduc;

ERROR 1146 (42S02): Table 'jugueteria_nueva.tipproduc' doesn't exist
MariaDB [Jugueteria_Nueva]> select * from tipoProduc;
+--------------+------------------+--------+
| id_tiproduct | descrip_tiproduc | estado |
+--------------+------------------+--------+
| 10 | cumplea?os | 1 |
| 11 | baby shower | 2 |
| 12 | grado | 3 |
| 13 | bautizo | 4 |
| 14 | primera comunion | 5 |
| 15 | toda ocasion | 6 |
+--------------+------------------+--------+
MariaDB [Jugueteria_Nueva]> select * from marca;
+-----------+---------------+
| cod_marca | descrip_marca |
+-----------+---------------+
| 30 | nacional |
| 31 | importado |
+-----------+---------------+
MariaDB [Jugueteria_Nueva]> select descrip_producto as PRODUCTO, valor_unitventa as

Costo, garan as Garantia
-> from producto INNER JOIN garantia
-> on PRODUCTO.serial_produ = garantia.id.garan;
ERROR 1054 (42S22): Unknown column 'descrip_producto' in 'field list'
MariaDB [Jugueteria_Nueva]> desc producto;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| serial_produc | int(11) | NO | PRI | NULL | |
| descrip_product | varchar(100) | NO | | NULL | |
| valor_unitventa | double | NO | | NULL | |
| valor_unitcompra | double | NO | | NULL | |
| cantexist | int(11) | NO | | NULL | |
| cantmin | int(11) | NO | | NULL | |
| cantmax | int(11) | NO | | NULL | |
| marca | int(11) | NO | MUL | NULL | |
| garantia | int(11) | NO | MUL | NULL | |
| tiproduc | int(11) | NO | MUL | NULL | |
+------------------+--------------+------+-----+---------+-------+
MariaDB [Jugueteria_Nueva]> desc garan;

ERROR 1146 (42S02): Table 'jugueteria_nueva.garan' doesn't exist
MariaDB [Jugueteria_Nueva]> desc garant;
ERROR 1146 (42S02): Table 'jugueteria_nueva.garant' doesn't exist
MariaDB [Jugueteria_Nueva]> desc garantia;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_garan | int(11) | NO | PRI | NULL | |
| tiempo_garan | varchar(20) | NO | | NULL | |
+--------------+-------------+------+-----+---------+-------+
MariaDB [Jugueteria_Nueva]> select descrip_product as PRODUCTO, valor_unitventa as

Costo, garan as Garantia
-> from descrip_product INNER JOIN garantia;
ERROR 1146 (42S02): Table 'jugueteria_nueva.descrip_product' doesn't exist
Costo, tiempo_garan Garantia from product INNER JOIN garantia order by
descrip_producto;
ERROR 1146 (42S02): Table 'jugueteria_nueva.product' doesn't exist
Costo, tiempo_garan Garantia FROM product INNER JOIN garantia order by
descrip_producto;
ERROR 1146 (42S02): Table 'jugueteria_nueva.product' doesn't exist
COSTO, tiempo_garan as GARANTIA
-> FROM producto
-> INNER JOIN garantia
-> by ro
-> by order descrip_product;
corresponds to your MariaDB server version for the right syntax to use near 'by ro
by order descrip_product' at line 4
-> FROM producto
-> by order descrip_product;
corresponds to your MariaDB server version for the right syntax to use near 'by
order descrip_product' at line 4
-> FROM producto
-> order by descrip_product;
+------------------------------------------+-------+--------------+
| PRODUCTO | COSTO | GARANTIA |
+------------------------------------------+-------+--------------+
| CONFETTI SPRAY UND | 6000 | un dia |
| CONFETTI SPRAY UND | 6000 | sin garantia |
| GLOBO AZUL CELESTE PQT X 12 UND | 4500 | un dia |
| GLOBO AZUL CELESTE PQT X 12 UND | 4500 | sin garantia |
| GLOBO BURBUJA 18 PULG X UND | 5000 | un dia |
| GLOBO BURBUJA 18 PULG X UND | 5000 | sin garantia |
| GLOBO CORAZON R12 PQT X 12 UND | 8500 | un dia |
| GLOBO CORAZON R12 PQT X 12 UND | 8500 | sin garantia |
| GLOBO DORADO R12 METALIZADO PQT X 12 UND | 5500 | sin garantia |
| GLOBO DORADO R12 METALIZADO PQT X 12 UND | 5500 | un dia |
| GLOBO LETRA 80 CM UND | 4500 | un dia |
| GLOBO LETRA 80 CM UND | 4500 | sin garantia |
| LETRERO FELIZ CUMPLEA?OS UND | 24000 | un dia |
| LETRERO FELIZ CUMPLEA?OS UND | 24000 | sin garantia |
| MANTEL FIESTA | 7000 | un dia |
| MANTEL FIESTA | 7000 | sin garantia |
| PHOTOCALL EMOTICONES PQT X 6 UND | 9500 | sin garantia |
| PHOTOCALL EMOTICONES PQT X 6 UND | 9500 | un dia |
| PLATO DESECHABLE CUADRADO PQT X 8 UND | 7500 | un dia |
| PLATO DESECHABLE CUADRADO PQT X 8 UND | 7500 | sin garantia |
| PLATO DESECHABLE REDONDO PQT X 8 UND | 5000 | un dia |
| PLATO DESECHABLE REDONDO PQT X 8 UND | 5000 | sin garantia |
| SERPENTINAS PQT X 3 UND | 3000 | un dia |
| SERPENTINAS PQT X 3 UND | 3000 | sin garantia |
| VASO DESECHABLE 9 ONZ PQT X 12 UND | 3000 | un dia |
| VASO DESECHABLE 9 ONZ PQT X 12 UND | 3000 | sin garantia |
| VELA VOLCAN UND | 2000 | un dia |
| VELA VOLCAN UND | 2000 | sin garantia |
+------------------------------------------+-------+--------------+

-> FROM producto INNER JOIN garantia
-> order by tiempo_garan;
+------------------------------------------+-------+--------------+
| PRODUCTO | COSTO | GARANTIA |
+------------------------------------------+-------+--------------+
| PHOTOCALL EMOTICONES PQT X 6 UND | 9500 | sin garantia |
| GLOBO DORADO R12 METALIZADO PQT X 12 UND | 5500 | sin garantia |
| VASO DESECHABLE 9 ONZ PQT X 12 UND | 3000 | sin garantia |
| GLOBO CORAZON R12 PQT X 12 UND | 8500 | sin garantia |
| GLOBO BURBUJA 18 PULG X UND | 5000 | sin garantia |
| PLATO DESECHABLE REDONDO PQT X 8 UND | 5000 | sin garantia |
| GLOBO AZUL CELESTE PQT X 12 UND | 4500 | sin garantia |
| PLATO DESECHABLE CUADRADO PQT X 8 UND | 7500 | sin garantia |
| MANTEL FIESTA | 7000 | sin garantia |
| SERPENTINAS PQT X 3 UND | 3000 | sin garantia |
| VELA VOLCAN UND | 2000 | sin garantia |
| LETRERO FELIZ CUMPLEA?OS UND | 24000 | sin garantia |
| CONFETTI SPRAY UND | 6000 | sin garantia |
| GLOBO LETRA 80 CM UND | 4500 | sin garantia |
| VASO DESECHABLE 9 ONZ PQT X 12 UND | 3000 | un dia |
| GLOBO CORAZON R12 PQT X 12 UND | 8500 | un dia |
| PLATO DESECHABLE REDONDO PQT X 8 UND | 5000 | un dia |
| GLOBO BURBUJA 18 PULG X UND | 5000 | un dia |
| GLOBO AZUL CELESTE PQT X 12 UND | 4500 | un dia |
| PLATO DESECHABLE CUADRADO PQT X 8 UND | 7500 | un dia |
| MANTEL FIESTA | 7000 | un dia |
| SERPENTINAS PQT X 3 UND | 3000 | un dia |
| VELA VOLCAN UND | 2000 | un dia |
| LETRERO FELIZ CUMPLEA?OS UND | 24000 | un dia |
| CONFETTI SPRAY UND | 6000 | un dia |
| GLOBO LETRA 80 CM UND | 4500 | un dia |
| PHOTOCALL EMOTICONES PQT X 6 UND | 9500 | un dia |
| GLOBO DORADO R12 METALIZADO PQT X 12 UND | 5500 | un dia |
+------------------------------------------+-------+--------------+

-> descrip_unitventa as PRECIO, tiempo_garan as GARANTIA,
-> ;
corresponds to your MariaDB server version for the right syntax to use near
'descrip_unitventa as PRECIO, tiempo_garan as GARANTIA,' at line 2
-> select descrip_product as PRODUCTO, valor_unitventa as COSTO, tiempo_garan
as GARANTIA
->
-> ;
corresponds to your MariaDB server version for the right syntax to use near 'select
descrip_product as PRODUCTO, valor_unitventa as COSTO, tiempo_garan as...' at line
2
-> descrip_producto as "TIPO PRODUCTO",
-> descrip_marcar as MARCA
-> from producto
-> INNER JOIN tipoproduc
-> on producto, tipoproduc = TIPOPRODUCTO.id_tiproduct
-> ON GARANTIA.id_garantia = PRODUCTO.garantia;
corresponds to your MariaDB server version for the right syntax to use near
'descrip_producto as "TIPO PRODUCTO",
descrip_marcar as MARCA
from producto
IN...' at line 2

CUsers SENADownloads Basesdatosciclis

Uploaded by

Copyright:

Available Formats

CUsers SENADownloads Basesdatosciclis

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

CUsers SENADownloads Basesdatosciclis

Uploaded by

Copyright:

Available Formats

C:\Users\SENA\Downloads\Basesdatosciclismo\backupBdClase_16.

Setting environment for using XAMPP for Windows.

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

MariaDB [(none)]> Create database Jugueteria_Nueva;

MariaDB [(none)]> exit

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

MariaDB [(none)]> use Jugueteria_Nueva

MariaDB [Jugueteria_Nueva]> insert into tipdocu

MariaDB [Jugueteria_Nueva]> insert into tipdocu

MariaDB [Jugueteria_Nueva]> insert into tipdocu

MariaDB [Jugueteria_Nueva]> insert into tipdocu

MariaDB [Jugueteria_Nueva]> insert into roles

MariaDB [Jugueteria_Nueva]> insert into roles

MariaDB [Jugueteria_Nueva]> insert into tipoproduc

MariaDB [Jugueteria_Nueva]> insert into tipoproduc

MariaDB [Jugueteria_Nueva]> insert into tipoproduc

MariaDB [Jugueteria_Nueva]> insert into tipoproduc

MariaDB [Jugueteria_Nueva]> insert into tipoproduc

MariaDB [Jugueteria_Nueva]> insert into garantia

MariaDB [Jugueteria_Nueva]> insert into marca

MariaDB [Jugueteria_Nueva]> insert into tipoclte

MariaDB [Jugueteria_Nueva]> insert into producto

MariaDB [Jugueteria_Nueva]> insert into persona

MariaDB [Jugueteria_Nueva]> insert into cliente

MariaDB [Jugueteria_Nueva]> insert into cliente

MariaDB [Jugueteria_Nueva]> insert into fact_comp

MariaDB [Jugueteria_Nueva]> insert into fact_comp

MariaDB [Jugueteria_Nueva]> insert into fact_comp

MariaDB [Jugueteria_Nueva]> insert into fact_produc

MariaDB [Jugueteria_Nueva]> insert into fact_produc

MariaDB [Jugueteria_Nueva]> insert into fact_produc

MariaDB [Jugueteria_Nueva]> insert into fact_produc

MariaDB [Jugueteria_Nueva]> insert into fact_produc

MariaDB [Jugueteria_Nueva]> select * from garantia;

MariaDB [Jugueteria_Nueva]> select * from tipProduc;

MariaDB [Jugueteria_Nueva]> select descrip_producto as PRODUCTO, valor_unitventa as

MariaDB [Jugueteria_Nueva]> desc garan;

MariaDB [Jugueteria_Nueva]> select descrip_product as PRODUCTO, valor_unitventa as

MariaDB [Jugueteria_Nueva]> select descrip_product as PRODUCTO, valor_unitventa as

MariaDB [Jugueteria_Nueva]> select descrip_product as PRODUCTO, valor_unitventa as

You might also like