What is Order ID in your query?

|
Gopal 2021-06-16 20:07:34
Hello everyone i want to start SQL learning from basic will anyone help me on this please
Gopal 2021-06-16 20:21:27
Thanks so much sir
2021-06-16 20:22:48
Sir what u do
2021-06-16 20:24:05
Oh nice sir
Gopal 2021-06-16 20:25:06
Great 👍
2021-06-16 20:25:20
Ok sir , if I want to become software engineer what should I focus on
MasterZiv 2021-06-16 20:45:31
Karthick 2021-06-16 18:02:30
Poor clients requirement so

10 million rows a day?

Karthick 2021-06-16 20:57:10
MasterZiv 2021-06-16 20:45:31
10 million rows a day?

Yes

MasterZiv 2021-06-16 22:14:54
Karthick 2021-06-16 20:57:10
Yes

you’re crazy!

svart 2021-06-16 23:34:57
Karthick 2021-06-16 17:21:21
Yes but daily 9 hrs it’s taking time

Did you considered 1)using load data instead of insert statement. It is way faster; 2) change engine to rocksdb if possible 3) partition table and load data based on partitions?

Deb_575 2021-06-17 01:14:54
svart 2021-06-16 23:34:57
Did you considered 1)using load data instead of insert statement. It is way faster; 2) change engine to rocksdb if possible 3) partition table and load data based on partitions?

I am curious about this rocksdb
Where to get the binaries and the documentation?
What kind of workload is recommended for rocksdb and can it handle 1tb databases
please advice

Karthick 2021-06-17 05:58:00
MasterZiv 2021-06-16 22:14:54
you’re crazy!

You too

MasterZiv 2021-06-17 07:41:59
Deb_575 2021-06-17 01:14:54
I am curious about this rocksdb
Where to get the binaries and the documentation?
What kind of workload is recommended for rocksdb and can it handle 1tb databases
please advice

I myself here of this rocks DB for the first time in life.

svart 2021-06-17 09:37:21
@Deb_575 , depends on distribution/version of mysql you use you can find a package in same repo. before trying it I’d suggest you to read about it limitations. i use it for 2 purposes: 1) compression (at least x2 times on a tables with a small or few strings) and more if there are many large strings; 2) write mainly workloads 3) all types of workloads when a server has way less ram than you need and there is no “select” queries with a lot of join (this is important because I found that rocksdb performs very badly when it comes to join a lot of large tables).
Deb_575 2021-06-17 10:24:11
svart 2021-06-17 09:37:21
@Deb_575 , depends on distribution/version of mysql you use you can find a package in same repo. before trying it I’d suggest you to read about it limitations. i use it for 2 purposes: 1) compression (at least x2 times on a tables with a small or few strings) and more if there are many large strings; 2) write mainly workloads 3) all types of workloads when a server has way less ram than you need and there is no “select” queries with a lot of join (this is important because I found that rocksdb performs very badly when it comes to join a lot of large tables).

Thanks
I installed percona distribution of mysql and the rocksdb engine came as a plugin along with the binaries.
Installed it on my local machine now an gonna run some test and see if I can recommend this for my office project

gavrisalive 2021-06-17 12:16:45
Hi there. Give me a prompt, please

In Table 1 data stored as:

id account
===========
1 KZ
1 KZZ
2 US
2 USS
3 LE

Table_1.id has relation with Table_2.client_id. Need to show data like:

ID ACCOUNT
1 KZ KZZ
2 US USS
3 LE

where Table_1.client_id = Table_2.id

gavrisalive 2021-06-17 12:17:41
I trying this query, but he gives just one value from account. I need all values from account

SELECT Table_2.client_id, Table_1.account AS account
FROM Table_2
LEFT JOIN (Table_1) ON
(Table_2.client_id = Table_1.client_id)
WHERE Table_1.account IS NOT NULL
GROUP BY Table_1.account

Vinoth M 2021-06-17 15:11:25
MasterZiv 2021-03-28 06:37:44
This should work

Thanks for your help

MasterZiv 2021-06-17 17:21:23
Show us the query and the diagnostics (error)
MasterZiv 2021-06-17 17:22:23
@auleev , everyone here is from India
MasterZiv 2021-06-17 17:31:04
ORDER is a keyword in SQL, you can’t name a column like this. This is what the error is about
MasterZiv 2021-06-17 17:31:44
What is Order ID in your query?
rodrigo_tc7 2021-06-17 18:14:17
gavrisalive 2021-06-17 12:17:41
I trying this query, but he gives just one value from account. I need all values from account

SELECT Table_2.client_id, Table_1.account AS account
FROM Table_2
LEFT JOIN (Table_1) ON
(Table_2.client_id = Table_1.client_id)
WHERE Table_1.account IS NOT NULL
GROUP BY Table_1.account

Use group concat

rodrigo_tc7 2021-06-17 23:36:17
Use brackets
rodrigo_tc7 2021-06-17 23:37:06
You have an space, and you can’t
You are al ready using brackets in the Last select quey
MasterZiv 2021-06-18 07:55:34
Column name can’t contain a space in it, it would be considered by SQL parser as two distinct identifiers.
MasterZiv 2021-06-18 07:56:38
Then ask the person who wrote it.
MasterZiv 2021-06-18 08:02:04
Check the name of this field, probably it has underscore in the middle, not a space.

If it has space, consider renaming, or, if you have to use names with spaces, use quoted identifiers, in MySQL this is done by enclosing the indentifier into backticks, ` .
(Not braces, like you’ve been told)

rodrigo_tc7 2021-06-18 08:30:22
MasterZiv 2021-06-18 08:02:04
Check the name of this field, probably it has underscore in the middle, not a space.

If it has space, consider renaming, or, if you have to use names with spaces, use quoted identifiers, in MySQL this is done by enclosing the indentifier into backticks, ` .
(Not braces, like you’ve been told)

Sorry, mixing 😭

2021-06-18 16:32:54
mysql_en-10723.jpg

2021-06-18 16:33:10
Q4
2021-06-18 16:33:30
Can anyone know the output of q4
OnlyWayToLive 2021-06-18 18:14:53
Hey everyone,

If I had large data sets of vibrational data (essentially just arrays of about 1mb of data) would mysql be a good use case for it? Would I be better using the JSON column type and storing it all in there, or splitting it into 10s of thousands of single table entries?

2021-06-18 21:15:55
Then tell me bro
2021-06-18 21:50:45
Ok bro
|