Why do you need so much data in one table?

İf we want to import with tsv file, it is okey

It has been working for 3 days and added 100 million lines.

Make tsv

You mean csv convert to tsv?

You sad it’s fast

Why do you need so much data in one table?

It is not normal

I’m building an automobile spare parts site, the products are much bigger than they are. There are about 8 million products

Show first 10 lines of your CSV

Use text please

Anime. this chat is about anime !

Are you one

I am

I am THE ONE!

Wow. If you have millions of rows. Try GCP or AWS. I don’t think mySQL is capable for this.

For several millions of rows MySQL is definitely ok. For billions prob. no.

Thanks Ilia.

I’ve read that mysql has a 2^64 rows limit with “big table” option enabled.

And about use cases with some TB and 5.000.000.000 rows in some of the more than 200.000 tables that they had

https://www.chegg.com/homework-help/questions-and-answers/write-query-return-sales-details-customers-products-query-return-customers-even-customers–q45662394

Does someone know what is wrong with my code for this question

SELECT IFNULL(customer_name, “N/A”) customer_name, IFNULL(product_name, “N/A”) product_name, IFNULL(quantity, 0) quantity
FROM ((customer LEFT OUTER JOIN invoice ON customer.id = invoice.customer_id) LEFT OUTER JOIN invoice_item ON invoice_item.invoice_id = invoice.id) LEFT OUTER JOIN product ON invoice_item.product_id = product.id
ORDER BY customer.id, product.id;

SELECT IFNULL(customer_name, “N/A”) customer_name, IFNULL(product_name, “N/A”) product_name, IFNULL(quantity, 0) quantity
FROM customer
LEFT OUTER JOIN invoice ON customer.id = invoice.customer_id
LEFT OUTER JOIN invoice_item ON invoice_item.invoice_id = invoice.id LEFT OUTER JOIN product ON invoice_item.product_id = product.id
ORDER BY customer.id, product.id;

Remove the brackets from FROM clause and try

Anyone program could not open this file, ı am working so ı am sorry later message

head

Head !?

The GNU/Linux command to show 10 top lines of CSV file

How to concatenate the two strings in ireport

Select concat (Firstname,Lastname) as Name from students;

I use this query ,it doesn’t work

Jaspersoft ireport 5.6.0

This should work

https://www.w3schools.com/sql/func_mysql_concat.asp

Maybe the space between concat and the first (
?