Results 1 to 2 of 2

Thread: What does * mean

  1. #1
    Join Date
    Mar 2010
    Posts
    1

    What does * mean

    I've been looking at some tutorials on the MySQL site http://sqlcourse2.com/select2.html.
    The following:
    SELECT *
    FROM items_ordered
    WHERE item =
    'Tent';
    produces the same results as:
    SELECT customerid,order_date,item,quantity,price FROM items_ordered
    WHERE item = 'Tent';

    What is * doing in this statement.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    * means all columns in the table(view).

Posting Permissions

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