In the MySQL Workbench , when we do not enter a record by query , and manually, when giving APPLY , the query is displayed before execution.
Example of a query consisting of MySQL Workbench :
INSERT INTO 'nomedobanco'.'tabela' ('id', 'resumo', 'descricao', 'grupo', 'solicitante', 'atendente', 'status')
VALUES ('171', 'Teste', 'Testando', '7', '1', '2', 'N');
How would it work:
INSERT INTO 'nomedobanco'.'tabela' ('id', 'resumo', 'descricao', 'grupo', 'solicitante', 'atendente', 'status')
VALUES (171, 'Teste', 'Testando', 7, 1, 2, 'N');
Questions
- Why MySQL Workbench puts quotation marks in INT values?
- Does it not identify the type of fields and end up inserting everything "as string"?