Hi how can I delete this file?

|
Vchoudhary12 2022-07-31 19:03:42
Concat(Substr(FirstName,1,4), Substr (DOJ,1,4) )
Jonah J 2022-07-31 19:04:06
I have a system running MySQL in a 16GB ram server. The whole server hangs after too many connections. I estimate at around 10k simultaneous connections. How can increase the capacity without increasing my RAM
sara sara 2022-07-31 19:23:20
Vchoudhary12 2022-07-31 12:17:19
sudo might not work with cd.. better you change directory first and then run sudo command to install

mysql_en-23316.jpg
ok
The flush command is done here? and is it correct??

Prasanth Raj 2022-07-31 21:24:56
Hello Bros present I’m learning Power bi
Prasanth Raj 2022-07-31 21:25:00
Full stack
Prasanth Raj 2022-07-31 21:25:10
I know MySQL also
Swapnil 2022-07-31 22:06:08
suricruise1 2022-07-31 17:20:00
1.7
2.9
3.9
4.25
5.2
6.2

2. 8

Doman02 2022-07-31 22:06:45
Hello everyone
I’m using Kaggle and I’m facing troubles with the very beginning of the database accessing and examining …

Can anyone help me, please

suricruise1 2022-08-01 06:24:34
Swapnil 2022-07-31 22:06:08
2. 8

Yes bro

Dybalalover07 2022-08-01 07:12:51
mysql_en-23330.jpg
Hii Guys Anyone Help me
How can i get Reverse Counter Latest Update value While Grouping
Dybalalover07 2022-08-01 07:13:37
Dc is Update time but reverse rate shown first value
Swapnil 2022-08-01 08:15:58
Dybalalover07 2022-08-01 07:12:51
Hii Guys Anyone Help me
How can i get Reverse Counter Latest Update value While Grouping

What is expected output ?

Dybalalover07 2022-08-01 09:43:34
mysql_en-23335.jpg

Dybalalover07 2022-08-01 09:44:53
Dybalalover07 2022-08-01 09:43:34

Swapnil this is Norma output
I need
Every one latest update date have latest Reverse counter rate

Dybalalover07 2022-08-01 09:45:16
Help Swapnil
A 2022-08-01 11:03:01
Hi guys, i am using groupConcat on a column and grouping it to fetch unique values only.But I need to sort the data based on date.So will have to groupConcat on date as well but how do I sort now after group concat?
A 2022-08-01 11:03:04
Can anyone tell
Vchoudhary12 2022-08-01 11:13:37
You can use order by inside group_concat
Vchoudhary12 2022-08-01 11:16:08
Dybalalover07 2022-08-01 07:12:51
Hii Guys Anyone Help me
How can i get Reverse Counter Latest Update value While Grouping

Should this be group by DC and not DA

sara sara 2022-08-01 11:22:24
mysql_en-23343.jpg
Hello, I am uploading my script with LAMP, should I write localhost instead of the red text? Does this mean?
sara sara 2022-08-01 11:22:44
mysql_en-23344.jpg
is this true?
V9000000 2022-08-01 11:33:29
sara sara 2022-08-01 11:22:44
is this true?

Yes

Swapnil 2022-08-01 12:03:12
Dybalalover07 2022-08-01 09:44:53
Swapnil this is Norma output
I need
Every one latest update date have latest Reverse counter rate

What does everyone mean here ?

Dybalalover07 2022-08-01 12:42:13
Swapnil 2022-08-01 12:03:12
What does everyone mean here ?

Date= 2021-12-27
revrese-counter-rate =14221

Date=2021-12-28
revrese-counter-rate=10490

Date=2021-12-29
revrese-counter-rate=10536

I need this out put

Swapnil 2022-08-01 13:07:00
Dybalalover07 2022-08-01 09:43:34

select *
from (
select
update_date, reverse_counter_date,
row_number() over (partition by date(update_date) order by reverse_counter_date desc) as rn
from
(
Select Max(updated_date) as update_date, reverse_counter_rate
from db1.exchange_rates
where currency_id = ’64’
and rate_date >= ‘2021-12-27’
and rate_date <= ‘2021-12-30’
Group by reverse_counter_rate
) as X
) as Y
where Y.rn = 1

Rashmika2716 2022-08-01 13:14:29
do u have book of mysql
Rashmika2716 2022-08-01 13:14:31
pdf
Rashmika2716 2022-08-01 13:15:15
how to insert date object or date format database through insert query
A 2022-08-01 13:42:22
Guys i have a column created after group concat which contains dates.Is it possible to now use the first value of the concatenated dates and use order by on that?
Dybalalover07 2022-08-01 16:01:01
Swapnil 2022-08-01 13:07:00
select *
from (
select
update_date, reverse_counter_date,
row_number() over (partition by date(update_date) order by reverse_counter_date desc) as rn
from
(
Select Max(updated_date) as update_date, reverse_counter_rate
from db1.exchange_rates
where currency_id = ’64’
and rate_date >= ‘2021-12-27’
and rate_date <= ‘2021-12-30’
Group by reverse_counter_rate
) as X
) as Y
where Y.rn = 1

💕💕💕 Thank Youu💕💕💕

sara sara 2022-08-01 17:07:37
V9000000 2022-08-01 11:33:29
Yes

mysql_en-23358.jpg
ok
Hi how can I delete this file?

V9000000 2022-08-01 17:24:14
Rm -rf folder name
Chandru S 2022-08-01 17:27:01
mysql_en-23361.jpg
Ans
Pavankalyan 2022-08-01 17:36:22
I have to remove last 5 carecters throughout the column
Pavankalyan 2022-08-01 17:36:32
Pavankalyan 2022-08-01 17:36:22
I have to remove last 5 carecters throughout the column

Query plz

|