Questions tagged as 'sql'

Tagged questions
1
answer

error query php sql phpmyadmin in data type SET, does not return the data correctly (write error)

I have a conculta to my database function ticketsanulacionpendientesSISTEMAS($conexion){ $pendientes = (mysqli_query($conexion, "SELECT COUNT(*) AS conteo FROM ticket WHERE tipo_solicitud = 1 && status = 1 or status= 2 or stat...
asked by 19.04.2018 / 17:18
1
answer

Invalid parameter number: parameter was not defined in PDO PHP

Good day community, I have this problem when wanting to save data in my database, I am creating a SignUp, but since adding "FDia", "FMes" and "Fño" to my form and it is stored by PHP , throw me that error, and investigate other related qu...
asked by 27.01.2018 / 21:25
3
answers

Perform Search between dates. Sql Server

Good afternoon, I'm doing a simple query of a logical in db2 that is numeric but contains dates of the following format 20170831, but when doing the query with both 'between' with the operators '> = < =' brings all the existing dates....
asked by 31.08.2017 / 21:09
1
answer

Syntax error Mysql in J2EE Web application Servlets and JSP's

I am building a small web app using NetBeans 8.2 with J2EE. At the moment of executing the following query in the DAO, it shows me a MySQL syntax error that does not exist since if I execute the query in the BD manager there is no syntax prob...
asked by 23.10.2017 / 13:40
3
answers

Show values within a range

I have the following SQL code: SELECT (CAST(DATEDIFF(dd,Fecha_Nacimiento,GETDATE())/365.25 as int)) Edad FROM Clientes Which gives me back the age, what I want to do is to be able to visualize in a query the age range, that is, a table wit...
asked by 11.09.2017 / 23:29
1
answer

Foreach datagridview row update stock

It is possible to update a stock with stored procedure using a foreach that is, I have this procedure execution: SqlConnection conec = new SqlConnection(); SqlCommand cm = new SqlCommand(); cm.Co...
asked by 06.08.2017 / 20:32
1
answer

Can I install SQL server in linux? how do I install it [closed]

I CAN NOT INSTALL SQL SERVER IN THE LINUX OPERATING SYSTEM     
asked by 09.08.2017 / 03:33
2
answers

How can I resolve this query?

They ask me: what is the most expensive mazda brand vehicle plate sold in 2017? I have 3 tables: vehicle, owner, sale Vehicle: primary key plate, color, make, model Owner: id primary key, identity card, name, surname, email. Sale: idv...
asked by 30.07.2017 / 02:02
3
answers

Error increasing the value of the viable Php / sql

Good day, from a php form I am capturing the information in phpmyadmin. In the background is the realization of a purchase that when stored in the database increases the purchase number (purchase 1, 2, 3 etc.). I have reviewed the code sev...
asked by 15.06.2017 / 10:37
3
answers

Get records sorted by date and limited to 1

I'm trying to do an SQL query that I do not know if it can be done, but my purpose is to obtain the records depending on the id's, sorting them by latest date and limiting them to 1 to initially only show a record and then in another view show a...
asked by 14.07.2017 / 07:37