Thank you!!!! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baron Schwartz Sent: Tuesday, January 15, 2008 1:54 PM To: Mark Wexler Cc: mysql@lists.mysql.com Subject: Re: Select multiple rows with no reference table
Hi Mark, On Jan 15, 2008 12:51 PM, Mark Wexler <[EMAIL PROTECTED]> wrote: > Hey folks. I just joined the list. Please let me know if I am not > posting to the correct list. You're in the right list. > > I am trying to use a select statement to retreive multiple records > without a reference table. > > Obviously retreiving a single record is simple enough: > > mysql> SELECT 'value1' AS var1, 'value2' AS var2; > > +--------+--------+ > | var1 | var2 | > +--------+--------+ > | value1 | value2 | > +--------+--------+ > > What I need to do is something similar, but producing multiple records > without referencing any tables: > > +--------+--------+ > | var1 | var2 | > +--------+--------+ > | value1 | value2 | > | value3 | value4 | > | value5 | value6 | > +--------+--------+ You can use UNION for this. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]