Avatar of wcpon
wcpon
 asked on

how the *txt transfer become data?

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

Avatar of undefined
Last Comment
kmorris1186

8/22/2022 - Mon
kmorris1186

You still need to set up databases and tables right?

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.
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.

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
wcpon

ASKER
not got a keywords to load the txt files directly ????

i know got... but i forgot what keywords is it...
ASKER CERTIFIED SOLUTION
kmorris1186

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
wcpon

ASKER
THank You very much !!!!!!!!!!!!!
kmorris1186

No problem!

I still suggesting getting one of the mentioned programs.  I am currently using MySQL Control Center, and Query Browser.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
wcpon

ASKER
Query Browser
is use for what purpose ??
kmorris1186

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?
Your help has saved me hundreds of hours of internet surfing.
fblack61
kmorris1186

Try these links.  These should be what you need for Windows XP/2K

Query Browser:
http://dev.mysql.com/get/Downloads/MySQLAdministrationSuite/mysql-query-browser-1.1.5-win.msi/from/http://mysql.he.net/

MySQL Administrator:
http://dev.mysql.com/get/Downloads/MySQLAdministrationSuite/mysql-administrator-1.0.19-win.msi/from/http://mysql.zawodny.com/

MySQL Control Center:
http://dev.mysql.com/get/Downloads/MySQLCC/mysqlcc-0.9.4-win32.zip/from/http://mysql.he.net/

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.