Any vaccancy in MySQL database as a fresher?

|
Prati 2022-03-23 14:46:59
svart 2022-03-23 14:42:26
sorry, i do not get what you are talking about

I was loading the data to PostgreSql database from Azure portal….but then I need to delete those records that are not properly loaded in the table.

Prati 2022-03-23 14:47:15
Suppi00 2022-03-23 14:45:49
In node js?

No I need to delete it on PostgreSql database

Suppi00 2022-03-23 14:47:50
you can have an array of ids and split it into chunks
Suppi00 2022-03-23 14:48:38
like if you have 100 ids then you create it like -> [ …25 ids],[….25ids][….25ids][….25 ids]
Prati 2022-03-23 14:49:08
Suppi00 2022-03-23 14:47:50
you can have an array of ids and split it into chunks

Ids are not defined….. I’m working on timeseries data…..so we have to delete on basis of timestamp s

snehakshaylata 2022-03-23 14:49:14
Suppi00 2022-03-23 14:46:01
I did 200 millions record creation

Yes vo stri hai kuchh bhi kr skti h 😅😅

svart 2022-03-23 14:49:18
Prati 2022-03-23 14:46:59
I was loading the data to PostgreSql database from Azure portal….but then I need to delete those records that are not properly loaded in the table.

once again take a look at pt-archiver

Suppi00 2022-03-23 14:49:33
Prati 2022-03-23 14:49:08
Ids are not defined….. I’m working on timeseries data…..so we have to delete on basis of timestamp s

so you can have time inplace of it

Prati 2022-03-23 14:49:46
svart 2022-03-23 14:49:18
once again take a look at pt-archiver

Yeah I’ll

Prati 2022-03-23 14:49:53
Suppi00 2022-03-23 14:49:33
so you can have time inplace of it

Okay

snehakshaylata 2022-03-23 15:28:13
yes
snehakshaylata 2022-03-23 15:28:17
Which language u r using for frontend??
snehakshaylata 2022-03-23 15:29:40
Sorry bro python had captured by forest rangers
snehakshaylata 2022-03-23 15:31:25
Brother python snake u r talking about na?
snehakshaylata 2022-03-23 15:32:25
yeah that why I am saying python captured by Forest rangers
snehakshaylata 2022-03-23 15:34:46
snehakshaylata 2022-03-23 15:31:25
Brother python snake u r talking about na?

No bro I am asking to u ….u say yes

SA_Shivangi 2022-03-23 18:06:27
mysql_en-19037.jpg
Anyone please suggest how can i calculate the percentage of count animalid
Bcoz I have try this with cross join but no luck there is some error group by with cross join

Any solution?

snehakshaylata 2022-03-23 18:21:52
SA_Shivangi 2022-03-23 18:06:27
Anyone please suggest how can i calculate the percentage of count animalid
Bcoz I have try this with cross join but no luck there is some error group by with cross join

Any solution?

Wait bro

snehakshaylata 2022-03-23 18:22:04
SA_Shivangi 2022-03-23 18:06:27
Anyone please suggest how can i calculate the percentage of count animalid
Bcoz I have try this with cross join but no luck there is some error group by with cross join

Any solution?

U want in current columns right?

snehakshaylata 2022-03-23 18:24:19
Hahaha I know u r drunk because u dont know difference male and female
SA_Shivangi 2022-03-23 18:33:57
Yes
snehakshaylata 2022-03-23 18:39:35
Come and check I have python 😂😂
snehakshaylata 2022-03-23 18:39:48
SA_Shivangi 2022-03-23 18:33:57
Yes

He asking me

Babe_143 2022-03-23 20:08:46
How can we get user input to insert values in mysql using java
piterden 2022-03-23 20:10:33
Babe_143 2022-03-23 20:08:46
How can we get user input to insert values in mysql using java

Where?

Amrendra_Singh1 2022-03-24 06:48:22
Prati 2022-03-23 14:33:51
Hi all….I have a requirement to delete some data(200 million rows) from a table having aprrox 136GB of data. How can I achieve this faster as querying this huge data is taking lot of time.

First disable then delete

Liran 2022-03-24 13:02:59
how can I avoid DEAD_LOCK when running such update

UPDATE `table_test` SET `is_canceled` = ? WHERE `id` NOT IN (?, ?, ?, ?) AND `opportunity_id` = ?

our service run 50-100 such statments in a bulk

cris_highlight_bot 2022-03-24 13:03:00
Liran 2022-03-24 13:02:59
how can I avoid DEAD_LOCK when running such update

UPDATE `table_test` SET `is_canceled` = ? WHERE `id` NOT IN (?, ?, ?, ?) AND `opportunity_id` = ?

our service run 50-100 such statments in a bulk

mysql_en-19066.jpg

svart 2022-03-24 16:26:50
Liran 2022-03-24 13:02:59
how can I avoid DEAD_LOCK when running such update

UPDATE `table_test` SET `is_canceled` = ? WHERE `id` NOT IN (?, ?, ?, ?) AND `opportunity_id` = ?

our service run 50-100 such statments in a bulk

are you sure about “not in” condition?

surajpatil1146 2022-03-24 16:41:02
Any vaccancy in MySQL database as a fresher??
Danish HR 2022-03-24 20:54:02
Ok
Naman 2022-03-24 22:16:07
mysql_en-19086.jpg
Forgot syntax of MySQL for adding date help
piterden 2022-03-24 22:18:00
Naman 2022-03-24 22:16:07
Forgot syntax of MySQL for adding date help

Pay a bit more attention to written by yourself

Naman 2022-03-24 22:19:03
piterden 2022-03-24 22:18:00
Pay a bit more attention to written by yourself

Already tried 5 time

Naman 2022-03-24 22:19:14
That’s why came here
|