Este grupo especializado despúes de varios días de trabajo y de recopilar de datos, dieron con los datos necesarios, nuestro deseo es que resulte de gran utilidad en tu proyecto.
Ejemplo 1: caso de mysql
-- LABEL MOVIE LENGTH select title, length,CASEwhen length <50then'very short film'when length <90then'short film'when length <120then'medium length film'when length >120then'long film'else'unknown length'END-- AS film_lengthfrom film;-- SAME AS ABOVE BUT ON A CUSTOM NAMED COLUMNselect title, length,CASEwhen length <50then'very short film'when length <90then'short film'when length <120then'medium length film'when length >120then'long film'else'unknown length'ENDAS film_length
from film;-- RESULT+-----------------------------+--------+--------------------+| title | length | film_length |+-----------------------------+--------+--------------------+| ACADEMY DINOSAUR |86| short film || ACE GOLDFINGER |48| very short film || ADAPTATION HOLES |50| short film || AFFAIR PREJUDICE |117| medium length film || AFRICAN EGG |130| long film || AGENT TRUMAN |169| long film || AIRPLANE SIERRA |62| short film || AIRPORT POLLOCK |54| short film || ALABAMA DEVIL |114| medium length film || ALADDIN CALENDAR |63| short film || ALAMO VIDEOTAPE |126| long film || ALASKA PHANTOM |136| long film || ALI FOREVER |150| long film || ALICE FANTASIA |94| medium length film || ALIEN CENTER |46| very short film |
Ejemplo 2: caso de conmutador mysql
SELECT
t2.company_name,
t2.expose_new,
t2.expose_used,
t1.title,
t1.status,CASEstatuswhen'New'and t2.expose_new =1then1when'New'and t2.expose_new =2then2when'New'and t2.expose_new =3then3when'Used'and t2.expose_used =1then1when'Used'and t2.expose_used =2then2when'Used'and t2.expose_used =3then3ENDas expose
FROM`products` t1
join manufacturers t2 on t2.id = t1.seller
where t1.seller =4238
Si crees que ha resultado de utilidad este artículo, te agradeceríamos que lo compartas con otros desarrolladores de esta forma contrubuyes a extender esta información.
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)