Questions tagged as 'mysql'

Tagged questions
1
answer

How to upload information from a Mysql to an EXCEL already established

What I'm looking for is that my information that I present in a mysql, can be shown in an excel already created, and that only autocomplete. I'm using the PHPExcel library ? Now I have the code in this way     
asked by 09.08.2018 / 20:31
0
answers

How to define an attribute of type DateTime in python

I would like to know how to set attributes in python within a class. And tried the following code: def __init__(self): self.fecha_Y_Hs = datetime.datetime.now() self.decripcion = '' I am new in this language and I would like to know...
asked by 09.08.2018 / 20:56
1
answer

SELECT FOR UPDATE MYSQL

I have a simple query that I execute in mysql with phpmyadmin : select * from tabla for udpate ; But I get an error "an expression was expected" . I can not realize what is missing. Thanks!     
asked by 10.08.2018 / 22:17
2
answers

I can not connect my html form to the database

I leave my code of the form and the connection .. <? php $conectar=@mysqli_connect('localhost','root',''); if (!$conectar) { echo "No se conecto a la base de datos"; }else{ $base=mysqli_select_db('optica'); if (!$base) {...
asked by 21.08.2018 / 22:57
0
answers

I have problems finishing a Maven Java exercise

I need to make a kind of final page where all the data that I collected and created at the beginning through 2 forms is detailed. One form is data collection to create a work order in a workshop and the other form creates an owner. The owner for...
asked by 08.08.2018 / 20:16
0
answers

Time Intervals with Mysql

Hello friends I have a problem that I have been struggling with in the last few hours, it turns out that I have to graph the conversations that have not been answered, and these are the catalog from mysql, in a way: one day, 3 days, 1 week, a...
asked by 08.08.2018 / 20:58
1
answer

how can I fix it list index out of range

I have a query and that query only throws me a record and when I optengo I ask you to throw me the value that is in the position [0] for a in datos_estados: tabla_datos = [a["estado"], a["seccion"], 'Teorico'] for vuelta in range(mes_i...
asked by 08.08.2018 / 20:12
0
answers

how can I put a sql text file in php and respect the line breaks?

my SQL file is one of text point with the following content: Futbol 00:00 basketbol 02:00 and when it's time to call it by php, print it to me as: Futbol 00:00 basketbol 02:00 Any ideas?     
asked by 09.08.2018 / 23:06
0
answers

Multiply an echo of PHP

I continue with the table of filtered by divs. Well, now I'm doing a SELECT that has two options "PVP with VAT" "PVP without VAT". In the WILE cycle, all the results come out depending on other selects and taken from a BD. What I need to know...
asked by 10.08.2018 / 05:30
1
answer

How to update in JSP and Mysql Using sql sentence IN

I have a question regarding the update of records with jsp and mysql, using queries with IN sentence, the problem that I present is that if I select only 1 record, the system updates me correctly, but if I select several records, then the query...
asked by 08.08.2018 / 14:53