Questions tagged as 'query'

Tagged questions
1
answer

SQL to count records that have a field

Good afternoon, I do not know how the rules of the topic work, I asked for help on a previous topic and one of the members ended up helping me, but I wanted to get one more question about the help. The query he helped me with is below and...
asked by 25.07.2017 / 20:11
3
answers

Doubt SQL Query d

I am wanting to perform the calculation in the sql query where the result is the amount of open calls divided by the number of weekdays chosen period. Ex: 200 calls have been opened in the month and there are 17 working days in the month of May,...
asked by 30.06.2017 / 16:13
0
answers

Query with return #num! for string columns in excel

I made a query in excel that when running it in VBA a result was generated. Among the generated columns, one that was text appeared with #num! in all values that were not empty before. I think excel understood that column was numeric even tho...
asked by 04.07.2017 / 02:59
2
answers

Problem inserting double value in MySQL

query += txtServidor.Text + "',";<br> query += double.Parse(txtVencimento.Text) + ",";<br> query += int.Parse(txtBanco.Text) + ",'";<br> INSERT INTO tbl_associados VALUES(10,'testando','001.318.555-55','categoria','ativo',...
asked by 30.03.2015 / 14:58
1
answer

How to concatenate the return of a query to a string of another mysql

I have the following query: SELECT id AS CODIGO, nome AS NOME, versao AS VERSAO, build AS BUILD, data AS DATA FROM sistema INTO OUTFILE 'D:/servicos/export/exportaVersao.csv' FIELDS T...
asked by 04.07.2017 / 05:13
1
answer

SQL to check skipped number

I have a table with 12,560 records from 5 years ago, that is, it does not have such a good modeling and it has a field called 'code' that the user filled with something like CA-0001. The problem is that at some point in the history of this datab...
asked by 23.06.2017 / 18:32
1
answer

Row Results in Columns (SOMA)

Good afternoon, I have a big question in my query, I have a table with the following info: Iwouldliketogetthefollowingresult I need the result to be the total amount of (payment forms) per day, divided by period in two columns, M and N....
asked by 12.06.2017 / 19:57
1
answer

Limit and Offset for web paging in SQL Server

I'm working with PHP and I have about 8000 records currently in DB. As it is for a web page, I need to make a pagination to be viable reading the data. As I understand it, I have to do something similar to limit and offset to...
asked by 28.11.2016 / 13:35
2
answers

Bulk change in MYSQL

Hi everyone, all right? I have a database in mysql and I need to make a bulk change, how? I want to change all the records in the "show_address" column of the ptv_osrs_properties table to "1". I have about 300 records, can I do this in...
asked by 31.05.2017 / 20:52
0
answers

insert into two tables at the same time with php [duplicate]

I'm in trouble. I have the usuario and aluno tables that are related by primary and foreign key. I want to make an insert with php to insert data into the two tables, and the idusuario of the usuario table sh...
asked by 23.05.2017 / 20:38