Results 1 to 4 of 4
HTML input question, how do I add an input field to a single URL? Forum: HTML ForumReplies: 15
03-08-2005, 06:20 PM #1
The single dumbest mysql question
Ok, I am feeling a little blonde - I created a table using MySQL Administrator.
Now I have a couple of issues.
I found the table in the mysql\data folder. I see four files - classes.frm, classes.myd, classes.myi and dp.opt (yes, the takle is called "classes").
How do I open the table for viewing and how do I add data to the table. I am going through the manual on the mysql website and I see no categories for data entry. It mentions data sources, but excuse me, that is what I want this database to be - a source of data. How do I get the data into the table?
Have not worked with databases before.
Thanks for not laughing too loudly
03-08-2005, 07:58 PM #2
few ways to do it. If the machine you have the mysql on is a *nix machine, just do
# mysql -p -uusername databasename
If not, the single most useful tool for mysql is called phpMyAdmin, its a web-based mysql management tool.If one of our members helps you, please click the icon to add to their reputation!
No support via email or private message - use the forums!
Before you ask, have you Searched?
03-15-2005, 10:20 AM #3
04-07-2005, 07:36 PM #4
on a windows machine, open a command prompt (press start, then choose run, enter cmd). Next go to the bin directory of the directory mysql is installed in. type mysql -u username -p. mysql will prompt you for the password.
assuming you set up a root account with password 'sqlrules' it would be
c:/mysql/bin/mysql -u root -p [ENTER]
now, your in!