Predmet:Re: MYSQupit za polja u koloni imaju imena drugih tabli

---

nece, a jeli mozes reci zasto ovo nece

radim localno
prvo upisem ovo:

select * from proba.tabla

to radi. Onda upisem ovo:

set @sql_text := 'select * from proba.tabla'
prepare stmt from @sql_text
execute stmt

to nece, javi gresku:

SQL upit: Dokumentacija
SET @sql_text := 'select * from proba.tabla'prepare stmt FROM @sql_text EXECUTE stmt
MySQL je poručio: Dokumentacija
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'prepare stmt from @sql_text
execute stmt' at line 2

onda stavim ovako, tocka zarez iza svake naredbe:
set @sql_text := 'select * from proba.tabla';
prepare stmt from @sql_text;
execute stmt;

dobijem ovo:
Vaš SQL upit uspješno je izvršen
SQL upit:
SET @sql_text := 'select * from proba.tabla';# MySQL je vratio prazan komplet rezultata (npr. nula redova).
prepare stmt FROM @sql_text ;# MySQL je vratio prazan komplet rezultata (npr. nula redova).
EXECUTE stmt;# Redaka: 5

ali nema ispisa rezultata?

---