Questions tagged as 'mysql'

Tagged questions
1
answer

Query Performance in MySql Database

What is the best performance option? I do select * from agenda, paciente where agenda.id_paciente = paciente.id_paciente and pick up the data together from the agenda and patient or do first select * from agenda and then another sele...
asked by 15.12.2014 / 17:06
1
answer

Tomcat 8 + MySQL + Hibernate Name [jdbc / token_data] is not bound in this Context. Unable to find [jdbc]

I'm having serious problems with an application, trying to set it up, and nothing. As a beginner on the web part, I will first say what I understood: Tomcat needs settings (xml) to work with Hibernate. In the case of the TOMCAT folder y...
asked by 10.05.2016 / 02:33
2
answers

Using a select with UNION or another mysql parameter

I am developing cash flow from my company and am encountering a difficulty. I have two different tables. A table is tb_compras(id, fornecedor, nfe, valor, data) and then I have another table tb_compras_historico_pagamentos(id, id_co...
asked by 08.06.2018 / 19:21
4
answers

What is the difference between SMALLINT (3) and INT (3)

I have a question about the difference between two types of data in MySQL: This document has this table: The default construct of these types is SMALLINT(M) and INT(M) where M = numero máximo de dígitos que o campo ir...
asked by 28.06.2018 / 17:15
1
answer

Split and search for older and newer messages

I have a table . In it to 4 columns ID with high increment, id_user1 would be the id of the user who sent the message, id_user2 would be the id of the user that received and the mensagem to which it receives the...
asked by 15.07.2015 / 14:48
2
answers

Problem connecting MySQL in Python 3.4

I just installed my virtual environment, I installed PyMysql and created a project, but when trying to start a python manage.py startapp nome APP, the following problem occurred: Error loading MySQLdb module: No module named 'MySQLdb'...
asked by 29.09.2015 / 04:37
1
answer

Importing PDF Data into PHP

It may be a bit of a beast, but I still have to do it: Is it possible to import data from a file into pdf into php and save to mysql ?     
asked by 21.01.2016 / 14:04
1
answer

how to use the foreach

Hello, I'm here to ask for the help of your friends. I have this code below to list all the products and to be registered, but I am not able to list them on the same page using the foreach. Would my friends give me a hint of where I'm going wron...
asked by 30.08.2015 / 20:07
2
answers

Group column sum by quarter

I would like to group the sum of one column per quarter, that is, every three months. I have the following query that groups from month to month: select month(data) as mes, year(data) as ano, ifnull(sum(det.quantidade),0) as total...
asked by 03.08.2015 / 15:39
1
answer

from sql server to mysql with php

I have a SqlServer database and need, via php script, to send the data from a table to a MySql database. Will OPENQUERY result within the condition I have (php script)? How best to do this? The code I use to connect banks: Sql...
asked by 20.08.2015 / 14:09