Questions tagged as 'sql'

1
answer

Import Backup and Differential Sql Server

I'm having a problem importing a backup to the secondary server: The topology: Production Server > > Contingency server. When importing Full Backup, it imports without any problems. The problem occurs when I import Differential Backu...
asked by 23.01.2017 / 20:47
1
answer

Error in Hibernate when executing web project

I have an error that I could not solve, I started my project and it runs right. When I access the project via the web, I log in and it enters. When I click on any button, it gives this error below: Hibernate: select person0_.id as id1...
asked by 10.01.2017 / 15:02
1
answer

Calculate sql table in android

I have the following sqlite database and it works fine: db=openOrCreateDatabase("BaseDadosDB", Context.MODE_PRIVATE, null); db.execSQL("CREATE TABLE IF NOT EXISTS tabeladados(data date,total real,descricao VARCHAR);"); I want to return the...
asked by 12.01.2017 / 16:36
2
answers

Refresh and insert data into a table with information from another in another database

I have the following situation: Bank and the B bank both with the Customers table with the following data: A.clientes B.clientes id | nome id | nome ------------------- ------------...
asked by 12.01.2017 / 15:45
3
answers

Doubt with record grouping

In my example, I have a query that returns 3 products as they were purchased in different orders plus I do not need this order number. So I did it this way: SELECT c.prod_pk_id, '61068276007702' as CNPJ, 'teste' AS FABRICANTE...
asked by 04.01.2017 / 17:30
1
answer

Error while viewing or adding data in SQL

Good afternoon people, I was trying to make a sql to put the score obtained in a game I'm developing, but when I put it to save the score, or even see the score it gives error, I'll put an asterisk on the line where Android Studio points out the...
asked by 10.02.2017 / 16:10
0
answers

View + PostgreSQL problem

I have a problem with a SQL query. Here is the query example: SELECT col.ad_client_id, adu.ad_user_id, col.ad_org_id, col.c_order_id, col.created, col.createdby, col.updated, adc.updatedby, col.isactive, cb.c_bpar...
asked by 13.12.2016 / 17:49
1
answer

Make a select according to an indexed table

I have a table, getSalas , which simplified something like this: CREATE TABLE getSalas( ID_SALA NUMBER(4), NOME_CARATERISTICA VARCHAR2(20), VALOR_CARATERISTICA NUMBER(4) ); The contents of this table are of the type:    1, '...
asked by 26.01.2017 / 14:04
1
answer

How to make modification records in a MySQL table (without using triggers)?

I would like to know if there is another technique of making record changes in the tables without going through triggers ?     
asked by 21.12.2016 / 11:46
1
answer

MAMP - phpMyAdmin - Error

When I go into phpMyAdmin through Mamp, it gives this error:    phpMyAdmin - Error   Error during session start; please check your PHP and / or webserver log file and configure your PHP installation properly. Also ensure that cookies are enab...
asked by 20.12.2016 / 12:50