Questions tagged as 'mysql'

Tagged questions
2
answers

Why do the MAX () and MIN () functions give me the same result in Mysql?

Why do the MAX () and MIN () functions give me the same result in Mysql? INSERT INTO 'Venta'('idVenta','idFactura','idVehiculo','Cantidad','Precio') VALUES ('56', '44', '06','01','4000000'); INSERT INTO 'Venta'('idVenta','idFactura','idVehicul...
asked by 24.01.2018 / 23:59
2
answers

What is the best way to store months in a database? [closed]

I am doing a contracting system and the contracts can be extended up to one (1) year, so the user will only insert the day of creation of the contract and the months of the contract. As you can see in the image, create an enum type column for...
asked by 25.01.2018 / 18:54
1
answer

Play different videos on a div without reloading the page

I need some help, I would like from the same page to play several videos, I explain better in a div put a player and next to several buttons that every time you click on the button loads me the video of that button on the div without having to r...
asked by 16.10.2017 / 04:57
5
answers

Send NULL to the BD field

I'm doing an exercise with PHP and MySQL where I make a form with a series of data. The telephone field allows null, so the user leaves it blank in the database I want it to be saved as NULL but I left a blank space. Image of the BD:...
asked by 18.10.2017 / 20:16
1
answer

Sort Recyclerview by date

I have my RecyclerView that gets the data from my MySQL database through json. The fact is that when I run the app and it gets the remote data, I want it to be ordered by date taking advantage of the box in which I have the date. I need the e...
asked by 14.09.2017 / 10:31
1
answer

Do not insert repeated data into MYSQL

I'm trying to upload some files to MySQL as a project, but the problem is that if I select the file 2 or more times it comes back and uploads them. The idea is to make when you try to upload the file read the rows and say that X number of c...
asked by 31.08.2017 / 22:52
1
answer

how to make a difference in mysql?

I have the Table A: ------------------- * fechaA * ------------------- * 2017-09-01 * * 2017-09-02 * * 2017-09-03 * * 2017-09-04 * * 2017-09-05 * * 2017-09-06 * * 2017-09-07 * * 2017-09-08 * *...
asked by 18.09.2017 / 17:05
2
answers

PHP insert multiple fields to database

A question at the time of entering a comments to a worker to the database through his ID only I enter a single comment not the multiple that I can add through the textbox. <script> $(document).ready(function(){ var i=1;...
asked by 31.08.2017 / 13:44
2
answers

How to group the result of a query

I need to relate two tables with INNER JOIN . In a relationship table I have Estudiante In the table students I have Estudiante , Nombre , Grado . I need to relate both tables in a query and the result is o...
asked by 20.09.2017 / 16:25
2
answers

mysql order per day of the week

Hello friends, could you help me, I would like to ask a query on a mysql bd to sort the records for the day of the week in which you are currently I have these records: +---------+----------+ | id_cron | day_week | +---------+----------+ |...
asked by 21.09.2017 / 21:11