Which version MySQL is installed?

|
Hola000999 2022-08-17 05:36:20
Why is that ?
Hola000999 2022-08-17 05:36:32
It has been working fine for last 3 4 months
Doman02 2022-08-17 11:59:17
Is there’s a way to see the tables with the records and it’s details in Microsoft SQL server management studio.. rather than the shortcut (alt f1) and the (select top1000 rows)
?!!???!!!!?!!??!???!??
smlkw 2022-08-17 12:29:13
Doman02 2022-08-17 11:59:17
Is there’s a way to see the tables with the records and it’s details in Microsoft SQL server management studio.. rather than the shortcut (alt f1) and the (select top1000 rows)
?!!???!!!!?!!??!???!??

It’s MsSQL, not MySQL

Doman02 2022-08-17 12:43:27
smlkw 2022-08-17 12:29:13
It’s MsSQL, not MySQL

oh .. should’ve know that
sorry
but I still need help

smlkw 2022-08-17 12:45:04
Doman02 2022-08-17 12:43:27
oh .. should’ve know that
sorry
but I still need help

https://t.me/mssqldba ask here

mkval3 2022-08-18 05:02:33
mysql_en-24096.jpg
good morninga all, I have a problem to solve. how to display sumproduct based on the study in this case? like in excel
Rajni Bukkal 2022-08-18 08:20:41
Hii ..mere program me insert ki query nhi chl rhi
Rajni Bukkal 2022-08-18 08:20:47
Anybody plz help
Amrendra_Singh1 2022-08-18 08:21:43
Rajni Bukkal 2022-08-18 08:20:41
Hii ..mere program me insert ki query nhi chl rhi

Plz share

A 2022-08-18 16:18:20
Does anyone know how to use having clause after group by in sequelize orm?
smlkw 2022-08-18 17:47:37
A 2022-08-18 16:18:20
Does anyone know how to use having clause after group by in sequelize orm?

Better to ask this question in a NodeJS group

A 2022-08-18 17:51:40
smlkw 2022-08-18 17:47:37
Better to ask this question in a NodeJS group

No worries , i got it resolved.Thanks

suresh suri 2022-08-18 20:16:53
I am getting error at declare keyword
suresh suri 2022-08-18 20:17:29
What is the parameter declare
Bilal 2022-08-18 23:24:43
mysql_en-24120.jpg
I have forget the password. Anybody can help me in this?
Bilal 2022-08-18 23:28:17
Bilal 2022-08-18 23:24:43
I have forget the password. Anybody can help me in this?

Already i have searched on youtube but i am not getting proper solution for this

Joseph (Full Stack Developer,Dotnet Core) 2022-08-19 10:32:04
create table Total_Points
(
id int primary key identity(1,1),
Code int Unique,
Points int
)

–insert into Total_Points values(1001,10)
–insert into Total_Points values(2001,20)
–insert into Total_Points values(3001,30)
–insert into Total_Points values(4001,40)
–insert into Total_Points values(5001,50)

–select * from Total_Points
–select * from Points_TRN

–create table Points_TRN
–(
–id int primary key identity(1,1),
–RefCode int ,
–EarnPoints int
–)

–insert into Points_TRN values(1001,1)
–insert into Points_TRN values(1001,2)
–insert into Points_TRN values(1001,3)
–insert into Points_TRN values(2001,2)
–insert into Points_TRN values(2001,2)
–insert into Points_TRN values(2001,2)
–insert into Points_TRN values(3001,7)
–insert into Points_TRN values(3001,5)
–insert into Points_TRN values(3001,4)

–Expected Output
— id Code Totalpoint Earnpoint FinalPoint
1 1001 10 6 4
2 2001 20 6 14
3 3001 30 16 14
4 4001 40 0 0
5 5001 50 0 0

Swapnil 2022-08-19 10:56:39
Joseph (Full Stack Developer,Dotnet Core) 2022-08-19 10:32:04
create table Total_Points
(
id int primary key identity(1,1),
Code int Unique,
Points int
)

–insert into Total_Points values(1001,10)
–insert into Total_Points values(2001,20)
–insert into Total_Points values(3001,30)
–insert into Total_Points values(4001,40)
–insert into Total_Points values(5001,50)

