The idea is:

I want to create a visual environment for MySQL.

What will it do or how does it work:

According to the actions in the environment, MySQL code will be generated. Ie, let's say the user clicked on the "+" icon. Then the code is generated: CREATE DATABASE something;

I can handle this. The main problem is as follows:

How do I get the resulting code to then interpret in the MySQL debugger and create a .sql or dba file? Or can I just create a file with this extension and no longer need to interpret it ???

And if I created a file with this extension, how can I execute it ??? Can I somehow connect my program and the MySQL debugger (command line, which) after creating the file, inside the program, execute it and create a database?

I hope I could somehow bring my thoughts to you. If not, ask in the comments, I will answer you. Thanks in advance!

PS I will create a program in C ++ or in C #.

    2 answers 2

    You need:

    1. Create a file with a .sql extension and write your executable code into it.
    2. Run the execution of the sql script through the MySQL debugger using the language tools, for example Process.Start () or so
    • At the same time, the MySQL debugger itself should be available on the user's computer. And what to do, what to do if the debugger is not installed there. How do I install the debugger myself? And yet, you can not somehow merge, link, debugger with your program. How to make one? - navi1893
    • Sorry, I probably confused the concept of a MySQL debugger and a simple MySQL console. I assumed that after the script.sql file is created, you can start its execution using the usual MySQL console, via Process.Start () or by other means of the language. - Rams666

    Tell me in secret, what you do not like the already existing "visual environments" for working with muscle?
    Here is the first Google result: Top 10 MySQL GUI Tools .

    • one
      Then why should I study as a programmer if everything is ready already ??? - navi1893
    • 3
      Well, just some parts of the question you have are such that, I think, you first need to learn from Google and the reader of the documentation before the programmer. I suppose that this kind of resources (like this or stackoverflow) are meant for solving ambiguous complex engineering tasks, and not for “I'm too lazy to read mana, how can I get zbs to be on such-and-such?” - actionless
    • one
      If you do not want to help, why comment? Nothing useful from you right now - navi1893
    • useful - read how to work with the database on the Japanese that you are going to write on - actionless
    • 3
      btw, on stackoverflow, it is usually closed as: This question is ambiguous, incomplete, overly broad, or rhetorical and cannot be answered in its current form. - actionless