#1
  1. No Profile Picture
    rbolkey
    Guest
    Devshed Newbie (0 - 499 posts)
    I'm trying to create a query that will select all the columns in my table and add a temporary one based on a calculation with the data in another column. If it's possible I assume it's using the JOIN and AS parts of a SELECT query, but i keep getting syntax errors or something. Any help is appreciated.

    thanks
    rick
  2. #2
  3. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    Your comment is a little confusing, but could you mean something like this?


    select column1,column2,column1+column2 as total from tableName;

Similar Threads

  1. LOAD DATA into table, ignoring some columns?
    By baddy in forum MySQL Help
    Replies: 1
    Last Post: September 18th, 2003, 12:35 PM
  2. temporary tables, and copying records
    By brainfuelmedia in forum MySQL Help
    Replies: 0
    Last Post: July 31st, 2003, 06:01 PM
  3. Can't view MySQL table columns in Win installation
    By chaos theory in forum MySQL Help
    Replies: 0
    Last Post: August 15th, 2002, 08:00 PM
  4. Querying multiple columns
    By maxr in forum MySQL Help
    Replies: 2
    Last Post: April 10th, 2002, 03:17 PM
  5. a temporary table called table_stats
    By markdale in forum PHP Development
    Replies: 1
    Last Post: December 20th, 2000, 07:15 AM

IMN logo majestic logo threadwatch logo seochat tools logo