I'm using the notepad to type out all the code...
create table and database....
but i dunno how to load the *txt in the mysql...
where the *txt have to put???
can someone tell me ?
MySQL Server
Last Comment
kmorris1186
8/22/2022 - Mon
kmorris1186
You still need to set up databases and tables right?
Using these, you can create DBs, Tables, users, etc. All in a user friendly GUI.
wcpon
ASKER
what i mean is...
I'm already creat DBs, Tables in the notepad txt files...
then now... how to use the mysql to call the txt files ?
so i no need to type in mysql software...
and all the modify or errors... me just want to change in the txt file only....
what is the keyword to call the txt files???
kmorris1186
once you are in MySQL, you can just type the command.
Copy and paste from notepad into the MYSQL Dos Window.
I dont know if you can do "Bulk" statements. But, copy and pasting them will work just fine.
OR
Use the Query Browser that i suggested in the above post. Then you can copy/paste in there as well.
For building Querys.
Mainly used for people that dont know SQL real well. I can build them faster by hand, but if you are still learning SQL, then this can help you.
wcpon
ASKER
oh i see......
is it.. the website u gave....
can download it ?
i'm using window...
which one i want to download?
I personally like MySQL Control Center better then MySQL Administrator. But they both do almost the same thing. Control Center will allow you to execute queries as well. I just downloaded Query Browser earlier today, so i havent figured out everyhthing it can do yet.
Why not just use one of the front ends?
http://dev.mysql.com/downloads/administrator/1.0.html
http://dev.mysql.com/downloads/other/mysqlcc.html
http://dev.mysql.com/downloads/query-browser/1.1.html
Using these, you can create DBs, Tables, users, etc. All in a user friendly GUI.