Questions tagged as 'mysql'

Tagged questions
2
answers

How to filter only the date of a field that has a date and time set?

I need to create a select in MySQL to filter the month in a table, but the field where the date is set, has also set the time, like this: [2017-02-04 10:00:00] How do I filter only the date of this field by considering only the month and disr...
asked by 28.08.2017 / 19:58
1
answer

MySQL: Query Table N: N

Create database Banco default character set utf8 default collate utf8_general_ci; use Banco; create table Cadastrados( Nome varchar(50), Sexo enum('M', 'F'), Matricula varchar(9) unique, Curso enum('Arquitetura e Urbanismo', 'Engenharia Ambient...
asked by 21.03.2017 / 16:05
1
answer

How to do inner join with Laravel?

I'm studying Laravel and I'm not able to how to join and display the data. All students who are in a class with the names, class code and description of the final situation.    Model: TurmasHasEstudantes public funct...
asked by 25.03.2018 / 21:46
2
answers

Problem with query mysql, what would be the best way to solve

Hello, I'm trying to make an appointment for an ordering system for a restaurant. My tables are arranged as follows: I need to bring all tables (regardless of whether or not they have a request) if they have a request with status 0, such...
asked by 25.01.2017 / 14:47
2
answers

Connection problems between Hibernate and MySQL database [closed]

Hello, I'm starting Hibernate studies and I'm not making a MySQL database connection. Here's my code below: import java.util.Calendar; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; impor...
asked by 24.01.2017 / 15:29
1
answer

Save to database or generate new html page?

To make a news portal. The administrator will power the system through an administrative panel. I'm working with php and mysql. The question is: generate an html file for every new news? Or save everything in the database? Both methods work, wha...
asked by 29.06.2017 / 04:47
2
answers

Select in two tables with data from the first table?

In a table that contains some comments, one of the columns holds the user ID that made this comment, how can I retrieve that user's data with the ID when making a query in the comment table? I know I can do two select one after another, but if p...
asked by 04.12.2016 / 20:18
1
answer

Insert ajax dynamic query result inside the input

I'musingadynamicquerywithAJAX+JQUERY,theresultisappearingbelowasshownintheimageabove.<divclass="form-group"> <label for="inputEmail" class="col-lg-4 control-label">FORNECEDOR</label> <div class="col-lg-8"> <inp...
asked by 05.12.2016 / 14:58
1
answer

Node JS - MongoDB x MySQL

Why every Node JS tutorial we see, is always shown example in MongoDB. What do the two have that are so used? Why not use MySQL with Node?     
asked by 17.11.2016 / 22:29
1
answer

how to get data from one mysql table and insert into another:?

I'm trying to make pincode validator (serial), but I do not know how to do it. I have two tables: "validation" and "expiration". In the "validation" table, it has the following fields: id(int), data(varchar), pincode(varchar), status(int...
asked by 20.11.2016 / 00:10