Posts by Anderson Imperatori • 56 points
3 posts
-
0
votes1
answer55
viewsA: How to use a column calculated in the WHERE clause of SQL?
You can do it using a new query, where the result of it will be only the average of wages. SELECT AVG(Salario) FROM Empregado In the main query it would be, reduced SELECT * FROM Empregado e WHERE…
sqlanswered Anderson Imperatori 56 -
0
votes1
answer58
viewsA: Insert data in multiple related tables
When referencing a Foreign key you must have the id of the record that will do the relation in advance. In your modeling the two tables have Foreign key for each other. This way one prevents the…
-
1
votes1
answer144
viewsA: Assign value of a textarea to a var and display in a paragraph
You will need a form, which at the click of the button will submit your textarea. <form method="POST"> <textarea name="texto_a_ser_submetido" class="wapf-input" ></textarea>…