Questions tagged as 'sql'

Tagged questions
1
answer

Optimize MySQL query

I have a query that takes 0.2650 seconds to run and I would like to optimize it, I have done a lot of tests (Add new indexes, delete them, create views) but nothing has improved the performance of the following query: SELECT enlace_click.id,en...
asked by 17.04.2017 / 06:18
2
answers

SQL query with PHP

I am editing a reservation system with PHP and I want to make some inquiries. I have 3 Tables w_clases w_clientes w_reservas In summary I am trying to make a query with a form that puts the start date and end date...
asked by 17.04.2017 / 21:33
2
answers

Error "not a valid month" SQL

Good afternoon; I'm doing an exercise for my Database course, they passed us a script to create the tables and do the inserts of the elements (I use the Oracle Application Express). But when executing any insert I get the following error:...
asked by 20.04.2017 / 17:41
2
answers

Do an Update with ORDER BY in PHP

I have another problem at the moment of wanting to make the modification of the file, I have in the same table the years 2016 and 2017 with the regristers that start from 1 to ... x number, the problem is that the Id are repeated if the year beg...
asked by 10.04.2017 / 15:18
2
answers

In a SQL query with Visual FoxPro, how can a record access the information in the previous record?

I am working with an application that is built with Visual FoxPro 6.0 , at this moment I need to make a query that allows a record within a SELECT to obtain information from the immediately previous record to perform a calculation. The...
asked by 07.04.2017 / 13:58
1
answer

Duda Select SQL

I'm new here. I'm not very skilled in SQL. I hope someone can help me I want to make a query to the same column (star_result) but separate the results depending on whether the column rating_item_id has a value 2 (Importance) or 3 (Urgency)...
asked by 05.04.2017 / 12:06
0
answers

how to make a query with a "like" in firebase

Greetings I'm trying to make a query similar to select * from where name =% data%, e seen the methods startAt and endAt but they do not work, any suggestion is appreciated     
asked by 06.04.2017 / 17:31
1
answer

I can not view VIEW in PhpMyAdmin

Good, in one of my applications I need to access the View of the table, but for some reason, it seems that the user does not have access. When I try to access through phpMyAdmin, it sends me the following error error #1045 - access denied f...
asked by 24.04.2017 / 15:19
2
answers

How to use inner join?

I have this query $query=$db->query("select empleado,count(*) as v from empleado inner join oficinas on empleado.numero=oficinas.numero"); but it gives me this exit...
asked by 04.04.2017 / 14:30
1
answer

Avoid duplicate field of BD PHP

I have a table in the Database where I have repeated fields and blank fields. And I must show the results without repetitions and without empty fields. I have worked on the following code, which so far does: for($nombres=array();$row=...
asked by 12.04.2017 / 19:29