Questions tagged as 'mysql'

Tagged questions
0
answers

Passing result of a java program to a database in PostgreSQL [closed]

The result of a token made in Java (Netbeans) to pass it directly to a database generated in PostgreSQL.     
asked by 27.11.2018 / 21:51
0
answers

EVENTS OR REPLACE in MySQL

I have the following table tabla prueba1 id capital_real interes capital_total as (capital_real+interes) so far so good. It turns out that I want each time interval to be calculating the interest with the formula (capital_real * 15 * 1/3...
asked by 24.12.2018 / 07:43
1
answer

How to make a sum of the result of a query?

I hope you can support me, I need to make the sum of the result of the wages that I throw the previous query. The result I need would only be $ 17,500     
asked by 29.11.2018 / 08:59
1
answer

'Can not connect to local MYSQL Server through socket' error when the server is saturated

I have a VPS in ovh with 8gb of RAM and 2 cores (I do not know how many GHz). On Friday at 00h the web with the theme of black friday (500 concurrent users) fell. This error came out:    Link to database can not be established: SQLSTATE...
asked by 26.11.2018 / 09:10
1
answer

Problem loading modules in Perl mysql

This time I have a problem with Perl. I'm making a connection from BD to Perl, but at the time of wanting to connect, it handles some errors. The getAll code: #!/usr/bin/perl use CGI; # Por si hay errores, esto funciona use CGI::Carp qw...
asked by 29.11.2018 / 06:29
1
answer

SQL query does not show table in PHP

I have a query in sql that in the phpmyadmin shows what I need, but when I pass it to the php file it does not show anything, and if I remove the group by it only shows me a row, any suggestions !! (IT WORKS IN MYSQL BUT IN PHP NO) <?php if...
asked by 17.03.2016 / 18:57
2
answers

Query in Mysql to get records that have the same records in another table

I have the following three tables: With the following information: Recipe: Ingredient: RECIPE_INGREDIENTE: Now for example I want to bring the recipes that have the ingredients leche(6) y Azúcar(7) The res...
asked by 23.11.2018 / 02:00
2
answers

array_key_exists (): The first argument should be either a string or an integer

I get this error when I try to Save to the Store public function store(Request $request) { $files = $request->file('links'); $destinationPath = 'boletines'; if($request->hasFile($files)){ $cliente = $request->i...
asked by 26.11.2018 / 19:29
1
answer

Deposit several selected users one by one in database,

The problem that occurs is the following I have a table with checkbox, I click on several to be sent with a file that you select, by clicking on the button to upload file to each user that you select in the view . This is the controller's method...
asked by 22.11.2018 / 18:48
0
answers

Base Relations Mysql -

I'm a little confused with these relationships. I'm doing a game of questions and answers. In a group | Table | a user makes a publication with a series of questions ((in fact, that user who asks questions can only ask them who made the gr...
asked by 02.12.2018 / 02:52