Prikazi cijelu temu 08.06.2020 11:46
Avko Van mreze
Administrator
Registrovan od:28.05.2014
Lokacija:zagreb


Predmet:Problemi kod prikazivanja kodova
Ovo je kod nema sintaksne oznake:

PreuzmiIzvorni kôd (Text):
  1. SELECT  r.name
  2. ,rv.Date
  3. ,rv.id_department
  4. ,CONCAT(rv.id_department,rv.Date) as kljuc
  5. FROM tbl_schedule rv
  6. INNER JOIN tbl_employees  as r ON rv.id_employees=r.id_employees
  7. WHERE  CONCAT(rv.id_department,rv.Date)
  8. IN (SELECT
  9. CONCAT(rv.id_department,rv.Date) as kljuc
  10. FROM tbl_schedule as rv WHERE id_employees=1001
  11. )
  12. AND
  13. rv.id_employees<>1001

a ovo je kod
PreuzmiIzvorni kôd (MySQL):
  1. SELECT  r.name
  2. ,rv.Date
  3. ,rv.id_department
  4. ,CONCAT(rv.id_department,rv.Date) as kljuc
  5. FROM tbl_schedule rv
  6. INNER JOIN tbl_employees  as r ON rv.id_employees=r.id_employees
  7. WHERE  CONCAT(rv.id_department,rv.Date)
  9. CONCAT(rv.id_department,rv.Date) as kljuc
  10. FROM tbl_schedule as rv WHERE id_employees=1001
  11. )
  13. rv.id_employees<>1001

Dali vi vidite isto to dvoje ili ovaj mysql ima neke dodatke i ne čitljiv je?

ja ovaj dolje vidim ovako:

zivot je moja domovina.
Ovaj post je ureden 1 puta. Posljednja izmjena 08.06.2020 11:47 od strane Avko.