How connect to MySQL database without database name with sqldb?
lazarus / 16-Databases

----------------------------------------------------------------------
aradeonas · 2016-04-30 06:00

It will use for many purposes but I want it to Drop databse and create
it and DropDB function atleaste for MySQL used this :
QuoteDROP DATABASEBut I like to do this :
QuoteDROP DATABASE IF EXISTS

----------------------------------------------------------------------
balazsszekely · 2016-04-30 08:06

Quote@aradeonas
How connect to MySQL database without database name with sqldbYou
can't! Fortunately "information_schema" is always present. It holds
details about all the other databases on the server such as the names
and types of tables, columns and users. So you connect to
"information_schema" then execute whatever query you like:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i procedure
TForm1.Button1Click(Sender: TObject);begin 
MySQL55Connection1.UserName := '';  MySQL55Connection1.Password :=
'';  MySQL55Connection1.DatabaseName := 'information_schema'; 
MySQL55Connection1.HostName := 'localhost';  //... 
MySQL55Connection1.Connected := True; 
MySQL55Connection1.ExecuteDirect('DROP DATABASE TEST'); 
SQLTransaction1.CommitRetaining;end;

----------------------------------------------------------------------
aradeonas · 2016-04-30 09:42

QuoteYou can't! FortunatelyBummer! So it seems a bug because there is
a need for that.
QuoteFortunately "information_schema" is always present. It holds
details about all the other databases on the server such as the names
and types of tables, columns and users. So you connect to
"information_schema" then execute whatever query you likeGood point!
thanks.