And what about information about those references?

no 🙁

still happening

https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html

Maybe this will help

this is the process of mysql

Using shell is better in general

Maybe copy the table to another one, and then try your inserts

Then remove columns one by one and try performing them again

I think it happened because of sqli – someone didn’t use data in the format they were supposed to

I had a copy of the working database, so I uploaded just structure and after that pasted data in to it bu still the same 🙁

this happened when I added a new column, I removed new column but it just didn’t fixed

Hence we have a clearer picture now

Do you have a backup before this particular alteration?

for 2 days tried almost every solution and I’m about to get crazy

dont know what to do

Do you have it?

yess

And you have restored this backup?

I just uploaded and transferred data into it

with old structure

this is the last results

Then dump the table as soon as possible.

Bad piece of advice…

what do you mean this exacty

Dump the data by mysqldump utility , this table at least or whole DB, if possible, for you to have latest data.

How to do that?

Man mysqldump

now the table working but too slow

maybe 3 or 4 minutes

Mysql workbench closing while opening existing stored procedure. Ican create n delete stored procedure. How do i resolve this

Do you have default DB selected?

You mean while executing SP?

So I have table A with the primary key column and another table B with a foreign key column

Cardinality is 1..* from A->B

My question is that are the values of the foreign key column stored separately in table B, or they are simply referenced to the existing values of the PK column in table A

Try to select * from table B without A

What do you mean referenced?

A reference to the PK column, a pointer in terms of C

And what about information about those references?

Of course they are stored physically. Reference is just a pointer to a table

Not to a value

Okayy I see
But lets consider a user table with 1 mln users, who have UUIDs and for simplicity, we consider that they are bigints

Now, in another table, say we are storing some logs, and the FK of this table is to the user table

Don’t you think that a lot of extra data is being stored?

UUIDs??? WTF? That table has id column

I just meant unique ids yes 😛

You mean exactly what you have wrote

Databases were made to store data

Any way to manually circumvent this behavior?
Like in python, explicit assignment points to same object in memory

Okay, how the one taken row from B would know to which row it should be referenced in A?

Via the reference to a row of PK in A

The values of PK are already indexed in the memory, so all one would require is a pointer to that particular memory location