Results 1 to 5 of 5

Thread: mysql

  1. #1
    Join Date
    Oct 2011
    Posts
    13

    Red face Unanswered: mysql

    i am acesing mysql database through command prompt.i am new to it.pls tell me first of all how to run select queries and get the data in proper form because data is coming in a very distorted mannner.

    Pls guide me how to wrk on mysql

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    please show example of query that returns "very distorted" data
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2011
    Posts
    13
    pls find in the attahmenet i am suposed to wrk on ms sql thrugh comand prompt but the data i souming in a v ery unmanneredd way
    Attached Thumbnails Attached Thumbnails db.bmp  

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you can either use the MySQL command client or a visual client such as MySQL Workbench, HeidiSQL, PHPMyAdmin or the host of others out there

    as far as I can see your MySQL command line client is working fine. I don't know what the stuff above the last 9 lines is.. but from e:\ptogram files.... everything seems fine.

    I don't know what you mean by 'unmannered' or distorted in this context

    however Id suggest you reopen your MySQL command line client and then issue a few SQL statements

    eg
    show databases;

    select * from mydatabase.mytable;


    replacing mydatabase and mytable with valid names within your schema

    if you are struggling with that then consider downloading somethign like MySQL Workbench from the MySQL site
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by amurark View Post
    pls find in the attahmenet i am suposed to wrk on ms sql thrugh comand prompt but the data i souming in a v ery unmanneredd way
    not sure what you are doing, but the attachment you posted does not shed any light on it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •