Free Web Hosting Untitled Document

open source masterhelp,macro, vba, word, cdma, component, delphi, excel

How to create MySQL Database runtime in delphi..?

Generally we always create MySQl database using tool like heidisql, mysql yog, phpadmind and so on. But in this tutorial I will show how to create database and table using delphi by runtime. Many ways to create  MySQL  database with runtime for example :

  • Import sql text by shellexecute to call mysql.exe or call batch file
  • Using Tzconnection
  • Using ZSQLProcessor
  • Using TZQuery
  • or may be using ado component witch connected with ODBC

In this section I will give example how to create MySQL database using Tzconnection

Next… on

Continue Reading…

Print Friendly

Make a Connection to MySQL using Tzconnection

ZEOS is one component package to connect delphi with mysql database. to be able to interact with MySQL database ZEOS requires a library file that is libmysql.dll, the file can be obtained at the time we install heidisql. File position is located in C: \ Program Files \ HeidiSQL \libmysql.dll
we can download heidisql www.heidisql.com site.
ok.. next..

Continue Reading…

Print Friendly
|