Questions tagged as 'mysql'

Tagged questions
1
answer

Losing value of POST fields when user connection is slow

I have a problem when users update the site and in the middle of the action the connection slows down or crashes and comes back quickly at the time of the process. Sometimes the user only updates the title of a news article, for example, but...
asked by 08.11.2018 / 13:21
0
answers

Time Out when trying to run query in Mysql

I'm running the following code: SELECT e.*, e.CO_ESCOLA, es.CO_ENTIDADE FROM enem20162 e INNER JOIN escolas es ON e.CO_ESCOLA = es.CO_ENTIDADE #WHERE CO_ENTIDADE = ORDER BY e.CO_ESCOLA; I want to return students who are connected to a sch...
asked by 08.11.2018 / 14:49
0
answers

Syntax error in Java JDBC MySql

I have a syntax error here in the mySql query inside the Java code in the repository. The error is both in the ALTER method and in the EXCLUDE method. package com.leporonitech.agenda.repositorios.impl; import java.io.IOException; import java....
asked by 31.10.2018 / 19:40
0
answers

Generate protocol number with contact form 7

I need to develop a simple system of ombudsman, and for this I am using Wordpress and in the form the Plugin contact form 7 , I would like to implement a unique and non-sequential protocol number for each submission. This protocol number w...
asked by 31.10.2018 / 22:14
0
answers

Save in the database a column of the datagrid

I need to get the value of the discount column of my datagrid and save it to my database, I can calculate it when I register the consumption according to the quantity, follow the code below: foreach(varleiturainleituras){totalConsumo+...
asked by 31.10.2018 / 11:56
1
answer

server timezone error is unrecognized wildfly 14 Connector / J 8.0.13

I'm setting up my environment using wildfly 14.0.1.Final and the connector mysql-connector-java-8.0.13. I have the following error when configuring the connection profile and I make a connection test:    java.sql.SQLException: The server t...
asked by 11.11.2018 / 01:47
0
answers

Graph with filter using php / MySQL

I'm trying to build a filter chart with MySQL data. This is one of the codes for this type of filter chart: <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script><scr...
asked by 10.11.2018 / 22:09
0
answers

How to search for information in the database, with the application running in the background (in service)?

I'm new to the Android branch, and I'm making an application that generates a notification when it gets close to places registered in the database, but it's giving an error:    E / AndroidRuntime: FATAL EXCEPTION: main       Process: splashde...
asked by 30.10.2018 / 23:13
1
answer

Bring range data

I would like to bring even the ones where there was not value in the query For example; table data id | valor | data 1 | 5 | 01/10/2018 2 | 6 | 03/10/2018 3 | 7 | 04/10/2018 5 | 8...
asked by 29.10.2018 / 19:42
1
answer

List the best-selling product per day in a store's DB

I need to list the best-selling product per day in the store, showing the description, the type and the day. As far as I've come: SELECT Data, MAX(QtdVenda) as Vezes_Que_Foi_Vendido, IDProduto, Fabricante, tipo, nome from vendas INNER JOIN...
asked by 27.10.2018 / 01:42