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]