Questions tagged as 'mysql'

Tagged questions
1
answer

Unable to create socket: Permission denied

I have been trying to enter the PDF document viewer that comes by default in deepin (evince) and I see this error Unable to init server: Unable to create socket: Permission denied Cannot parse arguments: Cannot open display: I guess it ma...
asked by 03.12.2018 / 23:09
0
answers

error jdbc mysql driver in dropwizard

This exception is being thrown at me and I do not know what the cause is Could not clean up [statement:"select * from shop_item limit 1;", located:"select * from shop_item limit 1;", rewritten:"/* ShopItemDAO.getItemById */ select * from s...
asked by 04.12.2018 / 19:48
1
answer

Creating a multidimensional array with php and MySQL

I'm creating a multidimensional array, which by necessity should be something like this: The lengths (225,250 ... 950) will not always be the same, depending on what is in the database, as well as the categories (T1, T2, T3 ... T12) I did...
asked by 03.12.2018 / 15:19
1
answer

Stored procedure with a parameter to find match while writing Mysql

Friends know how I can do a stored procedure using like that that receives a parameter, where when I say let's put the letter "a", look for all those that begin with that letter create procedure sp_busca_albun( in nombres varchar(200)...
asked by 02.12.2018 / 01:37
0
answers

Print in a pdf image a database field

<button class="col-xs-12 col-sm-3 col-md-3 col-lg-3 btn btn-success"> <a target="blank" href="IIICERTIFICADO.pdf" >Imprimir Certificado</a> </button>    Good morning, I would like you to guide me in this doubt. I want...
asked by 03.12.2018 / 17:47
0
answers

Consecutive in PHP and MySQL

Good day I have a table in mysql called "def_consecutivo" where there is a field id iddef_consecutivo | desde | hasta | contador the id is a field to identify ranges desde is for the start of the range of numbers...
asked by 03.12.2018 / 17:16
1
answer

Return ID registered in a procedure stored in mysql

Hello, I have the following code in php which makes the registration of a sale what I want is to perform the following action. Return the id of the record stored in the DB $query = "CALL sp_insert_venta(:tipo_pago, :tipo_comprobante,...
asked by 30.11.2018 / 21:19
0
answers

Problem to connect netbeans with Mysql

I'm having trouble connecting a netbean project with one from Mysql, I imported Mysql and added it to the library. But I have the following error: java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java...
asked by 07.12.2018 / 12:11
2
answers

Show Query in Ventana Modal

I have a question with AJAX & PHP. I have a table of clients and I would like a bootstrap modal window to show me a mysql query in function to the client that I press. When pressing INFO, show me the Mode with a query in function...
asked by 07.12.2018 / 07:46
1
answer

Error creating temporary table Mysql Php Pdo (mysql.column_stats: expected column 'max_value' ...)

I have an extensive procedure that runs directly in mysql works, now when I put it in php I get an error from the beginning that is creating a temporary table from where I will be getting data for the remainder of the report. This is the code th...
asked by 29.11.2018 / 20:46