We need a Sql query to fill a column of a table of a mySql data base.
See the attached Word archive which contains the required task.
The data base is attached as well.
33 freelancers are bidding on average $19 for this job
Hi! I create your query: SET @cnt = 0; UPDATE arda a1 JOIN (SELECT id_art, @cnt:=@cnt+1 AS cntn FROM arda ORDER BY ranking DESC) a2 ON a1.id_art=a2.id_art SET `position`=[url removed, login to view]
Hi team, I am having 4 year of experience in database technology.I worked on SQL server 2005,2008,2012 and 2014,My Sql workbench,php mysql.I would like to help [url removed, login to view] can contact me .