How can i repair my tables?

Wait

In this it sr has to come by 1 if Asin are getting changed in sequence

Don’t do like this, ever.
Don’t use variables in a quiery

Now it’s coming in sequence 1,2,3,4 etc

No I can’t help. Sorry

I want in 1,2,1,2 where Asin are getting changed

Okay thanks

Also this query is missing join conditions on all tables, it’s completely wrong

It’s single table source

Why at all do you need this field?

For Some purpose

So do something

Normally this is done with window functions and something like RANK()

https://dev.mysql.com/doc/refman/8.0/en/window-functions.html

Hello. Could someone explain the functioning of the highlighted text. Is the word ‘variables’ a keyword?

select Salary, DepartmentId, @row := IF(DepartmentId=@did, @row + 1,1) as Rank , @did:=DepartmentId
from (
select distinct Salary, DepartmentId
from Employee
order by DepartmentId, Salary desc
) ordered, (select @row:=0, @did:=0) variables

Which version you are using ?

MySQL Administration
Here You will be able to learn all about MySQL Administration. Note: This channel is created only for leaning purpose
https://t.me/mysqladministration

8.0

Remove row variable

Is it a looping statement

Defined at the bottom. And it is satisfied until the r has attained a specific value?

You do alternative option use ROW_NUMBER() WINDOW FUNCTION

See in this image num and sr_no are same.

https://www.xaprb.com/blog/2006/12/15/advanced-mysql-user-variable-techniques/

Don’t ever use things like this, don’t use variables in a quiery other way then as parameters.

These are techniques you should never use…

in some cases prior to mysql 8 is useful things, after the mysql 8 with window functions and other stuff they become useless

Hi guys

I have face an error on xampp MySQL

12:27:29 PM [mysql] Error: MySQL shutdown unexpectedly.
12:27:29 PM [mysql] This may be due to a blocked port, missing dependencies,
12:27:29 PM [mysql] improper privileges, a crash, or a shutdown by another method.
12:27:29 PM [mysql] Press the Logs button to view error logs and check
12:27:29 PM [mysql] the Windows Event Viewer for more clues
12:27:29 PM [mysql] If you need more help, copy and post this
12:27:29 PM [mysql] entire log window on the forums

Please help me

unknown storage engine ‘innodb’

When i check or repare table show me this error again

How can i repair my tables ?

Its happen when the datacenter electricity is gone

Its my error message

What happened then, when you pressed this “Logs” button ?

This is not necessarily an error. You maybe don’t use Inno at all

Can you help me to solve this please ?

No. You should do it yourself

Stupid task, dude, no need to solve it.

I have started my xampp control panel to do practice but MySQL wasn’t start when I went it.

And I want know how can I recover my exist database if don’t create any backup before the MySQL disaster.

Thanks in advance.

So what do you have? Where from you are going to recover your data?

About broken start: check your logs. There should be a reason of crash

I have location of MySQL folder which create by xampp installation path.

And what do you want to recover?

Ok, I will do.

Generally windows is not the best choice if you want to develop software. IMHO

Windows is good for gaming and for low skilled users

What you i need use to develop software?
iOS or Linux based OS?