Thread: Show command

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    4
    Rep Power
    0

    Show command


    hi guys

    i have been creating a database in cmd and i have inserted 100 records into the database, i now need to use the show command to display these fields. i know a select statement is easily used but for this question it wants the fields displayed using the show command, thanks would appreciate youur help.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,027
    Rep Power
    4210
    Originally Posted by john5455
    ... but for this question it wants the fields displayed using the show command
    homework assignment?

    why don't you look up the SHOW command in the mysql manual and give it a try?
    r937.com | rudy.ca
    please visit Simply SQL and buy my book
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    4
    Rep Power
    0
    Originally Posted by r937
    homework assignment?

    why don't you look up the SHOW command in the mysql manual and give it a try?
    i just need help on the syntax for show please help, i know select * from table name;
    will do samething;
    show table name; only provides the desginof the table wats is required to see records?
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,027
    Rep Power
    4210
    Originally Posted by john5455
    wats is required to see records?
    SELECT .. FROM tablename
    r937.com | rudy.ca
    please visit Simply SQL and buy my book
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    4
    Rep Power
    0
    Originally Posted by r937
    SELECT .. FROM tablename
    thanks for your reply r937 i am already aware of the selct statement, i need to show the records which have been added using a show command
  10. #6
  11. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,027
    Rep Power
    4210
    Originally Posted by john5455
    i need to show the records which have been added using a show command
    um...
    r937.com | rudy.ca
    please visit Simply SQL and buy my book
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    4
    Rep Power
    0
    Originally Posted by r937
    um...
    are you able to do it?, ur help would be greatly appreciated
  14. #8
  15. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,027
    Rep Power
    4210
    Originally Posted by john5455
    are you able to do it?
    i don't think anybody can

    after you get your paper back from the assignment, i would very much like to know what the solution using SHOW was
    r937.com | rudy.ca
    please visit Simply SQL and buy my book

IMN logo majestic logo threadwatch logo seochat tools logo