Questions tagged as 'mysql'

Tagged questions
1
answer

count register based on variable

Hello I'm trying to build a mysql registry search by two parameters; name and dates. For example, I need to do a Php run where I give the name of who registered (Box) and dates that the registration occurred (From data x to date y).  So fa...
asked by 09.05.2016 / 19:41
2
answers

How do I make a cpf validator for my database values?

I have the following code, which accepts values in its inputs and then sends them to the database. I want, when the user clicks send, if cpf is invalid (EX: 111.111.111-11), it does not send any value to the database and shows an alert on the sc...
asked by 10.05.2016 / 12:54
2
answers

Save data to multiple tables

I am doing a registration system and would like some help from you in order to save the data in several tables. My registration is composed of the following fields. Nome do Paciente Nome do Doutor Tipo de Serviço Data de Entrada Estagio...
asked by 05.05.2016 / 20:35
1
answer

Mysql UPDATE with JOIN and WHERE [closed]

My tables EMPREGADO Cod_Emp, Nome_Emp COMPANHIA Cod_Comp, Nome_Comp TRABALHA Cod_Emp, Cod_Comp, Salário, Cod_Emp_Supervisor I want to give a 10% increase to all test company supervisors. UPDATE trabalha INNER JOIN companhia ON tra...
asked by 29.09.2016 / 02:08
1
answer

java.lang.NullPointerException in method [closed]

package view; import br.com.genius.dal.ModuloConexao; import java.sql.*; import java.util.ArrayList; import javax.swing.JOptionPane; public class Chamada_ListaCompra extends javax.swing.JInternalFrame { Connection conexao = null; Prepa...
asked by 28.09.2016 / 16:02
2
answers

sql return zero

mysql returns me the following codMunicipio count(codMunicipio) 271 7 273 248 274 18332 275 25 276 4 Because no 272 did not return any, it is not displayed. But I need to retu...
asked by 28.09.2016 / 19:10
1
answer

Web Service for Android app [closed]

I have a question. Assuming I have a web service saving the data in MySQL, this service is responsible for feeding an Android app. The user accessing the app will sync the data to the device's local bank. If the user makes changes and there is n...
asked by 19.04.2016 / 16:46
1
answer

Button that increases the limit of mysql_query

Hello everyone, I'm trying to get the following error: $albuns = mysql_query("SELECT * FROM albuns ORDER BY id DESC limit 4"); Make the limit increase +4 for each time you press, making 8,12,16 boxes appear. <ul>...
asked by 19.04.2016 / 20:00
1
answer

How to know the contents of a foreign key to fill in another table?

I will give 2 tables of a database: User and Address. where the user has the idEndereco attribute as the foreign key of the address table. The ids are with AUTO INCREMENT, yet, how do I know what the foreign key value of the address is? Will I h...
asked by 21.05.2016 / 20:23
1
answer

How to find a term in a mysql database?

How can I search all fields of all tables in a particular mysql database? I need to find a word that I have no idea where it is. In the result you would need the name (s) of the table (s) and the name (s) of the field (s) where the term is....
asked by 08.04.2016 / 21:16