502668 Mysql query - Virtuemart tables to CSV


[url removed, login to view] complete a mysql query on Virtuemart tables to produce desired csv file output.

2. The mysql query produced must run in Navicat 8 mysql for windows.


Job has 6 Tasks - see attached file - [url removed, login to view], where the attachment contains:

- required alias field names and desired csv format for query output

- VM database equivalent fields & tables (discovered so far)

- the 6 task details, listed under the field the task applies to.

Also need query to be commented so I can add "custom data" in right places & add extra fields easily should they ever be needed. Comments must take account of any joins needed (i.e. how to add joins).

Skills needed:-

solid mysql query creation

ability to concatenate, x-ref, append, identify (a few) fields in DB, & produce joins where data resides in different tables.

Provide coherent comments on code

I can provide DB login details to a Virtuemart example if this needed.

Attachment 2 - [url removed, login to view] - my attempt at part of the query - if it's of any use!

Priority: Fairly Urgent!

Beceriler: Her şey Kabul, MySQL, Virtuemart

Daha fazlasını gör: can run query virtuemart, navicat mysql virtuemart, vm where, objective c mysql, n query, urgent mysql, query creation, mysql query, db query, data query, Concatenate, mysql add fields, mysql comments, mysql append data, mysql append, query query, csv file code, mysql urgent, virtuemart code output, task virtuemart, must format csv, objective login, mysql attachment, file csv virtuemart, virtuemart custom code

İşveren Hakkında:
( 4 değerlendirme ) Chorley, United Kingdom

Proje NO: #2248590



Details in PM.

%selectedBids___i_period_sub_7% gün içinde 75%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(53 Değerlendirme)