add a default row

Results 1 to 2 of 2

Thread: add a default row

  1. #1
    Join Date
    Dec 1969

    Default add a default row

    select id, name from tablenames <BR><BR>produces<BR><BR>id &#124 name<BR>-----------<BR>0 kevin<BR>1 joe<BR><BR>how do I add a row to this? (99, default)<BR><BR>where this is a bogus row not existing in the database? I want it to be with the output of the sql statement, but never added to the table.

  2. #2
    Join Date
    Dec 1969

    Default Huh?

    select id, names from produces<BR>union<BR>select 99, &#039;default&#039; as names<BR><BR>Like that?

Posting Permissions

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