Questions tagged as 'mysql'

Tagged questions
1
answer

Concatenate data correctly when doing a select in java to db

I was making some improvements to my small system and I get the doubt because I've always been concatenated to data in the where and not after the select, since now the question is to concatenate the selected table (db) and the pk (dni) entered....
asked by 18.03.2018 / 05:32
1
answer

Weekly query php mysql?

I have a project and I need to organize weekly results in a table. <!DOCTYPE html> <html> <head> <title>tabla semanal</title> </head> <body> <table border="1"> <tr> <th...
asked by 10.03.2018 / 15:37
1
answer

Problem with DDBB MySQL and Eloquen relationship

I have 3 Models (tables) in the development of a web page: * Article *Colour * Size The tables must be related since "Article" can have several colors and several sizes. The problem is that there must be a "Quantity" field that I do not kn...
asked by 12.08.2018 / 02:13
2
answers

Load JLabel from MySQL

I am working in Java and I need to place a jLabel that obtains information from the Database, in this case it is a "Registration Number" every time that the Form will be done, you must bring the name and upload it in said Jlabel. I have tried se...
asked by 10.08.2018 / 17:30
2
answers

Query php to mysql [closed]

I have a question, I give you an example, I have a table with several data and in it there are 6 cells called piloto1, piloto2, piloto3, ...etc.    You could make a query to put the cells together and that   Printase everything in t...
asked by 22.08.2018 / 18:16
1
answer

Table Path that stores the Stored Procedures in MySql?

I need to migrate the database from the server, and for this I need to know which is the path of the table that stores the Stored Procedures ...     
asked by 24.08.2018 / 20:59
3
answers

convert the result of a SQL query into an entire PHP variable

I want to store the result of an SQL query in a PHP variable but as an integer, this is my code: $maxnroviaje=mysql_query("SELECT MAX(NROVIAJE) from viajes"); $nroviajenew=mysql_fetch_assoc($maxnroviaje); and doing echo on those two variabl...
asked by 19.02.2018 / 02:45
2
answers

Problems when making an SQL query with the use of UNION

I have the following problem when trying to make this query SQL in MySQL SELECT * FROM Like__post WHERE id__post_ = 2 UNION SELECT * FROM Post WHERE id__post = 2' me genera el siguiente error ' SELECT * FROM Like__po...
asked by 14.12.2017 / 14:23
2
answers

Problem with a query in MySQL

I have a problem with how to formulate a query to obtain the following: I have a table called TBL_BIT_TIPO_INGRESO where I store the types of economic income when registering some students. It is assumed that by default a text that says "FAMILY"...
asked by 30.01.2018 / 02:34
1
answer

PHPExcel Report with subtotal and total

It happens that I execute this query to export to Excel the information: SELECT IFNULL(s.id_servicio,'Total') AS id_servicio, IFNULL(s.fecha_servicio,'General') AS fecha_servicio, c.nombre_conductor,c.apellido_conductor,...
asked by 12.01.2018 / 05:25