Re: Re: Very complex query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



El Jue 11 Dic 2003 05:00, Muhammed Mamedov escribió:
> You can also DISTINCT command instead.
> UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am
> using)

UNIQUE is for table creation or index creation. It is relevent for insertion, 
not selects.
DISTINCT and DISTINCT ON() are used in SELECT statements.

-- 
 15:49:01 up 15 days, 22:05,  3 users,  load average: 1.12, 0.79, 0.61
-----------------------------------------------------------------
Martín Marqués        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux