Questions tagged as 'mysql'

Tagged questions
1
answer

How to know if an insert was made in Mysql database

I need to create a webservice in which I can verify in a Mysql database if a new record is added to a table. This in order to call the webservice in a thread as an android service so that when a new record is added send a notification. What h...
asked by 15.09.2017 / 16:02
1
answer

access the database of a php application on a server lin

I'm working with Plesk Onix Version 17.5.3 update # 21. The server is Ubuntu 16.04.2 LTS Php version 5.6.30 php extension: mysqli, curl, mbstring phpMyAdmin version 4.6.6 The fact is that I use the option "export dump" of the database with th...
asked by 14.09.2017 / 19:20
2
answers

MYSQL - Show in 2 fields a query to a single field

I have a payment table where in a field called ESTADO_COMPRA shows the following values ( EN CRÉDITO, PENDIENTE DE PAGO ), then I want to count in fictitious fields those that still have credit and those that have already expired wi...
asked by 23.08.2017 / 20:02
2
answers

Use result of SELECT as table name for another SELECT

I have a table of the following style Father |----|------- |-------| | id | precio | tabla | |----|------- |-------| |1 | 50 | sxt | |----|------- |-------| |2 | 45 | ext | |----|------- |-------| then I have other tables...
asked by 29.08.2017 / 00:29
1
answer

Symfony Doctrine: Unable to create database

I'm following this tutorial:    link and I get this error:    Could not create database symfony for connection named default An   exception occurred in driver: SQLSTATE [HY000] [1045] Access denied for   user 'root' @ 'localho...
asked by 09.09.2017 / 13:29
2
answers

Merge record of one table with SUM of another for each record

As part of my database I have 2 tables (clients and loans), of which I am interested in operating with the following fields: LOANS: (Customer ID, Loan Amount) CLIENTS: (Customer ID) Consider that a client can have several loans....
asked by 08.09.2017 / 05:23
2
answers

Errors when creating SQL DB

I am using MySQL Workbench to create a BD and it gives me the following error, I am still new in this I hope you can help me. The error is as follows: Executing SQL script in server ERROR: Error 1005: Can't create table 'bd_easymaker_0'.'equip...
asked by 08.09.2017 / 18:36
1
answer

Can it be added directly in a mysql query?

I would like to know if there is a possibility to update a field in mysql, if you can see what was previously to add the new amount. I have a field of units that has an XX value and I want to add a new quantity. Normally I make a query first...
asked by 21.08.2017 / 19:19
1
answer

Condition sums of a select

I have a table with the following structure: codigo / periodo / signo / importe I want to get the following: codigo / saldo_anterior / cargo_actual / abono_actual / saldo The period field is integer (YYYYMM) If for example I am in the...
asked by 09.11.2017 / 17:45
2
answers

Pass data from a table html to mysql from jsp

Greetings, I appreciate your kind support. I have a form to register products that are added to the table but I have no idea how to send them to mysql dede JSP . <form id="detalle_boleta" class="form-horizontal" method="get" action="D...
asked by 14.12.2017 / 23:55