Create a database at runtime

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sergioannis
Posts: 1
Joined: Sun 25 Jan 2009 17:19

Create a database at runtime

Post by sergioannis » Sun 25 Jan 2009 17:25

Hi,
is possible create a database Mysql at runtime with Mydac .
Tenks.
Sergio
Top
jkuiper
Posts: 138
Joined: Fri 04 Aug 2006 14:17

Post by jkuiper » Mon 26 Jan 2009 08:53

Yes, use TMyScript to put all your queries in it.
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 26 Jan 2009 16:06

To create a database you should use the 'CREATE DATABASE' statement, like this:

Code: Select all

MyConnection.ExecSQL('CREATE DATABASE database_name', []);
After this you can set the Database property to the new database name.
Top
Post Reply

Return to “MySQL Data Access Components”