Questions tagged as 'sql'

Tagged questions
3
answers

Checking duplicate MySQL records

I have a database, where the company's invoices are stored, and I need to see the duplicate records (invoices that have the same series, number and type). For each record I have an id id that identifies them. What I want to list are all the ones...
asked by 07.07.2016 / 23:22
1
answer

Optimize query mysql Sorting result

As the title says, the query I have is this: SELECT id, first_date_order, last_date_order, (SELECT o.created_at FROM orders o WHERE o.customer_id = c.id ORDER BY o.created_a...
asked by 07.03.2017 / 21:01
1
answer

It does not let me create the database in phpmyadmin and it gives me this error: # 1064

The error he gives me is this:    1064 - 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 'KEY (id))' at line 8 and this is what I programmed: CREA...
asked by 08.06.2016 / 14:38
1
answer

Error building a JSON in PHP

I'm trying to build a JSOn from PHP, but when I put two conditions it does not generate the data. That is, I only need to bring the data of SARA , but when I put them in id_ppl and level at the same time, I get nothing. I do not really k...
asked by 02.08.2018 / 18:05
2
answers

Why do the records in a Postgresql table keep blanks?

Quetal friends, I'm doing a practice with PHP + PDO and postgresql, and I've realized that when I save the data it leaves me blank. I attached an image and this is the code. <?php include_once "conexion.php"; try {...
asked by 30.06.2018 / 18:02
1
answer

How to select the second and the penultimate item in php?

How can I select the second and the last item in a MySQL table with php. I tried to do the following but limited myself to position 12 of 15, and must show me from position 2 to 14 of 15 in total, the second and the penultimate item. The i...
asked by 30.08.2018 / 04:05
2
answers

Where are the .sql files stored in windows?

I installed MySQL in windows 10 64 bits and I am testing the example databases, download one that they use in an example that I follow, it is called northwind, I do not have it and I download it from the internet, I want to include it so that it...
asked by 15.09.2018 / 21:46
2
answers

Help in the sql query (sum)

I'm doing a Query where I add the amount of products that I have after multiplying it .. This is the Query. declare @Sucursalid int set @Sucursalid = 1 SELECT i.sucursalid as SucursalID,( COUNT(p.id) * p.pesomililitros) AS Cantidad...
asked by 29.08.2018 / 18:12
2
answers

"Can not POST" in node.js and postman

It happens that I have this code, where I try to pass by the user parameter and password using as a postman tool, I'm honestly new to this so I do not know if I'm doing well or the code is wrong since I get this error in postman app.post...
asked by 05.09.2018 / 19:23
1
answer

Query of matches does not show record

I have a SQL query which looks for a table according to four parameters or if there are no parameters returns all the records in the table, the problem is that when searching for a title no results return and it is assumed that if have a match w...
asked by 03.01.2018 / 23:35