Questions tagged as 'sql'

Tagged questions
1
answer

questions about category and subcategory

Good afternoon I created a system of category of products in the store that I am putting in it I have a page that calls for get the categories but I have a problem I have more than one category per product and I am not able to do list it so much...
asked by 31.08.2015 / 21:25
1
answer

SQl in PostgreSQL: No Repeat Values of a Table field

I have a select that displays the names, date and values paid by clients. I have to display a list without repeating the names. SELECT c.name, p.created_at, p.amount_paid FROM payments as p, clients as c WHERE p.crea...
asked by 27.10.2017 / 16:31
1
answer

PHP data replication

I have a very large page (main software flow). I am experiencing a problem that rarely happens, but sometimes the request is doubled, as if I had sent the same form twice, but no, I just clicked send and I await php's response to tell me the suc...
asked by 19.05.2017 / 14:52
1
answer

How to convert sysdate to milliseconds in Oracle?

How do I convert sysdate to milisegundos directly into Oracle? I need to give the same result of the code below in java, but directly in query : String s=df.format(Calendar.getInstance()); java.util.Date parsedUtilDate = df.p...
asked by 23.02.2017 / 21:49
1
answer

How not to select rows with values between an informed list of values

Instead of using the logical operator of != , I'd like to use a code that does the query by disregarding a list of values such as In only the reverse. Select from teste where teste1 (código) ('x','y','a','g') I'm using...
asked by 20.02.2017 / 15:35
1
answer

Join 2 SQL with different results [closed]

asked by 27.01.2017 / 16:43
1
answer

how popular is the object array with SQLite data

Well come on, I'm making an application, this will have several student names. I made a method that would add each name to a DB table. no bd is like this (Antonio, Pedro, Caio, Felipe ......). I need this data from the DB to be recovered and...
asked by 30.01.2017 / 00:58
1
answer

PHP, error making query [closed]

My problem is that I want to make an appointment, but I can not get all the records, and this is what I can not do. I will change to SQL later, so I left it to test. Can someone help me?? This is the Error    WARNING: Mysqli_query () expec...
asked by 29.11.2016 / 17:07
1
answer

Indicate a column if it exists in ALL elements of another SQL

I have the following question: "Enter the" name3 "which are in ALL" name ". And I have 4 tables that are below -- A (name,Num2, local) insert into A values ('Favela',1,'WE'); insert into A values ('Lamosa',2,'NA'); insert into A values ('Lu...
asked by 01.12.2016 / 12:41
2
answers

Assign value in SQL variable

How do I make a select that assigns the value "10" in all of the games column? NOTE: Do not give update in the table. /*minha_tabela*/ codigo jogos --------------------- 1 10 2 10 3 10...
asked by 15.04.2017 / 04:18