Questions tagged as 'sql'

Tagged questions
0
answers

How can I save my data in my sql server manager with php through a registration by voting

Well as the title says, I have a problem which is the following, I have a file with codes in which I would have to save the data of the person in my sql server manager who votes in a forum. when they press to recieve ward I jump first You must v...
asked by 23.11.2018 / 02:00
1
answer

How to optimize ORACLE query?

I need to optimize queries so that having a better performance when looking for the data is taking me too long an example This is the query I'm using the ORACLE database SELECT SM_ID, ORIGINAL_ADDRESS, DESTINATION_ADDRESS, SUBMISSION...
asked by 23.11.2018 / 13:01
0
answers

Query SQL to table with several values that meet conditions

I have this query: SELECT Comments FROM Interview WHERE Profile_ID=[@field:Recruiting_Candidato_ID] AND Job_ID=[@field:Ofertas_Oferta_ID] The problem is that in the Interview table there are several lines that meet both conditions, then I j...
asked by 20.11.2018 / 17:34
0
answers

error in web hosting but not in xampp when doing a sql search

The error that appears to me is the following Error looking for Users:    You have an error in your SQL syntax; check the manual that   corresponds to your MariaDB server version for the right syntax to use   near '' at line 7 On my lo...
asked by 25.11.2018 / 02:04
0
answers

How to get ORACLE results per hour?

I'm trying to get the data per hour of each day I have the following data: FECHA_MUESTRA LABEL 11/11/2018 00:00:00 00:00 11/11/2018 00:05:00 00:05 11/11/2018 00:10:00 00:10 11/11/2018 00:15:00 00:15 11/11/2018 00:20:00 00:20 11/11/2018 00:25...
asked by 19.11.2018 / 14:10
0
answers

question optimize sql query

good day I have a query where I use a merge in store procedure I have a screen that has 7 thousand records that I must insert or update, the detail is that the process lasts about 5 minutes and I want to see a way to do the most fast I have the...
asked by 17.11.2018 / 04:52
0
answers

Entity Model Relationship of Minesweeper

I would need a little help with the relational model of the classic minesweeper game, I leave the slogans that modeling should solve:  A ranking of players by number of attempts in the matches until all the mines are discovered.  A ranki...
asked by 18.11.2018 / 13:48
1
answer

java.sqlexception: no suitable driver found for root

I created a java program that creates a connection to the database and I get the error java.sqlexception:no suitable driver found for root . I do not know where the error can come from and I need help. I show you my code below: pac...
asked by 25.11.2018 / 08:19
1
answer

Update with a from [closed]

I'd like to know what I'm doing wrong in my SQL query update tabla_c set tabla_c.precio = tabla_c.precio * talba_b.porcentaje FROM cat_marca as tabla_c inner join cat_concepto as tabla_a on tabla_c.id_concepto = tabla_a.id_co...
asked by 16.11.2018 / 19:02
0
answers

multiple query in JAVA - SQL

I am executing this query in java to a database in SQL, if I do the query in the following way, it runs without problems: String consulta= "SELECT * FROM Produccion.Transferido WHERE WO = '"+jTextIngresoWO.getText()+"'"; But I need the qu...
asked by 15.11.2018 / 16:39