On 04-Aug-2003 Miroslav I. wrote:
<snip>
> You need every field except the 'dateOB' and 'idSCHOOL'
>
> Ordinary select wold be:
>
> SELECT
> id,name,surname,idCITY,idSTATE,sex,idParent1,idParent2,interests,weight,he
> ight,age,auditDate,idAudittor, ....
> FROM TName
>
> It is too long expression,
> is there a way to specify only 'dateOB' and 'idSCHOOL' - the two column
> that are unwanted in the result set - in order to make the SELECT
> shorter? The SELECT should return every column but the specified ones.
You can use your language constructs, -- for PHP 'unset($var)' or
in Perl 'delete $var'.
PHP example:
echo '<table>';
$res=mysql_query('SELECT * FROM TName');
while ($row=mysql_fetch_array($res) ) {
unset($row['dateOB'], $row['idSCHOOL']);
echo '<tr><td>', implode('</td><td>', $row), '</td></tr>';
}
echo '</table>';
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
