Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

MYSQL request for data transfer from one table to another

G
guilherme last edited by

Please help establish a request at Mysql for the transfer of data from the 1st specific field for all values from the old database to the new, key field.
The structure is:
Old bd_old.table_old
New bd_new.table_new
There's a field in both databases.
We need all the values of this field from the old base.
There's a key field of 'id' that matches both bases.
Reply Quote 0
1 Reply Last reply
D
derk last edited by
Use UPDATE in conjunction with JOIN, so immediately filter out all the records that match, and only update them.
```
UPDATE t1
INNER JOIN t2 on t2.id = t1.id
SET t1.description = t2.description
```
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

Z

How do I know if an index has been successfully created in MySQL?
SQL, Database Testing • mysql index • • zymir

2

0
Votes

2
Posts

0
Views

Welcome. If you say that the script did not finish / exit... One crude method to find if the indexing process is in the middle... You shall try listing the folder contents of /var/lib/mysql/dbname/ and checking the date and time of update of the table names concerned. If the date/time does not change for a while you shall be sure that the process is not touching that table file for as much time. Hence cornering if there is a process snap due to timeout or other.
J

Data transfer mySQL
Software Programming • mysql • • jonetta

2

0
Votes

2
Posts

0
Views

INSERT INTO Table1 SELECT * FROM Table2
Sql request for one table
Software Programming • sql postgresql • • morde

2

0
Votes

2
Posts

0
Views

R

select equipment, sum((cstate = 'up')::int) as up, sum((cstate = 'down')::int) as down, count(*) as total from tbl group by equipment;
T

Update column from Base64 to string (natively in SQL)
SQL, Database Testing • mysql mariadb • • Trenton

2

0
Votes

2
Posts

0
Views

S

Since you haven't given us any information about the table or column in question you'll have to update my example with the correct information. update thetable set thecolumn = FROM_BASE64(thecolumn)
K

Impact of replication compression & encryption on performance, traffic?
SQL, Database Testing • mysql performance encryption replication compression • • Kadir

2

0
Votes

2
Posts

0
Views

E

I like this presentation by Giuseppe Bianchi. Starting on page 5 it contains a desctiption of the TLS protocol - segment size, header size, HMAC overhead. As for the handshake, the impact on replication should be negligible. It will only occur on connection, and there may be a key exchange going on every hour, depending on the configuration. As for the compression, I'd go with what the book says. Or you can try gzipping your binlog file, as the ratio will likely be application-specific. (This may not be accurate if the compression is initialized per packet, not once for the replication stream.) On performance - type "openssl speed" in the command line, you'll get a benchmark of the throughput of different ciphers on your computer. Find the relevant ones and calculate the utilization given the throughput you expect from the replication stream.
Count grouping per week
Software Programming • mysql sql selec languaget • • jeanid

2

0
Votes

2
Posts

0
Views

A

There is a MySQL function that gives you a concaternation between the year and the week of the year, called YEARWEEK(). Use it to get what you want.SELECT count(id), YEARWEEK(data_tarefa) anosemana FROM tarefas GROUP BY anosemana;
M

How to transfer data from one function to another?
Software Programming • javascript html functions variable • • meriah

2

0
Votes

2
Posts

0
Views

