create table clientes (id_cliente INT, nombre varchar (50), direccion varchar (100), telefono varchar (10) ); create table productos (id_producto INT, descripcion varchar (200), precio NUMERIC); create table ventas (id_venta INT, cliente INT, producto INT, cantidad NUMERIC); rename table ventas to venta; rename table clientes to cliente; rename table productos to producto; SELECT cliente.nombre FROM cliente INNER JOIN venta ON venta.cliente = cliente.id_cliente; alter table venta add primary key (id_venta); alter table cliente add primary key (id_cliente); alter table producto add primary key (id_producto); insert into cliente values (1,'Fabiana Morera Carrasco','Calle 10 # 5-51 (1) 3814000 Bogot† D.C','6847582954'); insert into cliente values (2,'Custodia InÇs Pedro Juli†',' Avenida 19 No. 98-03, sexto piso,','7023882671'); insert into cliente values (3,'Carolina Marta Ad†n Donoso','Edificio Torre 100 (1) 3814000 Bogot† D.C','8451944091'); insert into cliente values (4,'Estela Esparza Sureda',' Calle 53 No 10-60/46, Piso 2. (1) 3814000 Bogot† D.C','3841137624'); insert into cliente values (5,'Cebri†n Pinedo Gracia','FONDO ROTATORIO PRINCIPAL Calle 10 # 5-51 (1) 3814000 Bogot† D.C 860.511.071-6','4853021289'); insert into cliente values (6,'Asunci¢n Amig¢ Carlos','PRINCIPAL Avenida Calle 26 No 59-51 Edificio','4058557741'); insert into cliente values (7,'Eli de Noguera','Argos - Torre 3 Piso 4 (1) 6055454 Bogot† D.C - Cundinamarca','8271033408'); insert into cliente values (8,'Haroldo Ale Anguita Ord¢§ez',' Calle 9 # 9 ? 62, Leticia, Barrio Centro (8) 592-6001 Amazonas - Leticia','5137266220'); insert into cliente values (9,'Benjam°n Iba§ez Requena',' Calle 19 # 80A-40. Barrio BelÇn La','8984758816'); insert into cliente values (10,'Cristina Feijoo Comas','Nubia (4) 345-5500 Antioquia - Medell°n','9812252088'); insert into cliente values (11,'Gloria Ugarte Aliaga',' Carrera 21 # 17 -63 (8) - 885-1005 / 885-0663 Arauca - Arauca','2558170209'); insert into cliente values (12,'Mario de Pati§o',' Carrera 42 # 54-77 Barrio El Recreo (5) 351 -3401 Atl†ntico - Barranquilla','9395177796'); insert into cliente values (13,'Ligia Quir¢s Bilbao',' Calle 100 # 11B-27 Bogot† (1) 605-5454 Bogot† D.C - Cundinamarca','886194917'); insert into cliente values (14,'Moreno Carlos',' Carrera 20 B # 29-18. Barrio Pie de la','6574694514'); insert into cliente values (15,'Yaiza Teodora Segu° Ram¢n','Popa. (5) 670-0555 Bol°var - Cartagena','998677248'); insert into cliente values (16,'Albert Baquero Pallaräs',' Transversal 9 a No. 29 - 29 Barrio','2431933680'); insert into cliente values (17,'P†nfilo Carnero-Seco','Maldonado (8) 745-4023 / 740-2196 Boyac† - Tunja','5475936317'); insert into cliente values (18,'Hip¢lito Tamarit Santamar°a',' Calle 53 # 25A-35 (6) 885-0350 / 885-1165 Caldas - Manizales','1699323235'); insert into cliente values (19,'Reyes Rossell¢-Vaquero',' Carrera 20 B # 29-18. Barrio Pie de la','7760129144'); insert into cliente values (20,'Leticia de Vi§a','Calle 10 # 5-51 (1) 3814000 Bogot† D.C','2955696428'); insert into cliente values (21,'Cintia ?vila',' Avenida 19 No. 98-03, sexto piso,','1744068625'); insert into cliente values (22,'Prudencia Garc°a-Escolano','Edificio Torre 100 (1) 3814000 Bogot† D.C','9651576039'); insert into cliente values (23,'Teresita Acedo Jurado',' Calle 53 No 10-60/46, Piso 2. (1) 3814000 Bogot† D.C','9469111913'); insert into cliente values (24,'Heliodoro C†ceres Carreras','FONDO ROTATORIO PRINCIPAL Calle 10 # 5-51 (1) 3814000 Bogot† D.C 860.511.071-6','5771644183'); insert into cliente values (25,'Aitana Cuadrado Nieto','PRINCIPAL Avenida Calle 26 No 59-51 Edificio','4531145145'); insert into cliente values (26,'Cipriano Gimeno C†rdenas','Argos - Torre 3 Piso 4 (1) 6055454 Bogot† D.C - Cundinamarca','1462664939'); insert into cliente values (27,'Carolina Landa Belda',' Calle 9 # 9 ? 62, Leticia, Barrio Centro (8) 592-6001 Amazonas - Leticia','1035554839'); insert into cliente values (28,'Eustaquio Segura Amo',' Calle 19 # 80A-40. Barrio BelÇn La','7062676228'); insert into cliente values (29,'Lupita Espa§a-Herrero','Nubia (4) 345-5500 Antioquia - Medell°n','9036430401'); insert into cliente values (30,'Geraldo Ibarra Mayoral',' Carrera 21 # 17 -63 (8) - 885-1005 / 885-0663 Arauca - Arauca','4700294132'); insert into cliente values (31,'Ger¢nimo Madrigal Aguilar',' Carrera 42 # 54-77 Barrio El Recreo (5) 351 -3401 Atl†ntico - Barranquilla','487010980'); insert into cliente values (32,'Gabriela Castilla Prada',' Calle 100 # 11B-27 Bogot† (1) 605-5454 Bogot† D.C - Cundinamarca','1744785930'); insert into cliente values (33,'Teo Jerez Bejarano',' Carrera 20 B # 29-18. Barrio Pie de la','4184597818'); insert into cliente values (34,'Adora Esteve Valenciano','Popa. (5) 670-0555 Bol°var - Cartagena','531629721'); insert into cliente values (35,'Eladio Vi§a MelÇndez',' Transversal 9 a No. 29 - 29 Barrio','6515109174'); insert into cliente values (36,'Dolores Gisbert','Maldonado (8) 745-4023 / 740-2196 Boyac† - Tunja','6885667498'); insert into cliente values (37,'Reina Iglesia Moles',' Calle 53 # 25A-35 (6) 885-0350 / 885-1165 Caldas - Manizales','3065037184'); insert into cliente values (38,'Paz de Rosales',' Carrera 20 B # 29-18. Barrio Pie de la','9080008434'); insert into cliente values (39,'Godofredo Pozo Gracia','Calle 10 # 5-51 (1) 3814000 Bogot† D.C','1088728621'); insert into cliente values (40,'Ruperto Ribas-Guijarro',' Avenida 19 No. 98-03, sexto piso,','9663471941'); insert into cliente values (41,'Adriana Heredia Esteban','Edificio Torre 100 (1) 3814000 Bogot† D.C','2103946478'); insert into cliente values (42,'Raimundo del Pel†ez',' Calle 53 No 10-60/46, Piso 2. (1) 3814000 Bogot† D.C','5618581640'); insert into cliente values (43,'Modesto Salom Villanueva','FONDO ROTATORIO PRINCIPAL Calle 10 # 5-51 (1) 3814000 Bogot† D.C 860.511.071-6','488572785'); insert into cliente values (44,'Galo Hidalgo Hoyos','PRINCIPAL Avenida Calle 26 No 59-51 Edificio','8883530376'); insert into cliente values (45,'Iv†n Lupe Due§as ?lvarez','Argos - Torre 3 Piso 4 (1) 6055454 Bogot† D.C - Cundinamarca','9457511652'); insert into cliente values (46,'Fito Serra Cepeda',' Calle 9 # 9 ? 62, Leticia, Barrio Centro (8) 592-6001 Amazonas - Leticia','3060239827'); insert into cliente values (47,'Bego§a Ferrera Fernandez',' Calle 19 # 80A-40. Barrio BelÇn La','1124251961'); insert into cliente values (48,'Rico Alvarado Rinc¢n','Nubia (4) 345-5500 Antioquia - Medell°n','1893068271'); insert into cliente values (49,'Maximiliano Francisco Sastre Garz¢n',' Carrera 21 # 17 -63 (8) - 885-1005 / 885-0663 Arauca - Arauca','3257230012'); insert into cliente values (50,'P°o Sevilla ValdÇs',' Carrera 42 # 54-77 Barrio El Recreo (5) 351 -3401 Atl†ntico - Barranquilla','3649836977'); insert into cliente values (51,'Segismundo Blanch',' Calle 100 # 11B-27 Bogot† (1) 605-5454 Bogot† D.C - Cundinamarca','7183000234'); insert into cliente values (52,'Esmeralda Torralba Roura',' Carrera 20 B # 29-18. Barrio Pie de la','8172273497'); insert into cliente values (53,'Maura del Noriega','Popa. (5) 670-0555 Bol°var - Cartagena','3796393170'); insert into cliente values (54,'Anacleto Bonilla Mendoza',' Transversal 9 a No. 29 - 29 Barrio','6436459918'); insert into cliente values (55,'Reynaldo Campo Mar°n','Maldonado (8) 745-4023 / 740-2196 Boyac† - Tunja','8036475288'); insert into cliente values (56,'Amor Villalba-Marti',' Calle 53 # 25A-35 (6) 885-0350 / 885-1165 Caldas - Manizales','8537945071'); insert into cliente values (57,'Leonor VÇlez-ArÇvalo',' Carrera 20 B # 29-18. Barrio Pie de la','896887696'); insert into cliente values (58,'Flavia Lorenzo','Calle 10 # 5-51 (1) 3814000 Bogot† D.C','2210739637'); insert into cliente values (59,'Carlos del Colomer',' Avenida 19 No. 98-03, sexto piso,','6500007248'); insert into cliente values (60,'Jorge del Figueras','Edificio Torre 100 (1) 3814000 Bogot† D.C','4592352924'); insert into cliente values (61,'Macarena Pelayo G†lvez',' Calle 53 No 10-60/46, Piso 2. (1) 3814000 Bogot† D.C','4507460176'); insert into cliente values (62,'Fausto Sosa PÇrez','FONDO ROTATORIO PRINCIPAL Calle 10 # 5-51 (1) 3814000 Bogot† D.C 860.511.071-6','8778503317'); insert into cliente values (63,'Concha de Mendez','PRINCIPAL Avenida Calle 26 No 59-51 Edificio','1027229754'); insert into cliente values (64,'Haroldo Valera Hervia','Argos - Torre 3 Piso 4 (1) 6055454 Bogot† D.C - Cundinamarca','5162289958'); insert into cliente values (65,'Plinio Bueno-Uribe',' Calle 9 # 9 ? 62, Leticia, Barrio Centro (8) 592-6001 Amazonas - Leticia','3714056847'); insert into cliente values (66,'M†xima Santamar°a Acedo',' Calle 19 # 80A-40. Barrio BelÇn La','7410495820'); insert into cliente values (67,'Loida Delfina Carpio Chico','Nubia (4) 345-5500 Antioquia - Medell°n','9227223086'); insert into cliente values (68,'Iv†n Berenguer-Perales',' Carrera 21 # 17 -63 (8) - 885-1005 / 885-0663 Arauca - Arauca','196780578'); insert into cliente values (69,'Eva Mar°a Toledo Fajardo',' Carrera 42 # 54-77 Barrio El Recreo (5) 351 -3401 Atl†ntico - Barranquilla','9848330439'); insert into cliente values (70,'Chuy de Bonet',' Calle 100 # 11B-27 Bogot† (1) 605-5454 Bogot† D.C - Cundinamarca','6799007788'); insert into cliente values (71,'Juan Bautista de Mu§oz',' Carrera 20 B # 29-18. Barrio Pie de la','7465523322'); insert into cliente values (72,'Celia Cases Alc†ntara','Popa. (5) 670-0555 Bol°var - Cartagena','7151295161'); insert into cliente values (73,'SalomÇ de Llad¢',' Transversal 9 a No. 29 - 29 Barrio','6006875763'); insert into cliente values (74,'Jose Carlos Alonso Lastra','Maldonado (8) 745-4023 / 740-2196 Boyac† - Tunja','3976208526'); insert into cliente values (75,'AngÇlica del Herranz',' Calle 53 # 25A-35 (6) 885-0350 / 885-1165 Caldas - Manizales','8788204401'); insert into cliente values (76,'Manolo AmÇrico Arnaiz Bas',' Carrera 20 B # 29-18. Barrio Pie de la','848315639'); insert into cliente values (77,'Clarisa Valls Llano','Calle 10 # 5-51 (1) 3814000 Bogot† D.C','581343002'); insert into cliente values (78,'Aurelio Cuadrado Ram°rez',' Avenida 19 No. 98-03, sexto piso,','9090530691'); insert into cliente values (79,'Quirino Castillo Coca','Edificio Torre 100 (1) 3814000 Bogot† D.C','3984447318'); insert into cliente values (80,'Encarnacion Angulo M†rquez',' Calle 53 No 10-60/46, Piso 2. (1) 3814000 Bogot† D.C','924325504'); insert into cliente values (81,'Teodosio Sainz Puga','FONDO ROTATORIO PRINCIPAL Calle 10 # 5-51 (1) 3814000 Bogot† D.C 860.511.071-6','514673716'); insert into cliente values (82,'Arcelia Cuenca B†ez','PRINCIPAL Avenida Calle 26 No 59-51 Edificio','9124956746'); insert into cliente values (83,'Elvira Prat Oliva','Argos - Torre 3 Piso 4 (1) 6055454 Bogot† D.C - Cundinamarca','7000550010'); insert into cliente values (84,'Trinidad G†lvez',' Calle 9 # 9 ? 62, Leticia, Barrio Centro (8) 592-6001 Amazonas - Leticia','2420801471'); insert into cliente values (85,'Marcio Exp¢sito',' Calle 19 # 80A-40. Barrio BelÇn La','9655220898'); insert into cliente values (86,'Georgina del Valle','Nubia (4) 345-5500 Antioquia - Medell°n','9835947099'); insert into cliente values (87,'Tatiana Anastasia Lumbreras Tapia',' Carrera 21 # 17 -63 (8) - 885-1005 / 885-0663 Arauca - Arauca','2932180340'); insert into cliente values (88,'Esther Saura Guijarro',' Carrera 42 # 54-77 Barrio El Recreo (5) 351 -3401 Atl†ntico - Barranquilla','9522612402'); insert into cliente values (89,'Fabiana de CuÇllar',' Calle 100 # 11B-27 Bogot† (1) 605-5454 Bogot† D.C - Cundinamarca','4738547500'); insert into cliente values (90,'Virgilio Isern-Riera',' Carrera 20 B # 29-18. Barrio Pie de la','4262207207'); insert into cliente values (91,'Sara Villar Salcedo','Popa. (5) 670-0555 Bol°var - Cartagena','3954204438'); insert into cliente values (92,'Guadalupe Mar°n Asenjo',' Transversal 9 a No. 29 - 29 Barrio','7672422476'); insert into cliente values (93,'Alexandra Gir¢n-Plaza','Maldonado (8) 745-4023 / 740-2196 Boyac† - Tunja','4905625419'); insert into cliente values (94,'Eligia Cabello Mena',' Calle 53 # 25A-35 (6) 885-0350 / 885-1165 Caldas - Manizales','6466800738'); insert into cliente values (95,'Dora del Espa§ol',' Carrera 20 B # 29-18. Barrio Pie de la','1093341926'); insert into cliente values (96,'Petrona Portillo-Bay¢n','Calle 10 # 5-51 (1) 3814000 Bogot† D.C','2164606642'); insert into cliente values (97,'Cristian Sanmart°n',' Avenida 19 No. 98-03, sexto piso,','981065816'); insert into cliente values (98,'Joel Torrecilla Ros','Edificio Torre 100 (1) 3814000 Bogot† D.C','1025127719'); insert into cliente values (99,'Maximiliano Barrio Lorenzo',' Calle 53 No 10-60/46, Piso 2. (1) 3814000 Bogot† D.C','7458112413'); insert into cliente values (100,'Mireia del Torrent','FONDO ROTATORIO PRINCIPAL Calle 10 # 5-51 (1) 3814000 Bogot† D.C 860.511.071-6','447938620'); insert into producto values (1,'Coca-Cola 2 litros',19.99); insert into producto values (2,'Coca-Cola Zero 600ml',10.5); insert into producto values (3,'Coca-Cola Light 355ml',8.99); insert into producto values (4,'Lala Leche Entera 1 litro',21.5); insert into producto values (5,'Lala Yogur Natural 150g',9.8); insert into producto values (6,'Lala Queso Panela 250g',33); insert into producto values (7,'Bimbo Pan Blanco Grande 680g',23.5); insert into producto values (8,'Bimbo Pan Integral 567g',24.99); insert into producto values (9,'Bimbo Pastelito de Fresa 1 unidad',9.99); insert into producto values (10,'Nutrileche Leche Deslactosada 1 litro',25); insert into producto values (11,'Nutrileche Leche de Almendras 946ml',37.9); insert into producto values (12,'Nutrileche Yogur Sin Az£car 150g',10.25); insert into producto values (13,'La Moderna Pasta Espagueti 500g',14.25); insert into producto values (14,'La Moderna Galletas Mar°as 454g',18.5); insert into producto values (15,'La Moderna Sopa de Fideos 200g',7.99); insert into producto values (16,'Pepsi 2 litros',17.5); insert into producto values (17,'Pepsi Max 600ml',9.99); insert into producto values (18,'Pepsi Twist 355ml',8.75); insert into producto values (19,'NescafÇ CafÇ Soluble 200g',55.99); insert into producto values (20,'NescafÇ Dolca Instant†neo 400g',42.5); insert into producto values (21,'NescafÇ Capuccino Vainilla 10 sobres',29.9); insert into producto values (22,'Marinela Gansito 1 unidad',7.5); insert into producto values (23,'Marinela PingÅinos 6 unidades',16.99); insert into producto values (24,'Marinela Submarinos 6 unidades',14.5); insert into producto values (25,'Danone Yogur Natural 250g',12.5); insert into producto values (26,'Danone Activia Frutas 4 unidades',18.75); insert into producto values (27,'Danone Danonino Fresa 6 unidades',15.99); insert into producto values (28,'NestlÇ Leche Condensada 397g',24.9); insert into producto values (29,'NestlÇ Cereal Fitness 300g',32.5); insert into producto values (30,'NestlÇ KitKat 4 barras',12.99); insert into producto values (31,'NestlÇ Nesquik 400g',39.99); insert into producto values (32,'Marinela Mamut 1 unidad',8.25); insert into producto values (33,'Marinela Principe 6 unidades',17.5); insert into producto values (34,'Danone Danette Chocolate 4 unidades',22.99); insert into producto values (35,'Danone Oikos Yogur Griego Natural 125g',14.5); insert into producto values (36,'Pepsi Twist Lim¢n 600ml',10.5); insert into producto values (37,'Pepsi Max Zero Calor°as 2 litros',18.5); insert into producto values (38,'Bimbo Pan Integral Multigrano 567g',25.5); insert into producto values (39,'Bimbo Donas Azucaradas 6 unidades',15.99); insert into producto values (40,'Lala Yoghurt Bebible Sabor Fresa 1 litro',19.9); insert into producto values (41,'Lala Queso Crema 190g',28.5); insert into producto values (42,'Coca-Cola Sin Az£car 2 litros',20.99); insert into producto values (43,'Coca-Cola Light Sin Cafe°na 600ml',11.5); insert into producto values (44,'NescafÇ Cl†sico Instant†neo 200g',49.99); insert into producto values (45,'NescafÇ 3 en 1 Original 10 sobres',17.8); insert into producto values (46,'NestlÇ Crunch 80g',15.75); insert into producto values (47,'NestlÇ Abuelita Chocolate en Polvo 540g',45.5); insert into producto values (48,'La Moderna Sopa de Estrellitas 200g',8.99); insert into producto values (49,'La Moderna Tortillas de Harina 1kg',18.5); insert into producto values (50,'Nutrileche Leche de Coco 946ml',32.9); insert into venta values (1,47,42,3); insert into venta values (2,82,19,2); insert into venta values (3,14,35,2); insert into venta values (4,73,11,1); insert into venta values (5,66,28,1); insert into venta values (6,5,8,1); insert into venta values (7,92,50,3); insert into venta values (8,30,14,1); insert into venta values (9,8,7,1); insert into venta values (10,70,23,2); insert into venta values (11,97,46,1); insert into venta values (12,63,32,1); insert into venta values (13,11,2,1); insert into venta values (14,41,39,3); insert into venta values (15,78,17,3); insert into venta values (16,23,5,1); insert into venta values (17,19,31,1); insert into venta values (18,70,49,2); insert into venta values (19,88,25,1); insert into venta values (20,35,13,1); SELECT cliente.nombre FROM cliente INNER JOIN venta ON venta.cliente = cliente.id_cliente WHERE id_venta=14; SELECT producto.descripcion FROM producto INNER JOIN venta ON venta.producto = producto.id_producto WHERE id_venta=14; select * from venta; select * from producto; insert into producto values (51,'Takis Fuego con Valentina Negra',17.00); select * from producto; select @@autocommit; SET autocommit=0; select @@autocommit; insert into producto values (52,'Cafe Garat 500gr',120.00); insert into producto values (53,'Consome de pollo 4 cubos',10); UPDATE producto SET precio = 999.00 WHERE id_producto = 49; select * from producto; ROLLBACK; select * from producto; insert into producto values (52,'Cafe Garat 500gr',120.00); insert into producto values (53,'Consome de pollo 4 cubos',10); UPDATE producto SET precio = 999.00 WHERE id_producto = 49; COMMIT; ROLLBACK; SELECT * FROM PRODUCTO; SET autocommit=1; insert into producto values (54,'Paleta de hielo al tiempo',1); insert into producto values (55,'Bonais tutifrutix',5); UPDATE producto SET precio = 45 WHERE id_producto = 45; ROLLBACK; SELECT * FROM PRODUCTO;
Write, Run & Share MySQL queries online using OneCompiler's MySQL online editor and compiler for free. It's one of the robust, feature-rich online editor and compiler for MySQL. Getting started with the OneCompiler's MySQL editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose language as 'MySQL' and start writing queries to learn and test online without worrying about tedious process of installation.
MySQL is a open-source, free and very popular relational database management system which is developed, distributed and supported by Oracle corporation.
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
....);
CREATE TABLE EMPLOYEE (
empId INTEGER PRIMARY KEY,
name TEXT NOT NULL,
dept TEXT NOT NULL
);
ALTER TABLE Table_name ADD column_name datatype;
INSERT INTO EMPLOYEE VALUES (0001, 'Dave', 'Sales');
TRUNCATE table table_name;
DROP TABLE table_name;
RENAME TABLE table_name1 to new_table_name1;
--Line1;
/* Line1,
Line2 */
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
Note: Column names are optional.
INSERT INTO EMPLOYEE VALUES (0001, 'Ava', 'Sales');
SELECT column1, column2, ...
FROM table_name
[where condition];
SELECT * FROM EMPLOYEE where dept ='sales';
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
UPDATE EMPLOYEE SET dept = 'Sales' WHERE empId='0001';
DELETE FROM table_name where condition;
DELETE from EMPLOYEE where empId='0001';
CREATE INDEX index_name on table_name(column_name);
CREATE UNIQUE INDEX index_name on table_name(column_name);
DROP INDEX index_name ON table_name;
Creating a View:
CREATE VIEW View_name AS
Query;
SELECT * FROM View_name;
ALTER View View_name AS
Query;
DROP VIEW View_name;
CREATE TRIGGER trigger_name trigger_time trigger_event
ON tbl_name FOR EACH ROW [trigger_order] trigger_body
/* where
trigger_time: { BEFORE | AFTER }
trigger_event: { INSERT | UPDATE | DELETE }
trigger_order: { FOLLOWS | PRECEDES } */
DROP TRIGGER [IF EXISTS] trigger_name;
CREATE PROCEDURE sp_name(p1 datatype)
BEGIN
/*Stored procedure code*/
END;
CALL sp_name;
DROP PROCEDURE sp_name;
SELECT * FROM TABLE1 INNER JOIN TABLE2 where condition;
SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON condition;
SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON condition;
SELECT select_list from TABLE1 CROSS JOIN TABLE2;