MySQL
-
[DB] DBMS별 버전 정보 확인DB/Etc. 2022. 6. 22. 18:30
1. MSSQL SELECT @@VERSION; 2. MySQL SELECT VERSION(); 3. MariaDB SELECT @@VERSION; SELECT VERSION(); 4. ORACLE SELECT * FROM v$version; SELECT * FROM product_component_version; 5. PostgreSQL SELECT version(); 6. Tibero SELECT * FROM v$version WHERE NAME = 'TB_MAJOR' OR NAME = 'TB_MINOR'; 7. Altibase SELECT * FROM V$VERSION;
-
[MariaDB | Mybatis] Mybatis에서 insert문 테이블 여러개 동시 실행방법DB/MariaDB 2022. 6. 21. 14:02
DB Connection 설정 부분에 allowMultiQueries=true 를 입력하면, insert문이 다중 실행된다. 1. jdbc.properties jdbc:mariadb://localhost:3306/test_db?allowMultiQueries=true 2. textSQL.xml insert into test1 values('e','s','h'); insert into test2 values('e','s','h'); 3. Test Result Test Environment Info. - OS : macOS Catalina 10.15.2 - JDK : 1.8.0_321 - STS : 4.13.0.RELEASE - MariaDB : 10.7.4 - DBeaver : 21.3.1