30 users online (0 members and 30 guests)  


  Results 1 to 4 of 4
  1. #1
    springo707's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Jul 2002
    Location
    Kansas City MO
    Posts
    42

    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

  2. #2
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    Hi,

    few ways to do it. If the machine you have the mysql on is a *nix machine, just do

    Code:
    # mysql -p -uusername databasename
    And you have a mysql> prompt which accepts queries.

    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?

  3. #3
    TalonStriker's Avatar
    New User

    Status
    Offline
    Join Date
    Oct 2003
    Posts
    8
    why don't you use phpMyAdmin?
    Its easy, no mysql knowledge required (for the most part)

  4. #4
    madpenguin2's Avatar
    New User

    Status
    Offline
    Join Date
    Apr 2005
    Posts
    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]
    PASSWORD: sqlrules

    now, your in!

    Brett



Tags for this Thread