I am writing a code on CodeIgniter for the release of free and non-profit cloud storage software.
However, in order to work, we will have an affiliate system, which allocates a certain amount of storage to the most advertisers, as well as to...
DBMS: SQL SERVER 2014 + MySQL 5.5
What are the SELECT, INSERT, and UPDATE syntax instead of using the "OPENQUERY" function, when connecting through the SQL Server Linked Server, connecting to MySQL?
What I want is this. I am working on a system, which has registered an employee and days in which he worked on the month. So far so good, but it happens that in some cases, the employee has 2 or more records in the same month, for example, I reg...
I tried to use NOT EXISTS , but it is bringing the results that do not exist in the tb_pedidoproduto table, I believe LIMIT is not working:
SELECT produto.idproduto
,produto.nomeproduto
,produto.idcategoria...
Good morning!
I created this query in mysql and when I add the 1st subquery I called "totalEscolas" I get the following error: "Subquery return more than one row" without this subquery the code works blz.
Could you help me? Thanks!
SELECT...
I want to get the value of a query in mysql
SELECT lamp_estado, lamp_descricao FROM lampadas ORDER BY lamp_id
And record each value found in the search, in a variable.
I am using this command but it is only writing the last search va...
I have the following scenario and need to add the result of a Select in another column of the same table, for example, a column with the numbers and another column to check how often these numbers appear: / p>
números|frequência
1 | 2
2...
Good morning,
I have an application developed in Delphi 2010 with MySQL, the base is in server on the Web, a few days ago they migrated this server and updated the version of MySQL, since then I have had a problem, when one of the clients ins...
Good afternoon, how can I make a query where I have in my field idProduto several% com_dependent comma% and list each of their respective.
For example, in my ids I have the idProduto I want that in my query it returns me wit...
I have a table where records are saved every 3 seconds 24 hours a day
Table: myTable
dado1 dado2 dado3 data
"135,05" "134,69" "135,10" "2018-11-13 15:38:16"
"132,00" "131,91" "132,61" "2018-11-13 15:...