مطالب مرتبط با «delete query in sql» در back soft | نویسنده: استخدام کار
mysql remove dupe from query e select last insert
Vote count: 0 qith a query I nedd to join 2 table and from result to remve dupe records but I need to show last insert (is.pr). I try this, but not work : $query="SELECT is.cf, is.ps, is.pr, is.pn, dati.ma, dati_uni.age, dati_uni.code FROM (SELECT * FROM is ORDER BY is.pr DESC) as temp INNER JOIN dati_uni ON (dati_uni.code=is.ps) GROUP BY is.cf"; thx in advance. asked 14 secs agoGaetano Sale Let's block ads! بخوانید...
ادامه مطلبDelete query in Alasql
Vote count: 0 i am new to Alasql. In my nodejs code i have written below piece of code for delete an item. but it is not getting deleted. Any help? sqldb.exec('DELETE FROM Cores WHERE [node-id] ='%s'', Id); sqldb.exec('DELETE FROM Cores WHERE [node-id] = ?', Id); sqldb.exec('DELETE FROM Cores WHERE [node-id] ='+ Id); i tried all the above combinations it is not working asked 35 secs agoKiran Let's block ads! بخوانید...
ادامه مطلب
