Create multiple databases using scala slick

Question

Is it possible to create multiple databases using a single query using slick?

 sqlu"""CREATE DATABASE if not exists students;CREATE DATABASE if NOT professors"""

I'm running the above slick query but getting MySQLSyntaxErrorException

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'CREATE DATABASE if NOT EXISTS professors' at line 1

score 0 · Answer 1 · answered Apr 14 '17 at 16:10

0

Ive found answer to my own question

val createDbs = DBIO.seq(sqlu"""CREATE DATABASE if not exists students""",
  sqlu"""CREATE DATABASE if not exists professors """)
db.run(createDbs)

answered Apr 14 '17 at 16:10

Sheshank Kodam

515
5
17

Create multiple databases using scala slick

1 Answers1