JamesBong Posted December 6, 2018 Report Share Posted December 6, 2018 Salut Am o problema si nu reusesc sa ii dau de cap. Am urmatoarele tabele dintr-o baza de date : Iar ce am de facut este : Write an SQL statement to change any employee’s title. Assume the employee has just phoned in with his/her last name. Varianta pe care am incercat-o cu un subquerry imi zice ca are syntax error. Update 'titles' set title = 'Senior Engineer' Where titles.emp_no = (select employees.emp_no from employees Where employees.last_name = 'Kalloufi'); Ma poate ajuta cineva ? Multumesc. Quote Link to comment Share on other sites More sharing options...
Wav3 Posted December 6, 2018 Report Share Posted December 6, 2018 Pai si ce zice in eroare? 1 Quote Link to comment Share on other sites More sharing options...
JamesBong Posted December 6, 2018 Author Report Share Posted December 6, 2018 Quote Link to comment Share on other sites More sharing options...
tjt Posted December 6, 2018 Report Share Posted December 6, 2018 23 minutes ago, JamesBong said: Update 'titles' De ce pui ' ' la numele tabelului ? 2 1 Quote Link to comment Share on other sites More sharing options...
JamesBong Posted December 6, 2018 Author Report Share Posted December 6, 2018 1 minute ago, tjt said: De ce pui ' ' la numele tabelului ? Nu imi vine sa cred ca asta era problema. Iti foarte multumesc. Quote Link to comment Share on other sites More sharing options...
.zife Posted December 7, 2018 Report Share Posted December 7, 2018 (edited) Cand incepeti cu" termini cu " cand incepeti cu ' terminati tot cu ' Edit// cu alte cuvinte inchideti in pula mea parantezele corespunzator, tu vezi ce ai acolo? Edited December 7, 2018 by .zife 6 Quote Link to comment Share on other sites More sharing options...
.zife Posted December 7, 2018 Report Share Posted December 7, 2018 Esti cretin, cum poti sa publici info? 2 Quote Link to comment Share on other sites More sharing options...
Wav3 Posted December 7, 2018 Report Share Posted December 7, 2018 Cu ce te droghezi, ma? Cum naiba n-ai luat ban pana acum? ON: @JamesBong De-aia te-am intrebat ce eroare iti da. Invata sa le "citesti" pentru ca te ajuta. Iti spunea destul de clar unde e problema. Numele de tabel il poti pune doar intre tilde (`), nu apostrof sau ghilimea. (sau fara nimic, evident) 3 Quote Link to comment Share on other sites More sharing options...
.zife Posted December 7, 2018 Report Share Posted December 7, 2018 (edited) I-a face un research, vezi unde lucreaza astia Edit: daca nu ai citit legislatia, ramai acolo la Altex, si numai consuma Edited December 7, 2018 by .zife 1 Quote Link to comment Share on other sites More sharing options...
QuoVadis Posted December 7, 2018 Report Share Posted December 7, 2018 Acest topic se poate rezuma la faptul ca @.zife e mai prost decat prevede legea 3 1 Quote Link to comment Share on other sites More sharing options...
.zife Posted December 7, 2018 Report Share Posted December 7, 2018 (edited) Pai cum cacat, hai sa publicam toti date personale, nu poti posta doar eroarea? Hai ca fac eu niste injectii de nici weleik info n.au vazut si le public aici, e ok? Edited December 7, 2018 by .zife 1 Quote Link to comment Share on other sites More sharing options...
Raul Posted December 7, 2018 Report Share Posted December 7, 2018 (edited) Acea bucata de "dummy data" are o inteligenta mai mare ca a ta. Edited December 7, 2018 by Raul 1 Quote Link to comment Share on other sites More sharing options...
QuoVadis Posted December 7, 2018 Report Share Posted December 7, 2018 1 hour ago, .zife said: Pai cum cacat, hai sa publicam toti date personale, nu poti posta doar eroarea? Hai ca fac eu niste injectii de nici weleik info n.au vazut si le public aici, e ok? Mai bea lapte sa te "prinzi" ca sunt date fictive si probabil e tema de casa a omului. Indiciul consta in: Iar ce am de facut este : Write an SQL statement to change any employee’s title. Assume the employee has just phoned in with his/her last name. 1 Quote Link to comment Share on other sites More sharing options...