Questions tagged as 'mysql'

Tagged questions
1
answer

Using Highcharts with Laravel (Blade) and MySQL

How do I pass parameters, data from the database? According to the documentation, the examples are with static value arrays, but I would like to obtain this information from a data source, register people by their sex and age, and then graph it....
asked by 11.06.2016 / 03:47
1
answer

I can not create or modify a JSON type column in MySQL

I'm trying to add a column to store JSON objects in my MySQL database. My configuration is as follows: Versión de MySQL: 5.6.32-78.1. Engine de la tabla: MyIsam. Base de datos alojada en un hosting compartido (Bluehost) I've tried...
asked by 22.05.2018 / 13:34
2
answers

MYSQL Difference between FLOAT and DOUBLE

What is the difference between fields type Float and Double in MySQL ? In addition to the difference of being able to cover Double bigger numbers than those that can store Float . Are there any other differences? F...
asked by 14.05.2018 / 04:23
1
answer

Python collation excel report with Pandas

I am generating a report with the Pandas module in Python, I get the data from MySQL, but there is a column with accented data, at the time of generating the report it falls, I leave information related to the problem. Connection code: con...
asked by 11.05.2018 / 12:21
1
answer

Problem counting all records by specialty and adding record with total

I need to extract the total of all records by specialty and, in turn, add this number of records. This is my SQL query: SELECT t.empresa, Count(t.idespecialidad) AS todos, e.nombre AS nombre_especialidad FROM...
asked by 11.05.2018 / 13:10
1
answer

Error creating bean with name 'adminServiceDAOImpl': Unsatisfied dependency expressed through field 'adminDao';

hi how I have this error:    Error creating bean with name 'adminServiceDAOImpl': Unsatisfied   dependence expressed through field 'adminDao'; public interface AdminDao { public boolean save(Admin admin); public List<Admin>...
asked by 25.06.2018 / 19:59
2
answers

problems when inserting in a bd

I have 2 tables in my database one of them is cards and the other type cards basically after normalizing the table cards I am left with a type fk that links to the card type pk, then insert data in this last one like this its structure more down...
asked by 30.07.2018 / 03:37
1
answer

Laravel / Eloquent query between unrelated tables (Many to many)

My problem is that I have a many to many relationship between the subject and teacher table, therefore, I have a detail or intermediate table ( teacherSubject ). I must show in Teacher the subject blade teacher that they are related...
asked by 13.06.2018 / 22:08
1
answer

How to remove the subquery in creating a MySQL view

I have this query in MySQL Select t.grupo, Sum(servicios.cantidad) As total From (select distinct clv_servicio, grupo from actuacion) as t Join servicios On t.clv_servicio = servicios.id_servicos Group By t.grupo That works correctly but...
asked by 04.05.2016 / 20:44
1
answer

Put query results in a JSON array

Friends, see if you can help me solve this dilemma. I am getting a JSON from a query to the database in which several tables are involved. That JSON is then presented in an Android app. I would like to present in my JSON a key called sa...
asked by 22.02.2018 / 11:33