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,118
    Rep Power
    4274
    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?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  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,118
    Rep Power
    4274
    Originally Posted by john5455
    wats is required to see records?
    SELECT .. FROM tablename
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  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,118
    Rep Power
    4274
    Originally Posted by john5455
    i need to show the records which have been added using a show command
    um...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  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,118
    Rep Power
    4274
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo