Why execute query with 2 insert cannot be executed?

51 views Asked by At

I am newbie in MySQL 8 and try to run this query in one time at dBeaver

INSERT INTO `m_permission` 
(`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) 
VALUES
('accounting', 'CREATE_GLACCOUNT', 'GLACCOUNT', 'CREATE', 1),
('accounting', 'UPDATE_GLACCOUNT', 'GLACCOUNT', 'UPDATE', 1),
('accounting', 'DELETE_GLACCOUNT', 'GLACCOUNT', 'DELETE', 1),
('accounting', 'CREATE_GLCLOSURE', 'GLCLOSURE', 'CREATE', 1),
('accounting', 'UPDATE_GLCLOSURE', 'GLCLOSURE', 'UPDATE', 1),
('accounting', 'DELETE_GLCLOSURE', 'GLCLOSURE', 'DELETE', 1),
('accounting', 'CREATE_JOURNALENTRY', 'JOURNALENTRY', 'CREATE', 1),
('accounting', 'REVERSE_JOURNALENTRY', 'JOURNALENTRY', 'REVERSE', 1);


INSERT INTO `m_role` 
(`id`, `name`, `description`)
VALUES
(1,'Super user','This role provides all application permissions.');

But, I'm stuck in this error

Query execution failed

Reason:
SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `m_role` 
(`id`, `name`, `description`)
VALUES
(1,'Super user','This' at line 15

So, what should I do to fix this error? Thank you

1

There are 1 answers

2
Muhammad Usman On

Show me the structure of database I think there is some issue with your database columns!!