Well, I was trying to make an application that inserts products and allows you to view it on the phone through the database, but when I try to create the product the application closes and it appears in my LogCat:
2-18 15:55:27.667: I/Choreogr...
Well I'm here with a problem I have in my system categories in which I enter the products in the various categories that can choose through checkbox only I am now facing a problem and I want to delete a record eg: p>
I have a checkbox selected...
I was trying to make an application for android with connection to MySQL through webservice and it was giving some problems, but I managed to solve it, but it appeared that when I try to see the products registered in my app my LogCat appears th...
Hello, this error
"[Error Code: 1048, SQL State: 23000] Column 'colegiado_id' cannot be null"
It happens when I try to run the SQL command below directly in MySQL:
start transaction;
INSERT INTO EspecialistasColegiados (colegiado_id, esp...
$query = "SELECT COUNT(status) FROM $nomeTabela WHERE status=$numeroStatus AND nomePessoa='$nomePessoa'";
Can you optimize this? There are statuses from 0 to 10 (in this query I need to query only on statuses from 1 to 10 ), I wanted to ign...
For a specific MySQL user, is there a way to lock it so that it does not do the Data Export (DUMP) of a specific table, or the entire database?
I could not find a solution ...
How do you deal with this?
Thank you!
Good people,
I need to make a follow-up system for my site users like notifications but I never did and I do not know where to start, I needed an idea how I can do this system.
I need to make a MySQL query that does the following:
Count the number of times that the same record appears with a difference greater than 15 days, that is:
Record 1 - Date: 01/20/2015
Record 2 - Date: 01/22/2015
Record 3 - Date: 03/...
I have four tables
tabela A aic002
campos :
codigo data nome especie valor rg cpf exped
Tabela B excli
campos
codigo nome rg cpf exped
tabela C imovel
Campos
codigo imovel rua bairro cidade estado
tabela D escritura
codigo data especi...
I'm trying to do an insert in the database but I'm having a syntax problem, I still can not identify the error.
$sql='INSERT INTO tabela
(
nome,
nit,
rg,
cpf,
)
VALUES';
foreach($dados as $li...