mybatis mariadb 다중 테이블 insert 문법 좀 봐주실분 계실까요?

Question

안녕하세요.오라클은 insert all 이 있는데mariadb는 구글링하니까 접근방법이 다른거 같더라구요.insert 시 2개의 테이블에 데이터를 추가하는데부모 테이블의 seq를 집어 넣으려고 합니다.아래 처럼 하면 오류가 발생하는데문법이 잘못됬을까요..### Error updating database. Cause: java.sql.SQLSyntaxErrorException: (conn&#61;2411) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DECLARESELECT IFNULL(MAX(MEMBER_SEQ),0)&#43;1 AS MEMBER_SEQ FROM RW_...' at line 2### The error may involve cyclone.api.member.insertMember-InlineThe error occurred while setting parameters### SQL: DECLARE SELECT IFNULL(MAX(MEMBER_SEQ),0)&#43;1 AS MEMBER_SEQ FROM RW_MEMBER BEGIN INSERT INTO RW_MEMBER ( member_seq, hp, member_nm ) VALUES ( ? ,?, ? ); INSERT INTO RW_MEMBER_ROLE ( member_seq, role_type_cd ) VALUES ( ?, ? ); END;### Cause: java.sql.SQLSyntaxErrorException: (conn&#61;2411) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DECLARESELECT IFNULL(MAX(MEMBER_SEQ),0)&#43;1 AS MEMBER_SEQ FROM RW_...' at line 2; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: (conn&#61;2411) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DECLARESELECT IFNULL(MAX(MEMBER_SEQ),0)&#43;1 AS MEMBER_SEQ FROM RW_...' at line 2

roggue2 · Answer

mariadb는 MySQL 문법과 많이 흡사합니다. oracle 문법 하고는 차이가 좀 나고요.

mybatis mariadb 다중 테이블 insert 문법 좀 봐주실분 계실까요?

1개의 답변

Q&A 목록