Questions tagged as 'mysql'

Tagged questions
1
answer

Convert date format into echo of php [duplicate]

Good afternoon, My database is saving dates in the following format "2017-04-19", I do not know if I can change the data already registered in it and the way the data will be saved, so I chose to treat the date in my php code , which I have...
asked by 19.04.2017 / 21:28
1
answer

Send images to different folders and write each one to a database table using php

I'm a beginner in php and I'm trying to create a website. How do I send 6 images at a time through the form, have each one be sent to the specified folder and write to the database. Name the tables in the database: nomedarom   image...
asked by 19.04.2017 / 20:58
1
answer

Table with primary key that never repeats

I have a Produto (id, descricao, tipo) table and this same table is on three different computers. All three write data to your machine and from time to time send data to a server. What happens is this: let's say that PC1 and PC2 wri...
asked by 17.04.2017 / 21:20
1
answer

Error starting project nodejs + Sequelize + mysql

When I try to start my project, it gives the following error: D:\www\nodejs\master>node bin/www module.js:472 throw err; ^ Error: Cannot find module 'sequelize' at Function.Module._resolveFilename (module.js:470:15) at Func...
asked by 16.04.2017 / 06:23
2
answers

SQL Replace when any variable contains a semicolon

I am using this command without problems to replace class="texto1" with class="texto2" : UPDATE tabela SET estilo = REPLACE (estilo,'class="texto1"','class="texto2"') WHERE estilo LIKE 'class="texto1"'; It works perfectly, but...
asked by 12.04.2017 / 01:05
1
answer

About tag for MySQL database

Good morning! Galera! To with database more than 25 thousand records. I'm reshaping the database because it's very disorganized so I'm building a script to do everything automatic because doing 1 by 1 does not roll right. Doubt is next, it...
asked by 12.04.2017 / 11:13
1
answer

Python returns "dead" when trying to read json 240mb [closed]

The problem occurs on a final CentOS server version 6.8. The same script with another smaller file works perfectly. Test done in Ubuntu 16.04 the process occurs successfully. Any solution? Follow the code below. gist code     
asked by 20.04.2017 / 15:16
2
answers

Make top 10 by checking 3 tables

I have 3 tables: sponsors id | id_patrocinador | id_usuario quotas id | id_user | quantidade users id | nome | login What I need to do is a TOP 10 where I list 10 users who have sponsored with active quotas. For example...
asked by 21.04.2017 / 07:05
2
answers

About Date in MySQL

I'm doing a program for a college job, with a connection to the database. In a table, I have a NASCIMENTO column of type DATE . In the program I have a MaskedTextBox to insert the date of birth, however I put our dates mea...
asked by 22.04.2017 / 03:38
1
answer

Query mysql add value day to previous days

I have the following query: SELECT * FROM vw_total_diario WHERE pessoa ='Daniel' GROUP BY data; It returns as follows: 2017-05-02 Daniel 6 2017-05-03 Daniel 2 2017-05-04 Daniel 8 2017-05-05 Daniel 1 2017-05-08 Daniel 10 2017-05-09 Daniel...
asked by 16.05.2017 / 20:32