Results 1 to 2 of 2

Thread: Show command?

  1. #1
    Join Date
    Mar 2013
    Posts
    1

    Question Unanswered: 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 your help.

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    It is not possible to return the rows of data using the "SHOW" command. You need to use a "SELECT" statement to return the fields.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Tags for this Thread

Posting Permissions

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