"Miroslav I." <[EMAIL PROTECTED]> wrote: > > suppose you have a table with great number of columns (20 or 30), > and you would like to specify every one but two or tree columns in a SELECT > statement. > > Is there a way to specify only those two or tree columns for omission (which would > be the 'short' way to do the job) instead of specifying every column that needed > (which would be the 'long' way to do the job). > > Example: > > The 'TName' table header: > > id | name | surname | dateOB | idSCHOOL | idCITY | idSTATE | sex | idParent1 | > idParent2 | interests | weight | height | age | auditDate | idAudittor | .... > > You need every field except the 'dateOB' and 'idSCHOOL' > > Ordinary select wold be: > > SELECT > id,name,surname,idCITY,idSTATE,sex,idParent1,idParent2,interests,weight,height,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't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]