Evo dvije netestirane perverzije. :)
Code:
INSERT IGNORE INTO tabelaB
SELECT a1.opis1, a2.opis2, a3.opis3, a4.opis4, a5.opis5, a6.opis6, a7.opis7
FROM tabelaA a1, tabelaA a2, tabelaA a3, tabelaA a4, tabelaA a5, tabelaA a6, tabelaA a7;
Code:
INSERT INTO tabelaB
SELECT opis1
FROM tabelaA
UNION
SELECT opis2
FROM tabelaB
UNION
SELECT opis3
FROM tabelaA
UNION
SELECT opis4
FROM tabelaA
UNION
SELECT opis5
FROM tabelaA
UNION
SELECT opis6
FROM tabelaA
UNION
SELECT opis7
FROM tabelaA;
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA