I added a column in the Users table, invited is an integer.
I need to do a select in the table by filtering this field, and I get the following error:
android.database.sqlite.SQLiteException: no such column: invited (code 1):, while compiling...
EXAMPLE :
I have two tables:
table1 : with two columns product_id , product_name ;
table2 : With three columns tag_name , product_id , tag_name
I would like to create a table3 from a selection of table1 and table2 with...
I have multiple clients connected to a database.
These clients make queries, almost at the same time, causing me a headache, when 2 clients get the same result as a select.
How do I know when a table is busy or even lock this table until o...
I am making a query in MySql to return the quantity of requests that have not been delivered.
To see the ones that have been delivered I do:
$result = mysql_query("SELECT operacional FROM 'pedidos' WHERE 'status' = 'ENTREGA REALIZADA'");...
OPa,
I have two tables: forma_pagamento and forma_pagamento_selecionada .
I have a while where all forms of payment should be listed, so in this while you must have a IF condition where a new column will return me, in c...
I have 2 tables:
FATHER:
id
nome
Child:
id
idpai
sexo_filho
I wanted to do a SELECT that sums up the amount of children man and women, that's the problem, I can only do with one of the sex:
SELECT pai.nome, count(distinct filho.id...
I have a table of provas and a table of alunos that have no direct relationship, I still have a inscrição aluno table and a escolas table, as follows in the modeling below:
Ineedtocreateaselecttobringhowmanystudents...
How can I do a SELECT in MYSQL with PDO next to it below:
$buscarNoticiaTitulo = "noticias.titulo LIKE '%teste%'";
$sqlNoticias = $pdo->prepare('SELECT * FROM noticias WHERE :buscarNoticiaTitulo');
$sqlNoticias->execute(array("buscarNoti...
I am a beginner in SQL and am having difficulty using CASE WHEN .
I have a table called CRM_PROCESSO , in which there is a column with the Status option, but the answer for this status is numeric, being 1 - Aberto ,...