insert load data

load data local infile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/bk/comercio.txt'
into table comercio
fields terminated by ';' enclosed by '"'
lines terminated by '\r\n';

INSERT INTO fabricante (nombre, pais) values
("Oracle", "Estados Unidos"),
("Microsoft", "Estados Unidos"),
("IBM", "Estados Unidos"),
("Dinamic", "España"),
("Borland", "Estados Unidos"),
("Symantec", "Estados Unidos");

CREATE VIEW vista7 AS
SELECT DISTINCT jugad