Topic: Update, Left Join, Where
SELECT eco_points FROM members LEFT JOIN pfields_content ON members.member_id=pfields_content.member_id WHERE members.members_display_name = 'kubas'
Kaip sujungti sia uzklausa su update?
UPDATE pfields_content SET eco_points = '35' WHERE members_display_name = 'kubas'
Lentele:
pfields_content
Stulpeliai:
member_id
eco_points
Lentele:
members
Stulpeliai:
member_id
members_display_name