Create MySql Database using Matlab

Question

I am using Database toolbox of Matlab to run my MySQL queries. I am doing this by using JDBC driver (Connector/J).

I am able to connect/create/delete new tables for a given database.

Is there a way by which I can directly create a new database from Matlab itself? I'm looking for a solution which lets me do this by using the toolbox or by using Java from Matlab.

Yes, you can create new database from Java application itself. For example, if you use Derby database. But, I think you can't programaticaly create database when it comes to MySQL. — Branislav Lazic
– Branislav Lazic, Commented Aug 7, 2013 at 11:26
If you can run plain SQL commands using your toolbox, you could try create database dbname. If your toolbox supports dynamic JDBC-URLs to connect to databases not known at compile-time, you could try that way. — Beryllium
– Beryllium, Commented Aug 7, 2013 at 11:30
I think, we can create database using PHP and Python programaticaly — Zero
– Zero, Commented Aug 7, 2013 at 11:30
Actualy, my bad. Seems you can create MySQL database programaticaly. Have a look at this question — Branislav Lazic
– Branislav Lazic, Commented Aug 7, 2013 at 11:31

Zero · Accepted Answer · 2013-08-07 12:33:54Z

3

Here's what I have used. In Matlab this works.

import java.sql.*;

ConnD = DriverManager.getConnection(...
'jdbc:mysql://localhost/?user=urname&password=urpassword');

sD=ConnD.createStatement();
Result=sD.executeUpdate('CREATE DATABASE urdatabasename');
sD.close();
ConnD.close();

Mind you, this doesn't include error handling and checks. Make sure you handle your data carefully.

answered Aug 7, 2013 at 12:33

Zero

77.4k22 gold badges153 silver badges153 bronze badges

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

1 Comment

Naseef Chowdhury Over a year ago

Is it can be used directly in matlab? Do I need to do anything else for importing java.sql?

Collectives™ on Stack Overflow

Create MySql Database using Matlab

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related