MySQL Forums
Forum List  »  French

Re: MYSQL Mettre des lignes en colonnes
Posted by: big big
Date: February 20, 2012 09:02AM

voila c'est bon j'ai réglé mon problème :

insert into new_table
select u.id_users,u.nom, if(p1.profile=1,p1.profile,0),if(p2.profile=2,p2.profile,0),if(p3.profile=3,p3.profile,0),if(p4.profile=4,p4.profile,0)
from users u, profile p1, profile p2, profile p3, profile p4
where u.id_users=p1.id_users and
u.id_users=p2.id_users and
u.id_users=p3.id_users and
u.id_users=p4.id_users
ON DUPLICATE KEY UPDATE
profiles1 = IFNULL(profiles1,0),
profiles2 = IFNULL(profiles2,0),
profiles3 = IFNULL(profiles3,0),
profiles4 = IFNULL(profiles4,0)

Options: ReplyQuote


Subject
Views
Written By
Posted
3700
February 19, 2012 10:19AM
Re: MYSQL Mettre des lignes en colonnes
1954
February 20, 2012 09:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.