–select * from Total_Points
–select * from Points_TRN

–create table Points_TRN
–(
–id int primary key identity(1,1),
–RefCode int ,
–EarnPoints int
–)

–insert into Points_TRN values(1001,1)
–insert into Points_TRN values(1001,2)
–insert into Points_TRN values(1001,3)
–insert into Points_TRN values(2001,2)
–insert into Points_TRN values(2001,2)
–insert into Points_TRN values(2001,2)
–insert into Points_TRN values(3001,7)
–insert into Points_TRN values(3001,5)
–insert into Points_TRN values(3001,4)

–Expected Output
— id Code Totalpoint Earnpoint FinalPoint
1 1001 10 6 4
2 2001 20 6 14
3 3001 30 16 14
4 4001 40 0 0
5 5001 50 0 0

SELECT a.id,
a.Code,
a.Points,
coalesce(sum(b.EarnPoints),0) as Earnpoint,
coalesce(a.Points – sum(b.EarnPoints),0) as FinalPoint
FROM Total_Points a
LEFT JOIN Points_TRN b on a.Code = b.RefCode
GROUP BY 1,2,3

Juan Cruz Franchini 2022-08-19 11:00:43
Hi, I’m from Argentina.
I am looking for courses that will give me a certificate in mysql. somebody could help me?
DBA 2022-08-19 11:46:21
Bilal 2022-08-18 23:24:43
I have forget the password. Anybody can help me in this?

Which version MySQL is installed?

DBA 2022-08-19 11:47:29
If it is 5.7, follow the below steps from the link

https://dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/resetting-permissions-windows.html

Joseph (Full Stack Developer,Dotnet Core) 2022-08-19 12:36:12
Swapnil 2022-08-19 10:56:39
SELECT a.id,
a.Code,
a.Points,
coalesce(sum(b.EarnPoints),0) as Earnpoint,
coalesce(a.Points – sum(b.EarnPoints),0) as FinalPoint
FROM Total_Points a
LEFT JOIN Points_TRN b on a.Code = b.RefCode
GROUP BY 1,2,3

check my expected output

Joseph (Full Stack Developer,Dotnet Core) 2022-08-19 12:36:20
Swapnil 2022-08-19 10:56:39
SELECT a.id,
a.Code,
a.Points,
coalesce(sum(b.EarnPoints),0) as Earnpoint,
coalesce(a.Points – sum(b.EarnPoints),0) as FinalPoint
FROM Total_Points a
LEFT JOIN Points_TRN b on a.Code = b.RefCode
GROUP BY 1,2,3

–Expected Output
— id Code Totalpoint Earnpoint FinalPoint
1 1001 10 6 4
2 2001 20 6 14
3 3001 30 16 14
4 4001 40 0 0
5 5001 50 0 0

Swapnil 2022-08-19 13:20:04
Joseph (Full Stack Developer,Dotnet Core) 2022-08-19 12:36:20
–Expected Output
— id Code Totalpoint Earnpoint FinalPoint
1 1001 10 6 4
2 2001 20 6 14
3 3001 30 16 14
4 4001 40 0 0
5 5001 50 0 0

Thats what i got using the query i had send

Swapnil 2022-08-19 13:20:19
Are you not getting output ?
Bilal 2022-08-19 13:42:42
DBA 2022-08-19 11:46:21
Which version MySQL is installed?

I have reinstalled it.
Thanks for response

P M 2022-08-19 13:44:39
I need DBA support.
smlkw 2022-08-19 13:48:18
P M 2022-08-19 13:44:39
I need DBA support.

which support?

VEX0102 2022-08-19 14:28:33
Fixed
P M 2022-08-19 16:27:44
smlkw 2022-08-19 13:48:18
which support?

Msg

P M 2022-08-19 16:27:58
smlkw 2022-08-19 13:48:18
which support?

I just msgd you

smlkw 2022-08-19 16:28:09
ok
DBA 2022-08-19 20:21:34
Bilal 2022-08-19 13:42:42
I have reinstalled it.
Thanks for response

Ok

Krishna Sarath 2022-08-20 11:53:35
I need sql developer support
|