Posts by ahniraf • 73 points
3 posts
-
2
votes3
answers1436
viewsA: SQL - Two different WHERE conditions for the same SELECT
From what I understand it should solve your problem: set @show = 1; SELECT * FROM banco.tabela where if(@show = 1,d.statusId = ds.id,d.statusId != 3); "This is a functional example ai Voce adapts…
-
5
votes2
answers1140
viewsQ: How to make an Insert with columns and values coming from a select?
Imagine the following situation: Run a query in a database to acquire a particular record line, and then enter it again in the same table at the end of the records. It is possible that I can enter…
-
0
votes3
answers77
viewsA: Color change with jQuery
This way it works if I understand well what you want!!! $('.colors').css("color","blue"); $('.colors').click(function(){ $('.colors').css("color","blue"); $(this).css("color", "red"); });…