Questions tagged as 'mysql'

Tagged questions
1
answer

Synchronize two MySQL banks

I'm developing a web application and would like to get the system up and running both online and offline. The idea is to maintain a local database that responds when the user is offline , but I do not know how to synchronize the data between th...
asked by 29.09.2017 / 20:22
1
answer

How to perform query on two tables by combining data

I have two tables: material id | categoria | subcategoria | codigo 1 | 3 | 15 | FS-5600 2 | 0 | 16 | FA-4500 subcategory id | descricao | id_categoria | id_produto 1 | Alasca | 3...
asked by 13.10.2017 / 17:33
1
answer

What is the correct type for storing phone and address? [duplicate]

As the title says, what is the correct type and the correct way to store phone and address, according to database normalization ? In the case of telephone, what is the correct type to store, the landline and cell phone? With formatting ma...
asked by 29.09.2017 / 15:49
1
answer

Stock quantity management

Personal I'm trying to do a stock control, my idea is when I consume a product it changes in the table. Ex: Estoque: Produto / Quant Caneta /5 Papel / 10 Lapis / 20 But when I separate these items for some segments in the company Segme...
asked by 28.09.2017 / 21:37
0
answers

Export MySQL data to CSV file in UTF-8 format

I am using the Workbench tool to access data from my MySQL database, but when I try to export the returned data to a *. CSV file I am not able to export the same in the format > UTF-8 , but it is exported to any other file format (XML,...
asked by 03.10.2017 / 19:45
1
answer

I can not authenticate user

I am not able to do user authentication, it is only redirecting to the part where "user registration is not possible". <?php $login = $_POST['login']; $senha = MD5($_POST['senha']); $connect = mysqli_connect('nome_do_servidor','nome_de_us...
asked by 27.09.2017 / 03:25
1
answer

Accessing MySQL with C #

I am creating a simple Form that has 3 TextBoxes and 3 buttons and I want to save the information entered in Textboxes in a table. I have already created querys all within a class acessoBD , but I can not acc...
asked by 24.09.2015 / 03:00
0
answers

Loop interrupts script, but does not give error

I am putting together a list that collects user data. As some data are in different tables (the one of appendices, precisely) I have set up a query select to get only those attachments that have the same id of user (table that I called...
asked by 30.09.2017 / 03:43
1
answer

Dynamically display the database record with its category

I have this html code that separates the records from the database according to the category. <div class="example1"> <h1>Painel do Cliente</h1> <div class="panel panel-primary"> <div class="panel-heading"...
asked by 27.09.2017 / 21:55
2
answers

View database data

I have a bunch of data with information from various bands, however I would like to pull them to my front page. Bank name: dados Table called: Artists where I have the information in it: imagem_small (in this c...
asked by 26.09.2017 / 21:51