I suggest creating a third function where the value division is made. This will make your code much more flexible, as you can call it when you want in the other functions.See that below I created the function dividirValor() and commented on some lines that became unnecessary:var addCliente = document.getElementById("addCliente"); var addProduto = document.getElementById("addProduto"); var listaClientesContainer = document.getElementById("listaClientesContainer"); var listaProdutosContainer = document.getElementById("listaProdutosContainer"); addCliente.addEventListener("click", function() { addClienteFunction(); }); addProduto.addEventListener("click", function() { addProdutoFunction(); }); var contadorCliente = 0; function addClienteFunction() { var nomeCliente = document.getElementById("nomeCliente"); if (nomeCliente.value != "") { var postagemCliente = document.createElement("div"); var dadosDoCliente = document.createElement("div"); var areaDoValorDividido = document.createElement("div"); listaClientesContainer.appendChild(postagemCliente); postagemCliente.classList.add("postagemCliente"); postagemCliente.appendChild(dadosDoCliente); dadosDoCliente.classList.add("dadosDoCliente"); postagemCliente.appendChild(areaDoValorDividido); areaDoValorDividido.classList.add("areaDoValorDividido"); dadosDoCliente.innerHTML += contadorCliente+1 + " - " + nomeCliente.value; areaDoValorDividido.innerHTML = "R$0"; nomeCliente.value = ""; contadorCliente++; dividirValor(); // chama a função para dividir os valores } } var valorTotal; // define o valor total var contadorProduto = 0; var valorDividido = 0; function addProdutoFunction() { var nomeProduto = document.getElementById("nomeProduto"); var precoProduto = document.getElementById("precoProduto"); if ((nomeProduto.value != "") && (precoProduto.value != "") && (!isNaN(precoProduto.value))) { var postagemProduto = document.createElement("div"); listaProdutosContainer.appendChild(postagemProduto); postagemProduto.classList.add("postagemProduto"); postagemProduto.innerHTML += contadorProduto+1 + " - " + nomeProduto.value + " (R$" + precoProduto.value + ")"; // valorTotal += Number(precoProduto.value); // valorDividido = valorTotal/contadorCliente; console.log(valorDividido); dividirValor(); // chama a função para dividir os valores nomeProduto.value = ""; precoProduto.value = ""; contadorProduto++; } } function dividirValor(){ valorTotal = 0; // reseta o valor total para 0 var produtosValores = document.getElementsByClassName("postagemProduto"); // pega os produtos for(var x=0; x<produtosValores.length; x++){ valorTotal += parseFloat(produtosValores[x].innerHTML.match(/R\$(\d+)/)[1]); // soma os valores } var areasValorDividido = document.getElementsByClassName("areaDoValorDividido"); // pega os clientes var numero_clientes = areasValorDividido.length; // conta os clientes if(numero_clientes){ valorDividido = valorTotal/numero_clientes; // divide o total pelo número de clientes for(var x=0; x<areasValorDividido.length; x++){ areasValorDividido[x].innerHTML = "R$"+valorDividido; } } }</code></pre><pre class="snippet-code-html lang-html prettyprint-override"><code><div id="areaClientes"> <div id="clientesContainer"> <input type="text" id="nomeCliente" placeholder="Adicionar novo cliente"> <button id="addCliente">Adicionar</button> <button id="finalizarConta">Fechar Conta</button> </div> </div> <div id="areaProdutos"> <div id="produtosContainer"> <input type="text" id="nomeProduto" placeholder="Adicionar novo produto"> <input type="text" id="precoProduto" placeholder="Adicionar preço do produto"> <button id="addProduto">Adicionar</button> </div> </div> <div id="listaClientes"> <div id="listaClientesContainer"> </div> </div> <div id="listaProdutos"> <div id="listaProdutosContainer"> </div> </div>
R

How can I make an entry always up to MYSQL PHP
Software Programming • php mysql • • rosemadder

2

0
Votes

2
Posts

0
Views

G

I need to put the forum rules on the list of entries in a way to remain fixed (SIEMPRE ARRIBA)You could have a field in the table where you handle the records associated with those categories. Let's call this field. "priority". To be able to perform ORDER BYof MySql and that when it brings the results you first place the record associated with "Welcome:: Forum Rules!" (it will have priority with value "1" acting as if it were a kind of status while everything else will have value "0")and so when users vallan enter new entries appear belowI imagine you have a field of "date" that records the moment when the user created the entry, if not, it would be good for you to have it because it is the one that we will use make it fixed "Welcome: Forum Rules!" the other entries are listed according to this field of the oldest (once again we use ORDER BY but based on the field "date")Here I leave the example query you should use to achieve your goal:$consulta= "SELECT * FROM foro ORDER BY prioridad, fecha DESC";
MqSQL. Record in one table box the sum of several cells from another table
Software Programming • mysql • • inna

2

0
Votes

2
Posts

0
Views

Total items add the pole index object_idfurther to receive objects There will be two strategies.(a) Amount requestSELECT o.id, o.object, (SELECT sum(value) FROM i WHERE i.object_id = o.id) as totalValue FROM o # WHERE o.id = ... // фильтрация если нужна (b) Joinet and groupingSELECT o.id, o.object, sum(i.value) as totalValue FROM o INNER JOIN i ON (i.object_id = o.id) GROUP BY o.id, o.object # WHERE o.id = ... If you choose data for one record, perhaps the first option would be preferable. If it's for everyone, it's the second. Although speed results can be compared, for this volume of tables, there will be no difference.
Z

How to automatically add two columns of two different tables and perform insert in another table in MySQL?
Software Programming • mysql mariadb phpmyadmin • • zymir

2

0
Votes

2
Posts

0
Views

What is the purpose if the records of the tables do not have a relationship between themselves?To relate the 2 tables, they have to have a common key field for you to declare in INNER JOIN another any JOIN. In this way, you will be able to make the sum something like:SELECT T1.COLUNA1_T1 + T2.COLUNA1_T2 as COLUNA1_T3 FROM T1 INNER JOIN T1 ON T1.CHAVE = T2.CHAVE
F

Migration of table from MySQL to Oracle using GoldenGate
SQL, Database Testing • mysql oracle mysql 5.7 orac languagele 12c langu goldengate • • fbio

2

0
Votes

2
Posts

0
Views

G

From my experience with GoldenGate, it's better to do initial loads with database native tools. In this case, you would use: SELECT * FROM TABLENAME INTO OUTFILE 'filename'; https://dev.mysql.com/doc/refman/5.7/en/select-into.html Then load into Oracle with SQL*Loader. Example control file for SQL Loader: $ cat example1.ctl load data infile '/home/ramesh/employee.txt' into table employee fields terminated by "," ( id, name, dept, salary ) Example taken from: https://www.thegeekstuff.com/2012/06/oracle-sqlldr/ If you cannot stop data changes to perform the load, you need to: Start your extract Export the data Load the data start your replicat with HANDLECOLLISIONS enabled After your replicat has caught up, remove HANDLECOLLISIONS. For some good Tutorials, I've used https://gavinsoorma.com/category/goldengate/ Also the Oracle TechNet forums were responsive for GoldenGate questions - even for some really obscure scenarios.
O

How do we combine the results of data requests in one table?
Software Programming • sql postgresql • • Oba22

2

0
Votes

2
Posts

0
Views

select "Law", law_balance, "Phys", physic_balance from (select row_number() over (order by name) as rn1, name AS "Юр. лицо", balance AS law_balance FROM client WHERE type = 'Юр') l full join (select row_number() over (order by name) as rn2, SELECT name AS "Физ. лицо", balance AS physic_balance FROM client WHERE type = 'Физ') p on rn1=rn2
A

Is making joins between different table spaces slower?
SQL, Database Testing • mysql postgresql • • authera

2

0
Votes

2
Posts

0
Views

Z

This is only for Postgres: If the tablespaces reside all on the same harddisk, then there is no performance difference at all. If the tablespaces are created on different harddisks then yes, this can make a difference. In that case the necessary I/O is spread over multiple disks, thus improving the overall throughput (assuming all harddisks have the same performance).
S

how to put mysql data in a table
Software Programming • php mysql • • Saumya

2

0
Votes

2
Posts

0
Views

D

the information you provide is not the right one, so I will show you a code that performs taking from the documentation of php I know if you use PDO or mysli.<?php include_once "conexion.php"; try { $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->beginTransaction(); $pdo->exec("insert into users (name, last_name, email, password) values ('Joe', 'Bloggs', 'blog@correo.com','123445')"); echo "Datos agregados! :)"; $pdo->commit(); } catch (Exception $e) { $pdo->rollBack(); echo "Fallo: " . $e->getMessage(); } ?> Of course once the connection has been made, you include it in your project. In this case by calling this php file, I run the script. My Database Provider, in my case is Postgresql. using You can look for more examples. in the documentation of phpI hope it helps.
B

How to count equal records in a single column and get that same number?
Software Programming • php mysql • • Burma

2

0
Votes

2
Posts

0
Views

E

With php5.5 you can combine the function array_column() that extracts the indice values and returns them as a new array, with use the function array_count_values() that tells how many equal values exist in the array, the keys are the database values and the values are the number of occurrences.$arr = [['str' => 'abc'], ['str' => 2015], ['str' => 2015], ['str' => 'doge'], ['str' => 'wow'], ['str' => 'wow']]; $itens = array_count_values(array_column($arr, 'str')); echo "<pre>"; print_r($itens); Return:Array ( [abc] => 1 [2015] => 2 [doge] => 1 [wow] => 2 )

MYSQL request for data transfer from one table to another

Suggested Topics

How do I know if an index has been successfully created in MySQL? SQL, Database Testing • mysql index • • zymir

Data transfer mySQL Software Programming • mysql • • jonetta

Sql request for one table Software Programming • sql postgresql • • morde

Update column from Base64 to string (natively in SQL) SQL, Database Testing • mysql mariadb • • Trenton

Impact of replication compression & encryption on performance, traffic? SQL, Database Testing • mysql performance encryption replication compression • • Kadir

Count grouping per week Software Programming • mysql sql selec languaget • • jeanid

How to transfer data from one function to another? Software Programming • javascript html functions variable • • meriah

How can I make an entry always up to MYSQL PHP Software Programming • php mysql • • rosemadder

MqSQL. Record in one table box the sum of several cells from another table Software Programming • mysql • • inna

How to automatically add two columns of two different tables and perform insert in another table in MySQL? Software Programming • mysql mariadb phpmyadmin • • zymir

Migration of table from MySQL to Oracle using GoldenGate SQL, Database Testing • mysql oracle mysql 5.7 orac languagele 12c langu goldengate • • fbio

How do we combine the results of data requests in one table? Software Programming • sql postgresql • • Oba22

Is making joins between different table spaces slower? SQL, Database Testing • mysql postgresql • • authera

how to put mysql data in a table Software Programming • php mysql • • Saumya

How to count equal records in a single column and get that same number? Software Programming • php mysql • • Burma

How do I know if an index has been successfully created in MySQL?
SQL, Database Testing • mysql index • • zymir

Data transfer mySQL
Software Programming • mysql • • jonetta

Sql request for one table
Software Programming • sql postgresql • • morde

Update column from Base64 to string (natively in SQL)
SQL, Database Testing • mysql mariadb • • Trenton

Impact of replication compression & encryption on performance, traffic?
SQL, Database Testing • mysql performance encryption replication compression • • Kadir

Count grouping per week
Software Programming • mysql sql selec languaget • • jeanid

How to transfer data from one function to another?
Software Programming • javascript html functions variable • • meriah

How can I make an entry always up to MYSQL PHP
Software Programming • php mysql • • rosemadder

MqSQL. Record in one table box the sum of several cells from another table
Software Programming • mysql • • inna

How to automatically add two columns of two different tables and perform insert in another table in MySQL?
Software Programming • mysql mariadb phpmyadmin • • zymir

Migration of table from MySQL to Oracle using GoldenGate
SQL, Database Testing • mysql oracle mysql 5.7 orac languagele 12c langu goldengate • • fbio

How do we combine the results of data requests in one table?
Software Programming • sql postgresql • • Oba22

Is making joins between different table spaces slower?
SQL, Database Testing • mysql postgresql • • authera

how to put mysql data in a table
Software Programming • php mysql • • Saumya

How to count equal records in a single column and get that same number?
Software Programming • php mysql • • Burma