Questions tagged as 'mysql'

Tagged questions
1
answer

Save dataset C #

I'm looking for multiple database tables for Dataset through Stored Procedure on MySQL using MySQL Workbrenck, but at the time of saving only the first table is saved, my code: Stored Procedure: CREATE DEFINER='root'@'l...
asked by 23.11.2016 / 01:06
1
answer

Mysql Create a database for a single user

I want to create a database where only one user can access the information. Although there are already users created on the server, but only the user I create has to be the only one to have access to a particular database. I'm just getting the r...
asked by 16.12.2016 / 11:08
0
answers

Changing MySQL with ajax and PHP

I have created a system that allows the user to view data from a mysql database and eventually interact with that data (by changing the select column in the database). Currently there is a php script that runs when the user selects the ne...
asked by 15.06.2017 / 18:54
1
answer

Webservice php without using soap? [closed]

I'm not familiar with Webservice and wanted to know how to make one, without the need to use Soap (to grab data from the bank and consume it in Android Studio).     
asked by 21.10.2016 / 11:13
1
answer

MYSQL - Select 2 tables

Good morning everyone! I'm having a problem querying MYSQL, and the query I'm using is not displaying the results you want. Here's the example: TABLE: CLIENTES (codigo_cliente, nome, cnpj) TABLE: HISTORICO_CONTATOS (protocolo, co...
asked by 08.11.2016 / 14:08
1
answer

Doctrine 2 INNER JOIN with Subquery

I'm migrating my queries to doctrine using QueryBuilder . And I have a inner join query with a subquery , I'd like to know how to do this using doctrine . SELECT p.* FROM produtos p INNER JOIN (...
asked by 10.11.2016 / 20:33
0
answers

MySql multiplication between values of decimal type loses the precision

In my application I need precision for numeric values of 12 decimal places. I created the following test: CREATE TABLE TESTE ( VALOR1 DECIMAL(16,12), VALOR2 DECIMAL(16,12), VALOR3 DECIMAL(16,12) ) INSERT INTO TESTE (VALOR1, VAL...
asked by 21.02.2017 / 00:51
0
answers

Connection MySQL Workbench in PHPmyAdmin?

Good morning. I'm trying to make a MySQL Workbench remote connection on my AWS cloud, where PHPmyAdmin is installed, but I'm not getting it. The displayed error is: I've searched Google for this error but nothing effective. Could...
asked by 29.09.2016 / 13:52
1
answer

Add the same column by different criteria?

I'm trying to create a report using ReportViewer that makes a SUM in the same column by different criteria. My query works fine in PHPMyAdmin but in QueryBuilder the ReportViewer does not work and returns an error. How to solve...
asked by 29.09.2016 / 06:10
1
answer

MySQL query problems

I am having difficulty querying between 4 tables, being them. States > Municipalities > Deaths > Population The query is returning the value of the population with a higher than true number ... Can anyone help me with this query? se...
asked by 05.10.2016 / 21:43