Questions tagged as 'sql'

Tagged questions
2
answers

SQL Joins, select data from different tables

I'm having problems selecting data from different tables, I explain. I have three tables and I occupy certain data of each of them: usuarios AS u u.id u.usuario proyecto_emp AS p p.id_proyecto p.us_id p.rol roles AS r r.id r.rol...
asked by 28.08.2017 / 23:53
0
answers

Error with consecutive field in MySql

First of all, thanks for reading. I am adding data from php to a bd and I have a field in my table that has to be generated consecutively, but when I delete some fields and add a new one, the consecutive numbering stays in the last field that...
asked by 24.04.2018 / 02:37
2
answers

Consult per month

I have a table which shows a monthly condominium invoice, but I need to show the expenses that were recorded in the last month only in the database and not all the expenses that are, here is how the table is formed of the database Here is...
asked by 04.09.2017 / 21:06
1
answer

Get content that was produced there is less than one time with SQL on PostgreSQL

I want to recover for the content that was produced there is less than 30 days: -- veces una personna deu groupo interragi con contenido, SELECT COUNT (swipe.state),swipe.eclipse_id FROM swipe WHERE (swipe.state= 2...
asked by 02.08.2017 / 17:56
0
answers

SQL query with "left join" and an "if" in PHP [closed]

I have this query: $customers_query_raw = "select ex.codigo_op, ep.entrega01_clave, ep.descripcion_articulo, ep.entrega01_envases, ep.entrega01_importe from " . TABLE_EXPORT_PATRIMONIO . " ep left join " . TABLE_EXPORT_COMPARATIVA_PATRI . " ex...
asked by 08.08.2017 / 12:13
0
answers

wcf (sql server) + listener in android studio [closed]

I wanted to ask you about the paradigm I am using to work on my application with respect to the information that it handles: Basically, when I want to update the information I have to call my web service to update the data I store with sqlite. T...
asked by 07.08.2017 / 22:35
1
answer

Do I need the total of word matches between 2 strings with MySQL?

I already managed to bring the Categories in which at least found (1) a word, regardless of the order (in a MyiSAM table with Fulltex index) ...... Now the problem is knowing the total of coincidences that had in each record or the one that had...
asked by 05.08.2017 / 00:31
0
answers

I do not insert the [closed] record

When I insert it, it appears that it was successfully added but when reviewing the database it does not show the inserted record. My code is as follows: Dim qryInsert As String = "INSERT INTO sadcc (cc_grupo_compras,cc_nombre_comprador,cc_cor...
asked by 28.07.2017 / 17:48
1
answer

Error installing SQL Server Managment 2008 Express

I already tried everything and I did not succeed with the installation, so I come to you to see if you can help me. Problem: Unable to install SQL Server Managment 2008 Express. Error: "Error 1911.Could not register type library for fi...
asked by 26.07.2017 / 14:49
2
answers

How to update postgres database structure without altering its records?

What I need at this moment is a way to update the structure of the database without altering its records, I have a database that has not been touched for a long time according to the versions of the system I currently manage, therefore I need to...
asked by 06.07.2017 / 23:12