What os user you are working ander at the moment?

the error “Plugin is not updatable” is saying you can’t update that field

I have re-read your and Captian Jack’s messages. This photo shows you already have needed plugin so you don’t need to set this again.

I would say more, you cannot modify system tables at all, they may be not tables, and they are handled always in a special way.

You must find some other way to change this plugin.
Read the docs about this.

And what is the problem?

Dump the database and re-install MySQL, I think it’s faster way for you to solve the problem.

Why do you think this is a problem?

Here you state the opposite

Do not ask it or do it?

What login so you use?

But it ASKS!

Empty password IS also a password!

Ok, remove -p from the command and try again

What os user you are working ander at the moment?

I’ll re read all your posts, min

So, you have Maria DB on the Windows 10 host and you have set up root@localhost with a password.
Is that correct ?

Hello everyone, Can some one help me with any freeware tool with which Oracle to MySQL database can be migrated

it is manual work only

I have no experience with maria, at all, but I’ll look for this problem.

Thanks IIia, do you have any steps or documents so that I can study and start my exercise

steps are simple
0 migrate schema
1 migrate date
3 migrate code.

And every step possible to fail, that is , this is not necessary possible at all

Ok Thanks

Guys need help to mention auto sr

Sequence

By state as per above image

Can I get some help for this

What do you want to have instead of this?

I want sr column by auto query in MySQL by sequences on Coloumn State

Sorry what?

Can you show what do you have now and what do you want to have then?

As you can see I have already mentioned in sr column that’s my requirement but I need that to select query in MySQL

I don’t understand what mention are you talking about?

Usually we don’t have mentions inside tables

What is mention?

Basically sequential number

But based on column name “state”

I have already mentioned in image for understanding

Data in MySQL tables is not sorted by default. Where from are you going to get order of rows for sequences definition?

Also you have the big mistake with normalization.

It should be table
states
– id
– name
And you should have in your table only foreign ids

Sorry I have not found anything useful.

Ok but can you help me In this

Explain what you want in details. You are completely not understandable.

I need query in select command

If you would do what I ask, then maybe. Until the present time you have ignored my questions

As I said, you need to explain more. If you can’t explain none will help you.

I wasn’t not able to understand u

Can you show what do you have now and what do you want to have then?

I need in select query

This is not clear

Show data