Questions tagged as 'mysql'

Tagged questions
1
answer

Calculate the mean values where fields are equal

I have a table, in mysql , which receives some data regarding evaluations. How can I average these evaluations directly in query , based on the question? I tried in many ways, including researching here, and I could not. SELECT perg.pergunta...
asked by 30.08.2016 / 16:18
0
answers

MySQL 2002 error: Can not connect to local MySQL server through socket

I'm just setting up a website for hosting and I've already set up mysqli connections, but I'm giving this error here when trying to run the site:    Warning: mysqli :: mysqli (): (HY000 / 2002): Can not connect to local MySQL server through s...
asked by 11.10.2016 / 23:04
1
answer

How to make the return of a Query (PDO)

How can I make the selected input month to swallow me the selected user's month and year? It is returning the user but when I do the input month to bring the user data for a certain month it does not come. thisisthequerypublicfunctionRetorna...
asked by 03.10.2016 / 23:00
0
answers

How to use PHP Objects and Transaction Control in MySQL?

I have a database with some tables, and I've created a class for handling each table in the bank, one example is one class for requests and another for Orders . Each class handles your table, and when a class needs to write data to another tabl...
asked by 04.10.2016 / 16:31
0
answers

how to solve this trigger in MySQL?

create trigger tr_kmanterior before insert on t_consumos for each row set new.kmanterior_c = (preview.kmatual_c); OR create trigger tr_kmanterior before insert on t_consumos for each row set new.kmanterior_c = (old.kmatual_c); I need to p...
asked by 26.08.2016 / 03:58
0
answers

Change the column header with formula

I searched for infinite on the internet and did not find it, I hope someone can help me, I have the following table: The numbers -1, -2, -3 ... represent the months, that is, last month (-1), delayed (-2) ... and so on, what I need is s...
asked by 26.08.2016 / 00:16
0
answers

JSF Download Archive Saved in the Bank

Hello, I have a jsf page where I load the data of a entidade , between the data there is an attached file (pdf, xls, jpg etc.). I would like you to click on the file name to download the file. If anyone can help in any way thank you. Me...
asked by 26.08.2016 / 16:40
0
answers

mysql code in viewreport

Good night, I'm trying to create a report, but that, for example ... I have a table property and it has the id, name and the like ... and I have the animal table that is saved in it just the id of property and I would like the moment I show the...
asked by 30.09.2016 / 23:35
0
answers

Problems with memory pool ofMysql memory

Hello, I have a machine EC2 on AWS radando ubuntu server. It turns out the MySql has stopped working and will not come back. The% error% has the following: 160919 21:20:21 [Note] Plugin 'FEDERATED' is disabled. 160919 21:...
asked by 20.09.2016 / 02:29
2
answers

Store new Value, updating Old Value

Can anyone help me with a function in PHP and MYSQL? Today I have a view to Expense and Revenue Release. I also have a cashier that, when I issue a Revenue, the amount is added to the cashier and when I post an expense, the amount is subtract...
asked by 19.09.2016 / 17:38