MySQL Check if a database exists

Question

I'm trying to determine if a database of a certain name exists and then create it if it does not. Ideally this would be in VBScript. I currently am trying using a loop search of an array but the total number of databases will change greatly.

set dbQuery = ConnSQL.execute(checkDBsql) 
            if dbQuery.BOF and dbQuery.EOF then ' Query didn't return any records.
                ConnSQL.execute(MakeDb)
            else
                dbQuery.MoveFirst
                i = 0
                Do While Not dbQuery.EOF
                    i = i + 1
                loop
            end if
    set dbQuery = ConnSQL.execute(checkDBsql)
            if dbQuery.BOF and dbQuery.EOF then ' Query didn't return any records.
                msgBox "ERROR!"
            else
                e = 0
                do while not dbQuery.EOF
                    DBName(e) = dbQuery("Database")
                    e = e + 1
                loop                
                For a = 1 to UBound(DBName)
                    If DBName(a) = OldDBName Then
                        MsgBox DBName(a)
                    end if
                Next
    connSQL.close

p.campbell · Accepted Answer · 2010-09-08 22:40:32Z

4

Try:

SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'DBName'

You'll get an empty resultset if not exists.

If you need to know if a database exists to avoid an error when trying to create it:

CREATE DATABASE IF NOT EXISTS <name>;

answered Sep 8, 2010 at 22:40

p.campbell

101k70 gold badges264 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MrGrant Over a year ago

The information Schema gave an error but the Create database if not exists part is what I was trying to do. I must have missed that.

hvgotcodes · Accepted Answer · 2010-09-08 22:39:53Z

1

if you can connect to the server in a mysql command line client

show databases

will show you the databases in mysql.

answered Sep 8, 2010 at 22:39

hvgotcodes

121k33 gold badges209 silver badges237 bronze badges

Comments

zevra0 · Accepted Answer · 2010-09-08 22:40:24Z

0

The quickest way is to issue:

show databases;

answered Sep 8, 2010 at 22:40

zevra0

2711 silver badge5 bronze badges

Collectives™ on Stack Overflow

MySQL Check if a database exists

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related