Questions tagged as 'mysql'

Tagged questions
0
answers

Replication of tables with different databases

Hello, I have a database in sqlserver and an application with mysql database, I would like to know if there is a way to synchronize a table in both banks. Example: there is the table "mytable" in sqlserver, I want everything in it to be reflected...
asked by 04.10.2018 / 21:37
1
answer

MYSQLI BD MIGRATION ERROR

FRIENDS, I migrated from vps and after that I started to have problems with the connection of bd mysql , I made some more adjustments now I can not find the error, could you help me please, I have a php file that connects to the bank and a...
asked by 01.10.2018 / 17:26
0
answers

Questions about how to efficiently use mysql pools with node.js

Reading the Documentation from mysql it offers the creation of pools, but it has a parameter called connectionLimit and mine doubt is on top of that! This limit that I will impose is in relation to: How often will a query be done on...
asked by 01.10.2018 / 20:08
0
answers

Error: 33 = got packets out of order

When I run the code, the serial monitor shows the temperature value, but then it does not send to the MQTT broker nor to the database, if you run the code separately, that is, one at a time it already sends or for the database or to the MQTT bro...
asked by 01.10.2018 / 19:46
0
answers

MySql - Server change caused it to display point instead of comma

I have an application C# .net using Mysql as db , and was hosted on Locaweb . I published the files on the server SmarterAsp and restored the database there too. Now in the application, the 'double' fields...
asked by 25.09.2018 / 22:28
0
answers

Pagination PHP MySql

I have the code below, can anyone help me convert Mysqli to please. $pagina = $_GET["pagina"]; $busca = "SELECT * FROM colunistas_parceria order by -nome"; $total_reg = $config_paginacao_todos_os_colunistas; // número de registros por...
asked by 23.09.2018 / 22:33
0
answers

json_encode returns null in one situation and in another it returns the correct values

Good morning, I'm almost finishing an application, but I'm stuck in this situation. I made a simple system of registration and login just to store values of the mobile in mysql, it saves all the correct values, also made a simple ranking system...
asked by 25.09.2018 / 15:12
0
answers

Create Site Query Status

I need to create a very simple site where a customer can check the progress status of their equipment maintenance. I already control this in a database. But I would like to make it available. I can use a link within the same company website, but...
asked by 11.10.2018 / 02:25
0
answers

How to display the MYSQL data in Value within the input

This is my PHP code: $result = mysqli_query($conn, "SELECT * FROM config WHERE id IN (1,2,3)"); $sdda = mysqli_fetch_assoc($result); This is HTML: <div class="col-sm-12 col-lg-6"> <div class="form-group"> <label>...
asked by 11.10.2018 / 13:43
0
answers

Create CONSTRAINT FOREINGN KEY with primary key VARCHAR type from another MYSQL table

I have two tables one call _hardware_ and another call _responsavel_ . In _responsavel_ I have a Primary Key called NIP of type VARCHAR(8) . I created a field called NIP_RESP also VARCHAR(8) ,...
asked by 27.09.2018 / 22:15