Easiest way to list table contents

Discussion in 'Databases' started by raymond222, Jun 17, 2008.

0
  1. #1
    What is the easiest way to list all the contents of table, like
    ID|Name|location|
    1 |john |UK |
    2 |adam |Ireland|
    etc etc...
    Less lines of code is better

    Thanks very much!
     
    raymond222, Jun 17, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Select * FROM table;
     
    jestep, Jun 17, 2008 IP
    viitols likes this.
  3. raymond222

    raymond222 Active Member

    Messages:
    287
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #3
    edit: everything is cool now, I got that myself, thanks!
     
    raymond222, Jun 17, 2008 IP