En cours

Query for MySQL

change the query (MYSQL)

select 'de',count(pid), status from x_dict_de group by status

union

select 'fr',count(pid), status from x_dict_fr group by status;

which returns 6 rows to 2 rows resultset:

(status can have 3 values, nok, ok, null))

'de', 2, 3, 1

'fr', 1, 3, 3

Compétences : MySQL

en voir plus : n query, null, mysql query, group de, query query, mysql status, count mysql, nok, select select mysql, mysql select, joggrun, pid mysql, query mysql, php mysql update multiple rows, mysql count, mysql fetch last rows, mysql update multiple rows, mysql loop table rows, mysql update multiple rows using array, php mysql update selected rows

Concernant l'employeur :
( 77 commentaires ) Brussels, Belgium

Nº du projet : #866314

14 freelance font une offre moyenne de $30 pour ce travail

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(63 Commentaires)
6.8
php4world

Hello! Please check your PMB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(25 Commentaires)
5.8
jamalazza

ready to start

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
4.8
majid4466

Explain the problem properly to get it fixed quickly. You need to specify (1) structure of tables involved (2) the desired resultset. Instead of explaining table structures if you upload a dump of the tables it would b Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
4.4
ta3k

I'm ready to start now. Regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(19 Commentaires)
4.4
servicebenq

Hi Ready to start. Expert on TSQL/PLSQL Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(13 Commentaires)
4.3
freelancerbuzzo

Ready to start right now.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(10 Commentaires)
4.3
kommandant

Check your PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(8 Commentaires)
3.8
kamosion

can start immediatelly.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(1 Évaluation)
3.2
TheArseneLupin

Hi, I can do that for just 15$. You only pay when this is done. If interested contact me.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(3 Commentaires)
2.0
salseeg

pretty simple

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
zulian

I am ready to help you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
kamrultareq

I can do it very easily.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
SayedMulkhan

Dear Sir, I am strong at ANSI-SQL92 and MySQL. Thank you very much. Best Regards, Sayed Mulkhan F

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0