Questions tagged as 'query'

1
answer

Ms access 2 querys for the same comboboxes

Good to all I'm programming a database and I would like to have a kind of 3 querys. I'll try to be as accurate as possible. I have 2 combo boxes that are interconnected, in this case I specifically make and model, and when I choose the brand, it...
asked by 01.07.2015 / 22:13
2
answers

Query to return multiple results

I have this Query MtDispositivo.where("id_conta = ?", "28") which returns all the accounts that have ID_CONTA = 28 . Below I have these other Queries that return me same result that are accounts with ID_CONTA tal. MtDisposit...
asked by 29.06.2015 / 17:15
1
answer

Error copying data from one table to another

Good afternoon, I'm doing an application that does a dvs loan request, I was able to make the application to insert the reservation, now I need to make the owner of the dvd confirm the rent and copy the data in the table of rented dvd but I have...
asked by 05.06.2015 / 17:56
1
answer

inserting image into mysql database

If I want to insert an image into the database, just use the following query: INSERT INTO teste (Id_Blob,Na_Imagem) VALUES (1,LOAD_FILE("C://imagem.png")); If I want to insert an image that is on another computer on the network, how does th...
asked by 18.06.2015 / 02:16
1
answer

Return last entry of each object in the database

I have two tables: monitor_carro id serial | setor_id | modelo | ano | placa monitor_evento id serial | lat | long | data | fkfuncionario_id | time | carro The monitor_evento table only has a foreign key th...
asked by 25.02.2015 / 19:24
2
answers

How to sort contacts by name?

I have the following code and would like to make an ORDER BY name: try { String clsSimPhonename = null; String clsSimphoneNo = null; Uri simUri = Uri.parse("content://icc/adn"); Cursor cursorSim = getContentRes...
asked by 20.10.2014 / 16:05
0
answers

Result of searching for two tables without relation

I have a question if it is possible to return in a query, records of two distinct tables, these tables having no relation. I have the table clothes and table accessories. I will make a dynamic filter to list clothes (color, size and price) an...
asked by 13.07.2015 / 16:37
0
answers

Detecting slow queries in Rackspace MySQL

Is there an easy way to see the slow queries in Rackspace's MySQL? I've tried these instructions , but they are very complicated ... Original post in English     
asked by 13.08.2014 / 01:49
2
answers

How to pass a parameter from the server to the client in Datasnap?

How can I send and receive data using datasnap? I have a database MySql, a Mobile application in Delphi Seattle with a datasnap server, the connection works and I can get the data from the bank and play pro mobile, but my question is: I need to...
asked by 28.03.2016 / 14:54
1
answer

Check frequency of records in the table

I have a table where all services performed on several cars are saved. The key is the car license plate. A car can have more than one service a day. And for each service performed a new service id is created, even if it is for the same car. I...
asked by 23.11.2017 / 20:06