Questions tagged as 'sql'

Tagged questions
0
answers

Very slow query in WordPress

My website is very slow and I have seen that it is due to the following query, which takes between 10 and 20 seconds and I still do not know why. function get_car_versions($car_id) { $args = array( 'post_type' => 'version',...
asked by 17.07.2018 / 16:25
0
answers

How to arm query with select distinguc count and group by in sql

I'm doing a stored procedure that returns some data to me from some files that are in some tables, I want to count how many different file types there are but it gives me an erroneous amount I was suggested to use group by but my query is not...
asked by 17.07.2018 / 17:32
2
answers

Errors in login form

I have made a page with Dreamweaver that has a private access area so that the administrator of the site can add content that is seen in the public part. I try it in local and everything works well. However, after having passed everything to...
asked by 18.07.2018 / 17:00
1
answer

How to make multiple UPDATES in a MySQL PROCEDURE?

How do I make two or more UPDATES run in the same PROCEDURE. CREATE DEFINER = root@localhost PROCEDURE sp_anularFacturaBoleta( IN idFacturaBoleta VARCHAR(11) ) BEGIN UPDATE detalle_factura_boleta SET cantidad = 0, precio_venta = 0, val...
asked by 18.07.2018 / 19:39
1
answer

How to format a date and place decimal points in Oracle?

I have a query which gets Date fields and fields type number The result of this query is placed in an excel file and what it does is that it does NOT show the date fields in DD / MM / YYYY format and it does not show the number type fields wi...
asked by 24.07.2018 / 21:00
0
answers

How to accommodate query data?

I have a query that returns the data I want, but to avoid using so many cycles in the programming part to present the information the way I want, I would like to know if there is any way to accommodate the next result of an sql query: a...
asked by 14.07.2018 / 06:53
0
answers

I can not add user using Java EE and MySQL. I can not find the error

Hello, I am trying to insert a user and I can not specify it. I do not find error in the code, however it is not achieved. JSP FORM: <form action="operador" method="post"> <input id="nombre" type="text" name="nom...
asked by 14.07.2018 / 04:00
2
answers

Help creating a Dynamic Insert in PostgreSQL

I have a table Juego which has 4 columns nombre, tipo, autor, proveedor , the function that I create allows me to enter data filtering according to characters correctly, but I would like to write the columns and the value of the arr...
asked by 13.07.2018 / 02:55
0
answers

See local bds in the xampp

Hi, I have a question about xampp, it is that I installed the xampp, but a few days ago I had created two databases, one per terminal and one for Sequuel pro, and both appeared to me from the sequel pro, and terminal. As you can see in sequel pr...
asked by 11.07.2018 / 23:44
1
answer

Problem when creating constraint in Microsoft SQL

Hi, I'm trying to create these tables in SQL create table Clientes( Tdoc varchar (10), Ndoc int, Nombre varchar(30), Apellido varchar(30),...
asked by 12.07.2018 / 01:35