Professional Web Applications Themes

REPOST - Wildcard aliases - MySQL

Is there a way to do <snip>SELECT table.* AS alias.*</snip>, or do I have to write additional code to automate the process? This message was reposted because it had expired, even though it was only up for less than an hour, and disappeared along with the excellent response that I had received to it. -- Regards, Jeff Gardner ___________________________ "Contrary to popular belief, Unix is user friendly. It just happens to be very selective about who its friends are." --Kyle Hearn...

  1. #1

    Default REPOST - Wildcard aliases

    Is there a way to do <snip>SELECT table.* AS alias.*</snip>, or do I
    have to write additional code to automate the process?

    This message was reposted because it had expired, even though it was
    only up for less than an hour, and disappeared along with the excellent
    response that I had received to it.
    --

    Regards,

    Jeff Gardner
    ___________________________

    "Contrary to popular belief, Unix is user friendly. It just happens
    to be very selective about who its friends are." --Kyle Hearn
    Jeff Guest

  2. #2

    Default Re: REPOST - Wildcard aliases

    Jeff Gardner wrote: 

    No.
     

    Yes.

    Regards,
    Bill K.
    Bill Guest

  3. #3

    Default Re: REPOST - Wildcard aliases

    Jeff Gardner wrote: 

    Usenet messages don't expire. They are around forever. You can find
    postings in archives from 15 years ago. And I can still see your old
    message and the response.

    Check your newsreader settings. Or look at the Google Groups archive of
    his newsgroup.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  4. #4

    Default Re: REPOST - Wildcard aliases

    On Sat, 16 Sep 2006 17:07:55 GMT, Jeff Gardner wrote: 

    How is what you are asking for different from

    SELECT * FROM MYTABLE MYALIAS
    WHERE MYALIAS.COLNAME = 'value';

    --
    78. I will not tell my Legions of Terror "And he must be taken alive!" The
    command will be "And try to take him alive if it is reasonably practical."
    --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

  5. #5

    Default Re: REPOST - Wildcard aliases

    Peter H. Coffin wrote: 

    Table names and Aliases are not normally added to column labels. That
    is, when you use the query above, assuming MYTABLE has columns a, b, c,
    you get a result set back columns with labels a, b, c. You don't get
    mytable.a, mytable.b, mytable.c, nor do you get myalias.a, myalias.b,
    myalias.c.

    I interpreted the OP's question that he wanted the table name included
    in the label.

    Regards,
    Bill K.
    Bill Guest

Similar Threads

  1. re-using aliases in SELECT
    By Bart Friederichs in forum MySQL
    Replies: 4
    Last Post: December 8th, 12:38 PM
  2. CFInclude and aliases
    By Tim_Mar in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 26th, 03:55 PM
  3. RFC: field::aliases
    By Kevin Michael Vail in forum PERL Modules
    Replies: 2
    Last Post: September 28th, 01:24 AM
  4. Aliases in Perl?
    By Jeff Westman in forum PERL Beginners
    Replies: 4
    Last Post: October 20th, 04:41 PM
  5. IP-Addresses and aliases
    By Friedhelm Neyer in forum AIX
    Replies: 3
    Last Post: August 6th, 03:49 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139