Questions tagged as 'mysql'

Tagged questions
1
answer

Difference between datadir and innodb_data_home_dir

Can someone explain to me the difference between datadir and innodb_data_home_dir in mysql? I just installed Mysql 5.7 on a linux machine. According to the tutorial of mysql it is appropriate to separate the files of da...
asked by 23.05.2017 / 10:10
1
answer

As I show what brings the variables of a stored procedure with php and mysql [closed]

I have a store procedure in phpmyadmin of user login, and I am not showing the values that return, can you help me? I attach the code DELIMITER // CREATE PROCEDURE SP_LOGIN( IN _User VARCHAR(20), IN _Pass VARCHAR(20), OUT ValRet VARCHAR...
asked by 29.05.2017 / 14:29
1
answer

When making a query I get the number 1 in the input - PHP [closed]

My problem is as follows, when I make a query, the number 1 appears in the input automatically, does anyone know why? Attached image. Here is the Code - PHP <?php include 'conexion.php'; ?> <form action="buscad...
asked by 30.05.2017 / 18:26
1
answer

Changes on my website are not shown until pressing F5

I'm designing my website. I have it programmed with php and mysql. My problem is that when I publish it on the host, the queries do not show the changes until I reload the page. This seems to be the problem of the host that you hire becaus...
asked by 22.05.2017 / 07:45
1
answer

Error Unable to connect to any of the specified MySQL hosts

Good morning everyone, I have this problem when I try to connect to a computer where I install XAMPP to host a database server MYSQL locally and also a database for a clock checker, through PHPMYADMIN if I can access the dat...
asked by 24.05.2017 / 15:32
1
answer

Store select result

In a previous post ask this: Download selected object and thanks to a user gave me the idea, which I appreciate very much. But now I have another doubt, and since I have to have 50 of respect to be able to respond and others, well I make anoth...
asked by 24.05.2017 / 09:20
2
answers

Bootstrap Fixed Header Responsive Table

Please I need help to set the header of my board with bootstrap. I tried several examples that circulate but in none I get the desired result. My table contains 11 columns and is within a div responsive: <div class="p...
asked by 15.05.2017 / 22:48
1
answer

How to add the values counted by count mysql?

I'm not realizing how to make a query and that's why I come to ask. I have the Users table in which I have the following columns: id, nombre, numero1, numero2, email And the following query: SELECT nombre, count(nombre) FROM Usuarios GROU...
asked by 16.05.2017 / 01:48
2
answers

how to build two queries to the same table in one

I have this table with these two queries but I can not find a way to show the two queries in one The final result should look like this:     
asked by 27.05.2017 / 00:05
1
answer

Obtain sum position (field) ordered from highest to lowest

Good morning, I have a query that makes a sum of a score according to user and then orders them from highest to lowest: select distinct usuario as u, (select sum(puntajeProde) from prodeApuesta where usuario = u) as total from prodeApuesta or...
asked by 19.10.2017 / 18:04