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
Show me the structure of database I think there is some issue with your database columns!!