Why this query didn't work
update gaji set jumlah_gaji='10' where jumlah_gaji = (select max(jumlah_gaji) from gaji);
Asked
Active
Viewed 22 times
0
-
thx for the dupe lookup peanutbutter – Drew Dec 03 '16 at 05:17
-
I can't understand that – deta utama Dec 03 '16 at 05:37
-
Please edit your code in as text. I shouldn't have to type that in myself. – Drew Dec 03 '16 at 05:45
-
n MySQL, you can't modify the same table which you use in the SELECT part. Look in to the below link.. http://dev.mysql.com/doc/refman/5.6/en/update.html For the alternative approach go to the below link: http://stackoverflow.com/questions/45494/mysql-error-1093-cant-specify-target-table-for-update-in-from-clause – khaled4vokalz Dec 03 '16 at 05:54
-
http://hastebin.com/miyehidira.rb – Drew Dec 03 '16 at 05:58
-
Woo, thank you very much Drew – deta utama Dec 03 '16 at 06:04
-
no problem boss. There are many ways to do it. Over and out. – Drew Dec 03 '16 at 06:05