Questions tagged as 'mysql'

0
answers

Bad redup in Ubuntu vs Windows

We currently have two computers that make the bdd server for an electronic agenda: Core 2 Duo 2 GB RAM 1 TB HDD Windows server 2008 This team has been working for two years and it is going to change because it has started to fail from time...
asked by 13.11.2017 / 14:30
1
answer

Problem with query UPDATE - MySQL and PHP

Good, I'm doing an online course that is somewhat outdated, and I'm having some problems. I'm trying to edit the data on a fictional bus website using a form, but I have a problem. I attached the code: From one page you can see all the buses,...
asked by 13.11.2017 / 11:25
1
answer

Why do you show the data as null if I have a record with more than one user?

Again I need your help community, I have the following table in my database, with the records of a user's schedule (the rout are fictitious) I have registered three schedules with the same date and different time for the same user, if I...
asked by 10.11.2017 / 15:36
0
answers

Mysql ignores my.cnf when installing cacti

I have installed mysql 5.5.58 on centos 6.9 in which I plan to mount cacti to monitor my network, I have installed php 5.4.45 and apache 2.4 the problem is that when starting the cacti installation process, the wizard tells me that I must make s...
asked by 10.11.2017 / 18:24
0
answers

MySQL distinct from field type DATETIME

I have a list with data selected from date, the date field is of type DATETIME. FECHA 15-08-2017 14:41:12; ID 150; DATO 80 Out of a total of 1000 records, it is necessary to know how many times the value of the DATA field changed and what v...
asked by 15.11.2017 / 00:00
0
answers

Uploading scroll data does not work well

I am generating an AJAX data loading system when scrolling, just like facebook does. But what happens is that it does not work as I expect, although the code I see very well written and with the corresponding logic. This is the index.php c...
asked by 14.11.2017 / 19:32
1
answer

Print the results of consultation records with LIKE. mysql + python3

Hi, I would appreciate it if someone could help me with this problem. I want to print each of the results that this query would throw at me, as when it is executed in MySQL. What I want is for example to obtain all the records that contain the w...
asked by 10.11.2017 / 09:10
1
answer

Numerical sequence of the autoincrementable ID

Someone knows how to do so that when I delete a row from my MySQL table, the following follow the numeric sequence of the autoincrementable ID? example, I have 10 rows with ID from 1 to 10, I delete rows 9 and 10, when I enter 2 new rows it look...
asked by 14.11.2017 / 21:32
1
answer

Image becomes code when uploading it from the database

I have a problem .. sometimes when I upload images from the database by phpmyadmin, the image shown is transformed into special characters as I show in the image. Does anyone know why that happens? <?php //Declaracion de variabl...
asked by 12.11.2017 / 18:14
1
answer

MySQL with php LIKE and PDO

Hi, I hope you are very well, this is my first introduction with PDO and it made me very interesting, as a result of this I have had some doubts about the SELECT that I hope you can help me at the moment I have this like this: SELECT id...
asked by 12.11.2017 / 17:06