Questions tagged as 'mysql'

Tagged questions
1
answer

Complex bank type extract MySql how to solve

I have a VIEW table that I need to extract an extract from it, I've already been able to help with stackoverflow here for an extract. The problem is that now I need to filter this extract a little more, separating it for a given ID, but when...
asked by 10.09.2015 / 06:00
2
answers

How to pass business id to the employee table? [closed]

I have a company table and another employee. Company table : id_emp | tipo | documento | fantasia | email | celular | senha | data_cadastro | ativo Example: 1 | pessoa juridica | 05.142.333/0001-21 | petstop caes e gatos | petshop@gm...
asked by 22.11.2015 / 14:01
3
answers

How to force read all the results in REST on a page?

foreach ($result as $indices) { // Aqui ele retorna 50 registros por conuslta echo $indices['Empreendimento']; // Provavelmente preciso de um loop da paginação aqui dentro // para falar para o foreach que enquanto houver paginaç...
asked by 28.11.2015 / 15:10
1
answer

Error coding html text in MySQL

I'm having trouble sending accented texts to the database as words with Ç Ã etc. Let's say I send text like this This is a post action for you What happens and only sends ata That and a the rest of the text is not being sent this giv...
asked by 07.08.2015 / 07:32
2
answers

PHP - Problem with return search INNER JOIN with GROUP BY!

So, I have 3 table: user: | ID | NOME | SOBRENOME | | 01 | Igor | Ferreira | | 02 | João | Henrique | | 03 | Rose | Beltão | following: | ID | user1_id | user2_id | | 01 | 01 | 02 | User 1 > Segue...
asked by 30.07.2015 / 20:20
2
answers

How to get the sum of three tables in sql

I have 3 Tables, which are: School: id , id_escola and nome_escola ; Teacher: id , id_escola and nome_professor ; Students: id , id_escola , sala_aula and numero_alunos ;...
asked by 30.07.2015 / 16:55
1
answer

Test connection to the database

I have an application that has a central database, in it is made the registration of several databases dynamically to use in another part of the application. I want to know how to test if there is a connection to this database. I currently ha...
asked by 18.06.2015 / 21:50
2
answers

How do I connect a database in a JAVA application

I have a Java application and a MySQL database connected to this application on my machine. The application will be distributed to other machines on the same network, but I can not make the banco de dados connection to other...
asked by 03.06.2015 / 16:39
1
answer

Ajax Address Search with PHP

I have a form with the list of clients. When selecting the client, I want it to automatically fill in the address, number, neighborhood and city fields. I have Ajax, but I do not know how to work out the return of it. var id = $('#cliente')...
asked by 09.06.2015 / 19:22
2
answers

Conversion specified is not valid in ExecuteScalar

The specified conversion error is not valid in the code: if (command.ExecuteScalar() == DBNull.Value) { resultados[j2][i2] = 0; } else { resultados[j2][i2] = (double)(decimal)command.ExecuteScalar(); /* <<---- */ } The query...
asked by 26.01.2016 / 20:40