INTERVAL -1 month))UNION ALL
> SELECT(STR_TO_DATE(CONCAT(year(curdate()),'/',month(curdate()),'/1'),
> '%Y/%m/%d'))
>
>
> ** In one query (as row)***
>
> Anyway it's look like I will have to live it that way
>
>
You can use temporary table if you want short statement.
On Mon, Apr 7, 2008 at 9:24 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Thu, Apr 3, 2008 at 3:25 AM, nataliew
> <[EMAIL PROTECTED]> wrote:
> >
> > I need querylike this that make a row of numbers (in one execute)
> >
> > SE
Hi,
On Thu, Apr 3, 2008 at 3:25 AM, nataliew
<[EMAIL PROTECTED]> wrote:
>
> I need querylike this that make a row of numbers (in one execute)
>
> SELECT a from (
> SELECT -1 a UNION ALL
> SELECT -2 UNION ALL
> SELECT -3 UNION ALL
> SELECT -4 UNION ALL
> SELECT -5 UNION ALL
> SELECT -6 UNIO
:
http://www.nabble.com/Can-some-one-help-me-write-it-shorter--tp16467090p16467090.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]