Questions tagged as 'mysql'

Tagged questions
1
answer

select the name of the date using sql

I want to make a query using SQL that allows me to see the records of all months by a parameter that I will send is the year how do I get the name of the month and then pass it to laravel code. here I leave the SQL code of the query SELECT mes...
asked by 26.02.2018 / 13:54
0
answers

Problem with the OneToMany association

I am trying to create an association one to many I have created tables about mysql, as well as entities, but it does not insert data and tried to debug but I can not find where the error may be. MySql: CREATE TABLE IF NOT EXISTS 'pubs' ( 'i...
asked by 02.03.2018 / 04:12
1
answer

Do not take the direct values from my Database my Select

Realize my BD with my main table "worker", and depend others of her an example is my table "nomina" with the fields: id_nomina and descripcion_nomina , what I intend with this is that it is inserted or modified through the ID and that it show...
asked by 02.03.2018 / 14:17
2
answers

Problem with Script does not work properly

I am working with DataTables and with two JavaScript codes. I use the TableTools plugins that allow me to show the buttons to export the data in PDF, Excel or Print. In addition I am using a tfoot that allows me to visualize by means of anothe...
asked by 25.02.2018 / 20:32
2
answers

How to add rows to a table from another table with search engine

I am making a simple system for my business everything is going well until now that I get stuck, I hope you can help me I would be grateful enough, I explain a bit of my code and its function first. I have this input that searches for the pro...
asked by 23.02.2018 / 22:54
0
answers

creation of barcode with PHP, Mysql and highcharts

a query I'm creating some graphs with PHP, Mysql and highcharts where I make a query to my database XXX and I return the data in a shekel to be inserting the data and gratifying with the styles of highcharts. but nothing appears to me if I...
asked by 23.02.2018 / 20:29
2
answers

Something is wrong with my program

You see, I'm doing a Java program with Hibernate in Netbeans. For this, I have a class called Professor, which has this code: package hibernar; import java.io.Serializable; import javax.persistence.*; @Entity @Table(name="Profesor") public c...
asked by 24.02.2018 / 11:16
0
answers

how to display data from a database table horizontally?

Good afternoon I have a table that registers: date! hour ! type, as you can see, the data is registered vertically, that is, in the first row it would be something like this: 2018-02-20 08:00:00 Start, second row: 2018-02-20! 12: 00: 00! departu...
asked by 28.02.2018 / 19:28
1
answer

Query that shows names and vote counting in MySQL

I am starting to work with MySQL in a survey and I need to print the different names that I have in my table CANDIDATE and make a count of the votes that each one has in the table VOTES , the tables are referenced by the CANDIDATE_ID. I'...
asked by 28.02.2018 / 18:07
0
answers

Insert in mysql

I am working with cordova Do this this function that brings me the data of a mysql database. Using a php file function traer() { $.getJSON('http://127.0.0.1/bd/traer.php', function(data){ var x=data.length;...
asked by 28.02.2018 / 19:37