Questions tagged as 'mysql'

Tagged questions
1
answer

Group by by date using left join mysql

I am trying to make a query that involves 3 tables, post, comments and likes. I need to know the date of the post and the title of the post, the number of people who have commented on the post and the number of likes for each person, the detail...
asked by 28.02.2018 / 19:35
0
answers

Values in Select

I have a problem this is a part of my form, in my code I use select to make a catalog but I need you to take the values that were previously entered and that are stored in the corresponding tables of my BD in my case What I do is that I store th...
asked by 01.03.2018 / 15:32
0
answers

Problem with the input type="date" when loading a date from a MySQL database

I am carrying out a project as a test using angularJS, SpringBoot, JPA technology in a MySQL database. Now I'm doing a CRUD of a movie entity. One of the attributes of the entity is a date (Date). I make the insertion in the MySQL DB without any...
asked by 27.02.2018 / 20:41
0
answers

Error making an INSERT INTO IN JAVA NETBEANS

I have a small problem when performing an INSERT TO A DATABASE THAT BELIEVES IN MY SQL THROUGH SCRIPT IN NETBEANS. MY COLLABORATOR TABLE HAS 31 FIELDS, EH CREATED 31 TextField to receive the information written there, and yet when I click on the...
asked by 28.02.2018 / 07:52
0
answers

Pass more than two data in laravel and highcharts

I'm running a query by laravel to bring me an average consumption, and the months according to the parameter that I'm sending that is the year, to show them in highcharts shows me but I want you to show me the sum of the initial number , is ther...
asked by 01.03.2018 / 16:16
0
answers

Null value inserts 20 equal data

I have a question that is burning me the coconut, I'm with jsp and mysql Workbench, in one of the tables there is an attribute with an id with autoincremento, At the moment of entering the data from the form, I enter 20 repeated data, the Insert...
asked by 27.02.2018 / 03:02
2
answers

organize the months in SQL

I'm running a SQL query to show me the total result for months by selecting the year but when it is executed it shows me the badly organized months and I used the ORDER BY function in DESC and ASC and do not want to organize, here I leave the SQ...
asked by 26.02.2018 / 22:05
1
answer

Problems with MariaDB, slow query

On the server I have two databases. db production and db_test production, the two are the same in fields, tables, relationships, etc, since tests are done with db_test production. The problem arises when I want to make a simple query in PHPMYADM...
asked by 26.02.2018 / 20:36
1
answer

Error updating the php5 to php7 script

Sorry for the inconvenience my dear and wise programmers well I have a small error when updating my scripts from php 5 to php 7. I was updating a small visitor counter and it gives me a lot of errors in some lines to see if you can help me th...
asked by 26.02.2018 / 01:19
3
answers

Add different values MySql

I have a table with three columns in which one of the columns has the client_id (columnA), in the second the orders made (columnB) and in the last one the order date (columnC) columnaA columnaB columnaC 1 26 2018-02-09...
asked by 28.02.2018 / 14:53