Questions tagged as 'sql'

Tagged questions
3
answers

Create a website with related search [closed]

Good morning, everyone. I want to know what I would need to create a website that stores the current and updated prices of different known web pages. I'm doing a project and I need help.     
asked by 03.02.2018 / 11:15
2
answers

Create an update from an if or a case in sql or postgresql

I'm doing an inventory program for a project with RFID. The problem is having the inputs and outputs controlled. When something comes out of the store, it does not necessarily come out permanently so it can re-enter, the problem is that the o...
asked by 10.01.2018 / 18:53
1
answer

Intervals of time between records

I have a table that is composed as follows:    Schedules id int(11) pk uq nn ai inicio datetime nn default "CURRENT_TIMESTAMP" fin datetime null default "CURRENT_TIMESTAMP" tipo tinyint(1) nn default 0 eliminado tinyint(1) nn default 0...
asked by 12.01.2018 / 17:36
1
answer

Perform mathematical operations in real time or array results

First of all, a cordial greeting! I tell you my drawback: I have 2 lists of inventory type (one is the origin of the data and the other should print the values entered in the first to be sent by email) the thing is that the values such as VAT,...
asked by 27.12.2017 / 08:00
1
answer

Queries with My SQL

I have a SQL query that I can not solve: Structure of the tables used:    User table id pk uq ai nn nombre varchar(25) null apellido varchar(25) null    Position table id pk uq ai nn cargo varchar(50) null departamento varchar(50)...
asked by 23.12.2017 / 05:18
1
answer

Select Rand () between From GroupBy and with OrderBy

I have a table with the following fields: id code category web_sales brand I want to show only random code in Laravel and group it by category but that the code is generated randomly. The problem is this: how do I group the cat...
asked by 19.12.2017 / 02:42
1
answer

Query sql server to delete an ID and a COLUMN

This I just invented and it does not work delete a.valor from persona a where a.Id = 3 How can I delete only 555     
asked by 19.12.2017 / 17:20
1
answer

Report between several tables with Eloquent Laravel

I have a many-to-many relationship between Users and Tasks    Users (id, name ..)       task_user (user_id, task_id)       Tasks (id, task, state) (STATE = finalized, process, delayed) I need to bring the number of total tasks per user...
asked by 20.12.2017 / 13:23
1
answer

Checkboxs selected from MySQL database

I have the following error: Fatal error: Uncaught Error: Call to undefined function mysql_query() Line 37: $sql = mysql_query("INSERT INTO cabanasaccesorios VALUES (".$idcabana.", ".$value.")"); Explanation: I have a form where I...
asked by 11.12.2017 / 12:30
1
answer

Postgresql Sub Query

Greetings. Currently the query I am using (without variables) does the necessary work, but now I need to add variables within it. INSERT INTO tabla2 (a,b,c,d,FK_ID) SELECT a,b,c,d FROM tabla1 In table2 I have a column fK_ID, how could I add...
asked by 15.12.2017 / 20:37