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.
32 Freelancer bieten im Durchschnitt $19 für diesen 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 .
I already write a sample qurey for your work in 20 miniutes. I'm expert at T-SQL and SQL. It's easy to drive a native code in MySQL langue for your case.