I want to put a condition for each column in my SELECT, is it possible?
SELECT count(id_casa) as casaAzul, count(id_casa) as casaAmarela FROM tb_casa
Where:
Where column 1: where cor_casa = 'azul'
Where column 2: where cor_casa = 'yellow'...
I'm having an error: every time the variable c.Value_value passes the SQL string, automatically, the "." which separates the Decimal is converted to ",".
Asyoucanseeinthisimage,thevariableisusingthe"." usually.
However,theSQLstringtakest...
Hello, I'm a beginner in php and javascript and I'm having a hard time creating iterative tables.
In my case, I have an initial table: WhenIselectthelinethatIwanttochecktheaccidentsinmoredetail(incasetheoptionisSãoPaulo),anewtableisopenedinadia...
Can you copy a record from a table and insert it into it?
I wanted to copy a record into a new one in the same table.
INSERT INTO Produtos ( Produto, Preco )
SELECT Produtos.Produto, Produtos.Preco
FROM Produtos
WHERE (((Produtos.Produto)="AN0...
I need to create a stored procedure to update the salary of employees who earn less than 1000 and give a 10% increase. Other employees (who earn over 1000) will have a 15% reduction. I've done the following:
DELIMITER $
CREATE PROCEDURE mod...
I have a MYSQL database and I need a SQL that looks at the DAY OF PAYMENT in the DIA field (this field will only have the DAY of the month that the client chose to make the payment, this field is of type INT) and show me some less than 5 days be...
I'm making a program that allows the user to enter the ID of the person in question, and then displays all the data in a table.
So far, I have these two codes:
<!doctype html>
<html lang="en">
<head>
<m...
I have the following query inside a jsp file in Java.
String sql = "SELECT * FROM products WHERE productName = ? ";
I'd like my query to ignore camel case and return all words that were part of string . For example, Desktop...