Do you have data in the table?

what nonsence

You just can’t run something from terminal without running bush.

ok smarty what is .sh

hahahahah u can if you run shell

😛

Terminal and bash is same.

bravo

Sell and bash is same

but bash script isnt

bravo again

i see u didnt understand my question

Bash script is run by bash, from bash

i have a .sh file and that is bash script

Completely

which you run from bash/shell

and in that .sh script i have mysql connection with ssl keys

and it doesnt work

but if you run it direcktly on console terminal of bash

it works

have you ever made bash scripts ?

A lot

then why do make fun of someone based on your “knowledge” on technical terms when i see u also dont understand them

But of you run .sh script it is run in the same environment as usual bash commands, that is the problem

exactly that is the issue

why the hell it blows on .sh execution

weird right?

I don’t make fun I just don’t understand

Can you post the script?

fair enough… truce 🤝

sure as soon as i put my kids in bed

Do you need strictly to use SSL, or possibly you can use SSH tunneling?

null nothing

yup cause we don’t have any rights for that machine

How to install MySQL in pc

sudo apt install mysql

apt update && apt install mysql -y

This is from a root user

Or do you use Kali?

sudo !!
)

Mysql 8.0

what’s wrong?

Cannot add or update a child row: a foreign key constraint fails (university.#sql-5384_1a, CONSTRAINT self_foreignConstraint FOREIGN KEY (ChiefFK) REFERENCES teacher (TchPK) ON DELETE SET NULL)

ALTER TABLE teacher
ADD CONSTRAINT self_foreignConstraint FOREIGN KEY(ChiefFK) REFERENCES teacher(TchPK) ON DELETE SET NULL;

Do you have data in the table?

One row

Does it apply to your new schema with this constraint? And types are the same in the two tables?

There is one table teacher. I need to add a foreign key for chiefpk on tchpk. If I delete tchpk, chiefpk will set null. Tchpk is a primary key.

I mean the types of fields are the same?

Both are tinyInt, but the first one is primary key, which can’t be null