Questions tagged as 'mysql'

Tagged questions
2
answers

Location Android manager? Experiences

I have developed a Gps application that sends information to Mysql every 10 sec through the locationmanager. According to your experience, how much is it possible to reduce this time?     
asked by 13.09.2016 / 01:26
2
answers

Error updating 2 columns of different tables by means of a JOIN

I have the following query with which I try to update the name of the user and the name of the post associated with that user UPDATE users JOIN posts ON (users.id = posts.user_id) SET users.nameUser = "mas blabla", posts.namePost =...
asked by 12.11.2018 / 07:15
1
answer

Update does not update table

Good to execute my code I can not change the value in database. Modify.php include ("conexion.php"); $usuario="jose"; $linku= $_POST["linkm"]; $db = mysqli_select_db( $conexion, $basededatos ) or die ( "Upps! Pues va a ser que no se ha...
asked by 16.10.2018 / 02:46
3
answers

SQL query in MySQL between 3 sum and count tables

I have 3 tables. One is clientes , other fotocopias and recargas_saldo , related by id_cliente which is primary key in clientes and foránea in the others. I need to take out the following: 1 .- No...
asked by 17.10.2018 / 13:16
1
answer

Correct a text string to date format

Hello everyone I have the following string 09/20/2018 12:21 PM which I want to convert to date format to insert it into a column of a MySQL database that has datetime I tried with the function strtotime but the result what I...
asked by 20.09.2018 / 19:26
1
answer

Print data from a UNION SQL query

I have the following query to two tables with UNION . The problem is that when trying to print any data from the 2nd query it says undefine X-field , but the one from the first query does print me data. This is my code: <?php $q...
asked by 05.09.2018 / 10:19
1
answer

How to correctly reference charset = utf8

I have my coding in my php code in the PDO connection, it works correctly, but when you insert the data into MySQL, you can see it; (Ñ) Send them in lowercase CASTAñEDA example, in my form in most of the fields, I have what is $ strtoupper but I...
asked by 28.08.2018 / 19:47
2
answers

Store date and time in variable in a MySQL stored procedure

I have a problem, I am trying to store the current date and time of the server in a variable, within a procedure stored in MySQL, only I can not do it, the previous thing I do, since in multiple rows I will execute a relative condition to the cu...
asked by 07.09.2018 / 22:40
1
answer

Error starting MySQL in XAMPP

I have installed XAMPP on a WINDOWS machine, but I get an error when starting it. I have already uninstalled and installed twice, but the error keeps coming up. I opened the logdata and this is what appears to me:    2015-11-10 15:2...
asked by 06.09.2018 / 22:30
1
answer

Compare 2 columns in DataGridview

I have 2 DataGridview that load information from a database in MySQL, in the dataA I have schedules, with a column time and a data type: 09:30 ( String ) and in dataB I have the data of the appointments assigned for th...
asked by 08.09.2018 / 22:53