Boa tarde, pessoal!
Estou com alguns problemas para inserir os valores nas tabelas de "vendas" e "vendedores", estão acontecendo os seguintes erros:
INSERT INTO vendedores VALUES
(1,'Paula Rabelo'),
(2,'Juliana Macedo'),
(3,'Roberto Barros'),
(4,'Barbara Jales');
INSERT INTO vendedores VALUES (1,'Paula Rabelo'), (2,'Juliana Macedo'), (3,'Roberto Barros'), (4,'Barbara Jales') Error Code: 1366. Incorrect integer value: 'Paula Rabelo' for column 'nome_vendedor' at row 1
INSERT INTO VENDAS VALUES
(1, 3, 7, 1, '2020-11-02'),
(2, 4, 8, 2, '2020-11-02'),
(3, 4, 4, 3, '2020-11-02'),
(4, 1, 7, 1, '2020-11-03'),
(5, 1, 6, 3, '2020-11-03'),
(6, 1, 9, 2, '2020-11-04'),
(7, 4, 1, 3, '2020-11-04'),
(8, 1, 5, 2, '2020-11-05'),
(9, 1, 2, 1, '2020-11-05'),
(10, 3, 8, 2, '2020-11-11'),
(11, 1, 1, 4, '2020-11-11'),
(12, 2, 10, 10, '2020-11-11'),
(13, 1, 12, 5, '2020-11-18'),
(14, 2, 4, 1, '2020-11-25'),
(15, 3, 13, 2,'2021-01-05'),
(16, 4, 13, 1, '2021-01-05'),
(17, 4, 4, 3, '2021-01-06'),
(18, 2, 12, 2, '2021-01-06');
INSERT INTO VENDAS VALUES (1, 3, 7, 1, '2020-11-02'), (2, 4, 8, 2, '2020-11-02'), (3, 4, 4, 3, '2020-11-02'), (4, 1, 7, 1, '2020-11-03'), (5, 1, 6, 3, '2020-11-03'), (6, 1, 9, 2, '2020-11-04'), (7, 4, 1, 3, '2020-11-04'), (8, 1, 5, 2, '2020-11-05'), (9, 1, 2, 1, '2020-11-05'), (10, 3, 8, 2, '2020-11-11'), (11, 1, 1, 4, '2020-11-11'), (12, 2, 10, 10, '2020-11-11'), (13, 1, 12, 5, '2020-11-18'), (14, 2, 4, 1, '2020-11-25'), (15, 3, 13, 2,'2021-01-05'), (16, 4, 13, 1, '2021-01-05'), (17, 4, 4, 3, '2021-01-06'), (18, 2, 12, 2, '2021-01-06') Error Code: 1062. Duplicate entry '4-4' for key 'vendas.PRIMARY'
O que será que está errado, pode ser nas tabelas que eu criei? as tabelas de estoque e livros eu consequi inserir sem problemas.