I am not able to solve a query, someone help?

|
josemariahidalgo_es 2022-07-07 22:48:07
hi group!
I am not able to solve a query, someone help?
josemariahidalgo_es 2022-07-07 22:55:05
I need to join these 3 queries into one
josemariahidalgo_es 2022-07-07 22:55:24
SELECT fk_facture, tva_tx, SUM(total_tva) AS iva4 FROM llx_facturedet WHERE tva_tx = ‘4.000’ AND fk_facture=267;

SELECT fk_facture, tva_tx, SUM(total_tva) AS iva10 FROM llx_facturedet WHERE tva_tx = ‘10.000’ AND fk_facture=267;

SELECT fk_facture, tva_tx, SUM(total_tva) AS iva21 FROM llx_facturedet WHERE tva_tx = ‘21.000’ AND fk_facture=267;

josemariahidalgo_es 2022-07-07 22:55:39
To obtain something similar to this…
josemariahidalgo_es 2022-07-07 22:56:39
mysql_en-22644.jpg

rodrigo_tc7 2022-07-07 23:02:04
Use that as subselects in select. Clause
rodrigo_tc7 2022-07-07 23:03:43
Select fk_facture, tva_tx, (select sum…) as iva4, (select sum…) as iva10…
Where…
Douwe 2022-07-08 02:16:44
π‘»π’‰π’‚π’π’Œ π’šπ’π’– 𝒔𝒐 π’Žπ’–π’„π’‰ 𝒇𝒐𝒓 𝒕𝒉𝒆 𝒋𝒐𝒃 π’˜π’†π’π’ 𝒅𝒐𝒏𝒆 π’šπ’π’– 𝒂𝒓𝒆 π’”π’Šπ’Žπ’‘π’π’š 𝒕𝒉𝒆 π’ˆπ’“π’†π’‚π’•π’†π’”π’• 𝒐𝒇 𝒂𝒍𝒍 π’•π’Šπ’Žπ’†,π’Š π’‚π’Ž π’“π’†π’‚π’π’π’š π’‰π’‚π’‘π’‘π’š π’Žπ’†π’†π’•π’Šπ’π’ˆ π’šπ’π’–,π’˜π’π’˜ 𝒋𝒖𝒔𝒕 𝒔𝒆𝒄𝒖𝒓𝒆𝒅 $20,000 π’Šπ’ 𝒂 π’˜π’†π’†π’Œ π’Šπ’•π’” 𝒃𝒆𝒆𝒏 𝒂 π’ˆπ’“π’†π’‚π’• 𝒑𝒍𝒆𝒂𝒔𝒖𝒓𝒆 π’Œπ’π’π’˜π’Šπ’π’ˆ π’šπ’π’– @GeorgeMicheal_fx

πŸ“©πŸ“©πŸ“©

https://t.me/ 6POjgCN5VAJkZTA0
https://t.me/ 6POjgCN5VAJkZTA0

BEST πŸ’― TRADING πŸ“ŠPLATFORM πŸ“ˆTelegram
entrepreneur

πŸ“ŠDaily Live Trade

– 100% payout guaranteed

– 0% Risk Sessions

– minimum equity $200

– Forex Trading Expert

DM TO GET STARTED

Badshahat 2022-07-08 05:19:05
Which is the best platform to learn the mysql
suricruise1 2022-07-08 06:08:26
Badshahat 2022-07-08 05:19:05
Which is the best platform to learn the mysql

YouTube

ckulthe 2022-07-08 07:32:59
Good evening! , i need help in this issue – mysql> alter table lastblock DISCARD TABLESPACE;
Query OK, 0 rows affected (0.26 sec)

mysql> alter table lastblock import TABLESPACE;
ERROR 1808 (HY000): Schema mismatch (Clustered index validation failed. Because the .cfg file is missing, table definition of the IBD file could be different. Or the data file itself is already corrupted.)

ckulthe 2022-07-08 07:33:12
while restoring i am getting this error
DBA 2022-07-08 07:43:17
ckulthe 2022-07-08 07:32:59
Good evening! , i need help in this issue – mysql> alter table lastblock DISCARD TABLESPACE;
Query OK, 0 rows affected (0.26 sec)

mysql> alter table lastblock import TABLESPACE;
ERROR 1808 (HY000): Schema mismatch (Clustered index validation failed. Because the .cfg file is missing, table definition of the IBD file could be different. Or the data file itself is already corrupted.)

U have to prepare the Xtrabackup before restoration….then it will create .cfg file…..then copy both .ibd and .cfg files to the original location and then import the tablespace

ckulthe 2022-07-08 08:23:18
DBA 2022-07-08 07:43:17
U have to prepare the Xtrabackup before restoration….then it will create .cfg file…..then copy both .ibd and .cfg files to the original location and then import the tablespace

i use commands mostly from shell

ckulthe 2022-07-08 08:23:24
no tool
ckulthe 2022-07-08 08:23:59
and i dont have any change to take backup as it was disaster and mysql was down
ckulthe 2022-07-08 08:24:11
having only .idb files with me
shreyaa Singh 2022-07-08 08:30:25
Somebody hel pls
shreyaa Singh 2022-07-08 08:30:33
Help pls*
shreyaa Singh 2022-07-08 08:31:20
Pls
Sandip Londhe 2022-07-08 18:53:06
Can we export to CVS from the MySQL database
Sandip Londhe 2022-07-08 18:53:17
If yes how?
suricruise1 2022-07-08 18:53:53
Sandip Londhe 2022-07-08 18:53:06
Can we export to CVS from the MySQL database

Csc means xl

suricruise1 2022-07-08 18:54:11
Cvs means xl
Sandip Londhe 2022-07-08 18:54:20
Comma seprated values?
suricruise1 2022-07-08 18:54:36
Yes
suricruise1 2022-07-08 18:54:49
Import and export
Swapnil 2022-07-08 19:03:32
suricruise1 2022-07-08 18:54:11
Cvs means xl

Both are different file format

Sandip Londhe 2022-07-08 19:06:24
Swapnil 2022-07-08 19:03:32
Both are different file format

Swapnil can we export?

suricruise1 2022-07-08 19:14:35
Swapnil 2022-07-08 19:03:32
Both are different file format

mysql_en-22686.jpg
Csv means xl sheet?

Swapnil 2022-07-08 19:32:02
suricruise1 2022-07-08 19:14:35
Csv means xl sheet?

https://toggl.com/track/difference-between-csv-xls/#:~:text=The difference between CSV and,including both content and formatting.

Difference Between CSV and XLSToggl
What is the difference between a csv and excel (xls, xlsx) file formats?
Swapnil 2022-07-08 19:32:24
suricruise1 2022-07-08 19:14:35
Csv means xl sheet?

Csv can be opened in excel file but both file format are not same

suricruise1 2022-07-08 19:40:01
Swapnil 2022-07-08 19:32:24
Csv can be opened in excel file but both file format are not same

Okay bro

suricruise1 2022-07-08 19:40:22
Sandip Londhe 2022-07-08 18:53:06
Can we export to CVS from the MySQL database

Are you working bro

suricruise1 2022-07-08 19:40:46
Or learning my SQL bro
|