Questions tagged as 'mysql'

Tagged questions
0
answers

Generate a PDF and write data to the bank in the same form

I have a program that takes the name and email of the client to register in the bank and generate a pdf with this data. But I can not send the registration data to the file that generates the pdf. Either the register works in the bank or the pdf...
asked by 30.05.2018 / 00:35
0
answers

Modeling Banks Financial Institution

I am starting a personal project for my apprenticeship, an application simulating a financial institution system, I would first use the following products: checking account, credit agreement (loans). I came across the following difficulty, what...
asked by 29.05.2018 / 18:19
1
answer

OneToMany or ManyToOne?

Good evening, I have some basic beginner questions I need to create a timeline that has the following: What events occurred in a given date range, who was born and who died in this range? I have the Person, Event, and Timeline classes. My Tim...
asked by 29.05.2018 / 06:31
1
answer

how to get a value in the table and sum with which to enter in php

I am making a bank account system and in one of the operations the user has to perform deposit only that my doubt this I already did the update of the table that takes the value that the user and changes in the table more like sum with what it h...
asked by 08.06.2018 / 16:35
0
answers

How to fix Auto Increment that is populating high numbers in bd Heroku?

I'm coding a RESTful API with Spring Boot v.2.0 and so on. The thing is, when I try to make a deploy for Heroku using migration ( Flyway ) ids get high values. My model or entity of User is with id like this: @Id @Genera...
asked by 08.06.2018 / 21:25
0
answers

I can not download the header from the .csv file

I'm trying to download data from a table in csv format with header but getting the following error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'Dtremessa' in 'field list' at sun.reflect.NativeConstructorAccessorI...
asked by 28.05.2018 / 17:02
0
answers

SQL query on 2 databases on different (mysql) servers

Hello. First, I make it clear that I do not know if this is possible. I'm trying to do a SQL query where I need the INNER JOIN data from 02 tables that are on different servers (a Local Server and another Remote Server). I want to do in...
asked by 27.05.2018 / 18:39
1
answer

How to check if it already exists in the database and update

Well, I'm trying to update and check if what I'm updating already exists, I can check if it exists, but there's a problem, as I'm updating a data, it will always exist, if I take the function that checks if it exists, the user can update the regi...
asked by 26.05.2018 / 04:57
0
answers

Mysql insertion problem

I have a Scheduling and one of Employee Master forms, a script to enter data into the database in the Scheduling table and another script for Registration . On the Scheduling I need to redeem the code of the Employee who is scheduli...
asked by 25.05.2018 / 18:36
0
answers

SQL with SELECT and SUBSELECT to set up a chat

Hello everyone, I'm building a SQL Server database, and I'm using SQL Server 2005 to create a user-defined chat. I have a list of all the active conversations, but I have a problem, my SQL is bringing the last message according to id of the Clie...
asked by 25.05.2018 / 17:51