Questions tagged as 'mysql'

Tagged questions
1
answer

"No suitable driver found" in Java database connection

Well, I use eclipse and I'm trying to connect to a MySQL database with my project, my code, compared to other tutorials I found, is perfect, and that's it: package pack; import java.sql.*; import javax.swing.JOptionPane; public class Banco...
asked by 10.06.2014 / 01:49
0
answers

mysql error: ERROR 1045 (28000): Access denied for user 'weslei' @ 'localhost' (using password: NO)

People, first of all I have already turned all topics around here and the error in question remains. I have tested several solutions presented here and indexed in google but it will not, since everything I try results in "ERROR 1045 (28000): Acc...
asked by 25.04.2018 / 04:20
1
answer

Divide search term to expand results and sort results according to the term

Let's say I have a table named carros . In this table I have some cars registered. Ex: ID | Name 1 | Corsa Amarelo 2 | Camaro 2 Portas Amarelo 3 | Camaro V12 Amarelo 4 | Camaro Esportivo Amarelo 5 | Fusca Amarelo 6 | Camaro Ama...
asked by 28.04.2018 / 22:31
2
answers

Mysql Query does not work with many arguments

I would like to ask you for help identifying the reason why my update query does not work. I have the following problem, the query below works normally: $conn->query("UPDATE dados_cadastrais SET nome='$nome',sobrenome='$sobrenome',nascimen...
asked by 29.04.2018 / 00:43
1
answer

Bank modeling with classes with relationship from n to n

Good morning. I'm modeling a company that has multiple branches. Basically I have information, of size, the organization chart of each size, and positions in the branches. For example Porte: Small 1, Small 2, medium, large, ... Item...
asked by 19.04.2018 / 16:37
1
answer

eager loading and custom queries

This question is a follow up this and this . But I'll try to make them independent. I have the following tables, weathers : +--------+-------+---------+ | id | temp | id_freg | +--------+-------+---------+ | 337 | 12.36 |...
asked by 19.04.2018 / 19:46
1
answer

Error trying to insert form in laravel with authenticated user (foreign key to another table)

I am trying to insert the data of a form of a Condominium class with the user already logged in and authenticated, the user_id is foreign key to the Condominium table, in my understanding the store method should already bring the user_id in the...
asked by 19.04.2018 / 17:22
1
answer

Difficulty in Loops While and Foreach

I've been studying php a short time so I did not understand the structure of the loops correctly as while and foreach would like someone to explain to me why this while does not display anything, and when I try to use foreach of the error. Thank...
asked by 19.04.2018 / 15:43
2
answers

how to return the last date in timestamp doing the group by of the same id in mysql

I have a problem I have a table that has the serial column, equipment and a timestamp date has no primary key because this table would be a history, I in the table I have several lines with the same serial but I need to bring the last date only...
asked by 19.04.2018 / 13:40
1
answer

MySQL - Separate values from one line into several lines

I need to separate the values of a line into several lines, taking into account that it has a line that has up to 2000 values separated by     
asked by 20.04.2018 / 19:38