Questions tagged as 'mysql'

Tagged questions
1
answer

show all the records except the one I am looking for

How I do not show this record but the others. Until there is left. <?php include "codigo/conexion.php"; $buscar = $_GET['producto']; $consulta = "SELECT * FROM catalogo where idcat = ".$buscar.""; $resultado = $conexion->...
asked by 10.11.2017 / 23:01
1
answer

Delete of an entity in DB with spring

Good afternoon, I have an information system with a DB in Mysql. The connection with her and the mapping was made with Spring. I am creating the services and I have a very important question. I put in context, I have two Ranger Entities and C...
asked by 11.11.2017 / 19:37
1
answer

Load image from MySQL to ImageView JavaFX

I need to upload an image that is stored in MySQL This table called conductors contains these columns: I managed to save them but now I need to obtain them when the user searches for that driver by his personal identity number. I hav...
asked by 08.11.2017 / 15:32
2
answers

Data SOMETIMES are not saved in MySQL database

< a href="https://i.stack.imgur.com/7ngv4.png"> I have an update system of data for a web page of news, consists of a form to put image, title, subtitle, text .. The form serves, works correctly, I know because when I use it, the rows...
asked by 09.11.2017 / 21:00
1
answer

Reduce ibdata1 and ib_logfile0

I want to reduce the size of the ibdata1 and ib_logfile0 files on my Mysql server 5.7 I do not want to activate the innodb_file_per_table option. What would be the best option to reduce the size without activating innodb_file_per_table? Can some...
asked by 08.11.2017 / 10:18
1
answer

Query in php and mysql in a table

I am having problems with a query, I have a combobox to make the query and it is displayed in a table. I do it in the following way: $where=""; $fun=$_POST['funcion']; if (isset($_POST['buscar'])) { $where="where tipo_funcion='".$fun."' an...
asked by 22.11.2017 / 20:02
2
answers

Error uninstalling mysql-server-5.5

I'm having problems when using workbench, and I'm trying to uninstall and reinstall mysql-server-5.5, but it will not let me. This is the error message, could someone help me?    debconf: DbDriver "passwords"   warning: /var/cache/debconf/pas...
asked by 15.11.2017 / 08:40
0
answers

Upload Django Project to the Server CPanel

Hi, I created my project in django and I already had a web, in this web I have a link that should go to the project / admin to log in, I uploaded the folder of my project and unzipped it but when I click em it says error 504 I do not know if it...
asked by 05.11.2017 / 15:26
0
answers

Show Average Value of the previous day between dates

I'm doing a query between dates, where I want to show the average value, but from the day before the chosen one, I have the following code: $desde = $_POST['desde']; $hasta = $_POST['hasta']; $estacion=2; $registro = ("SELECT AVG(TS) as Tsuel...
asked by 07.11.2017 / 17:00
1
answer

Log in as other users in Mysql

If I have users created as access as one of them in mysql, to test the privileges that it has and to know that I did well to assign privileges to each one?     
asked by 07.11.2017 / 04:18