Unable to detect duplicate using mysql and rename the string -

-

i have schema account follows :

accountid | filename

if filename repeats want store as:

filename.txt filename1.txt filename2.txt filename3.txt

i doing checking number of duplicates running query check number of duplicates , renaming filename in backed , running insert query.

can whole procedure can done in 1 query ?

you can in single query:

select t.id, t.account, z.dupcount filename join    (select account, count (*) dupcount     filename      group account     having count(*) > 1) z    on z.account = t.account order dupcount desc

Comments

Post a Comment

Popular posts from this blog

PHP while loop dynamic rowspan -

-
Image
consider table example using these table wanted print table these adding rowspan item id 1002. here php code $temp_val = ''; $counter = 1; $sql_sel = mysqli_query($con,"select * item_table"); while($res_sel = mysqli_fetch_array($sql_sel)){ if($temp_val == $res_sel['item_id']){ $counter++; echo "<tr></tr>"; } else{ echo "<tr><td rowspan='".$counter."'>".$res_sel['item_id']."</td></tr>"; } $temp_val = $res_sel['item_id']; } echo "</table>"; it's not correct, it's adding rowspan item id 1003 you should switch code inside else , if statement
Read more

android - How to read a column value in parse.com without accessing an object or a pointer -

-
by using code, not able 'name' unless use objectid = xj34weo . suggest way, if not, @ least using pointer. //parse query initialization final parsequery<parseobject> query = parsequery.getquery("myusers"); //to check row has "number"="1234" query.whereequalto("number", "1234"); query.findinbackground(new findcallback<parseobject>() { public void done(list<parseobject> employees, parseexception e) { if (e == null) { try { //xj34we0 objectid query.get("xj34weo").get("name") + ""); } catch (parseexception pe) {} } } }); are trying employee object number? you have list<parseobject> , use it. query.findinbackground(new findcallback<parseobject>() { public void done(list<parseobject> employees, parseexception e) { if (e == null && employ...
Read more

timer - Java TimerTask cancel -

-
i have following problem. every 2 seconds programm go inside if statement. inside if statement want have timer give me message after 15 seconds. timer should run delay of 1 second. while i'm "waiting" timer, if statement executed 7 times. problem is, have 7 same timertask @ same time running. how can solve problem? if (response == true) { final timer timer = new timer(); final int keepalivetimeout = 15000; //15 seconds timer.schedule(new timertask() { @override public void run() { if (response) { response = false; log.i(tag, "********response******"); timeoutcounter = 0; } else if (timeoutcounter > keepalivetimeout) { log.i(tag, "********timer timeout******"); } log.i(tag, "********timer******"); timeoutcounter = timeoutcounter + 1000; } }, 0, 1000); } from java api : public void schedule(timertask task, long delay, ...
Read more