How to create new MySQL databases/tables from a Lazarus application?
lazarus / 16-Databases

----------------------------------------------------------------------
Kyjan · 2009-09-20 06:45

Hi everyone,

i tried to google, and read many forums on this site, but i was unable
to found the solution. My problem is that I'm writing an installer for
my program which uses a mysql database. I don't want - and maybe the
users don't want, too - configure the mysql database through
phpmyadmin. So I tried to figure it out how can I create the mysql
database from the installer app. Please help, this is the final step
and after i can give the program to the customers.

Thanks,
Kyjan

----------------------------------------------------------------------
Kyjan · 2009-09-20 07:19

Okay, I found the solution:

Code: [Select]SQLQuery.SQL.Text:='create database `dbname`';
SQLQuery.ExecSQL;

This is all

Kyjan

----------------------------------------------------------------------
Loesje · 2009-10-03 21:52

Or: TmysqlConnection.CreateDB(..)