Questions tagged as 'sql'

Tagged questions
2
answers

SQL update query syntax error

When I run the following update query, a syntax error occurs before or within from: UPDATE Artigos SET totale = entradas.sent FROM Artigos INNER JOIN (SELECT cod_artigo, Sum([quantidade_ent]) AS sent FROM entradas GROUP BY cod_artigo) ON Arti...
asked by 07.07.2016 / 17:38
0
answers

Store array in the database and recover using one of the array information [closed]

I need to develop a system where I capture the selected data from a checkbox and insert everything into a array , I believe this is the most appropriate method to store, and then send it to the database, and time to retrieve the dat...
asked by 10.07.2016 / 03:18
1
answer

Dynamic Form PHP and Mysql - Codeinigter

I need to create a form to create assessments, with lots of variable questions. For this I created a form that adds questions, as requested; The problem is to save on%% of this variety of issues. To be clearer, follow the Code; <div clas...
asked by 24.06.2016 / 16:51
1
answer

Drop Index with SQL Variable

I am an inexperienced grasshopper and am looking to make an automatic script for myself. This script I created in batch and I can go without problems until the installation of SQL , restoration of the database and execution of some Querys....
asked by 28.06.2016 / 21:58
1
answer

Confirm Code and Switch to login page

Friends I'm new to PHP + sql help me here: -- -- Estrutura da tabela 'verified_user' -- CREATE TABLE IF NOT EXISTS 'verified_user' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'email' text NOT NULL, 'password' text NOT NULL, PRIMARY KEY...
asked by 25.07.2016 / 23:46
1
answer

Sql Reader returning null value

I'm running a datareader , but it does not return any value, I've already checked the table and the conditions ( where ) of select exist in the table. The code follows below: public void consulta() { string sq...
asked by 04.06.2016 / 18:06
1
answer

How to convert this Sql to entity framework?

I'm having trouble passing this sql to Entity Framework I'm using mvc 4. select pc.Nome, pc.Endereco, pc.Bairro, pc.Numero, pc.Telefone, pc.Email, ma.descricao from PontoDeColeta pc Inner join Material ma on(pc.IDMaterial =...
asked by 05.06.2016 / 02:38
1
answer

Summation and average sql table in java

I'm trying to get problems with something I think even simple, but I do not know which command I should run to do this. Well let's go there: I have a table (let's call it FILMES) ... and this table has 3 columns. What I need: I need t...
asked by 12.07.2016 / 03:53
0
answers

sql problems with disntinct

I have a table in my database with: horarioId horarioParagemId horarioLinhaId horarioHora I make INNER JOIN of the table rows: linhaId linhaNome I do INNER JOIN of the...
asked by 01.06.2016 / 13:43
0
answers

Difficulty with Weekly Agenda View

I'm trying to create a weekly display schedule that displays the scheduled classes for each day and time, and also leaves vacant schedules unchecked. I developed the following code to record all the dates of classes. However, I can not display s...
asked by 02.06.2016 / 01:32