How to check from which table is the view retreiving?

|
MasterZiv 2019-10-06 16:44:25
kos_tya991 2019-10-06 12:01:09
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)

What is your INSERT statement you execute?

kos_tya991 2019-10-06 16:47:06
MasterZiv 2019-10-06 16:44:25
What is your INSERT statement you execute?

Could you rephrase your question?

MasterZiv 2019-10-06 16:48:23
kos_tya991 2019-10-06 12:01:09
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)

This error should be caused by some SQL statement.
It should be either insert or update.

What is it?
Show us

kos_tya991 2019-10-06 16:50:19
kos_tya991 2019-10-06 12:01:09
ALTER TABLE teacher
ADD CONSTRAINT self_foreignConstraint FOREIGN KEY(ChiefFK) REFERENCES teacher(TchPK) ON DELETE SET NULL;

I used only this one

MasterZiv 2019-10-06 16:52:57
kos_tya991 2019-10-06 16:50:19
I used only this one

Then this error cannot appear.

Ok supposing you have bad data already in the table, save the data (dump it) , delete the rows in the table, create constraint and the insert data back.

kos_tya991 2019-10-06 16:53:45
MasterZiv 2019-10-06 16:52:57
Then this error cannot appear.

Ok supposing you have bad data already in the table, save the data (dump it) , delete the rows in the table, create constraint and the insert data back.

Ok

kos_tya991 2019-10-06 17:13:29
Thanks, man. You’ve helped me)
MasterZiv 2019-10-07 13:03:52
in command line interface
MasterZiv 2019-10-07 13:03:52
where we run this
MasterZiv 2019-10-07 13:03:52
run mysql service with —skip-grant-tables for reset passwd
MasterZiv 2019-10-07 13:03:52
plz tell me
MasterZiv 2019-10-07 13:03:52
can any one explain i lost my mysql root password then how to reset this password plz tell me soon
2019-10-07 13:06:23
MasterZiv 2019-10-07 13:03:52
run mysql service with —skip-grant-tables for reset passwd

can you explain this

MasterZiv 2019-10-07 13:06:51
2019-10-07 13:06:23
can you explain this

it is explained already quite clear

MasterZiv 2019-10-07 13:07:47
2019-10-07 13:06:23
can you explain this

You could have googled it
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

2019-10-07 13:08:12
MasterZiv 2019-10-07 13:07:47
You could have googled it
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

thanks i watch then and then tell

2019-10-07 13:10:22
but in my services i am not found mysql then how to stop
MasterZiv 2019-10-07 13:11:42
2019-10-07 13:10:22
but in my services i am not found mysql then how to stop

Read the docs above

MasterZiv 2019-10-08 13:09:39
will not help …
MasterZiv 2019-10-08 13:09:39
rm -rf /tmp
MasterZiv 2019-10-08 13:09:39
Temp is full, please advise
1.how to find who is using it and
2.how to release space.

Thank you

svraju2020 2019-10-08 13:12:42
Ok ..
svraju2020 2019-10-08 13:13:07
Please advise how can I release without restart
MasterZiv 2019-10-08 13:32:40
svraju2020 2019-10-08 13:13:07
Please advise how can I release without restart

Release what?

svraju2020 2019-10-08 13:32:54
Temp usage
svraju2020 2019-10-08 13:33:12
Currently MySQL temp drive is full
MasterZiv 2019-10-08 13:34:21
svraju2020 2019-10-08 13:13:07
Please advise how can I release without restart

If the tmp space is used by MySQL then you need to stop it, the mysqld service OR extend temp space (i don’t know how)
There is no chance to finish current transactions , I suppose.
I may be wrong.

svraju2020 2019-10-08 13:34:47
Ok
iosuser1 2019-10-08 13:45:57
How to check/see table names of mysql views in phpmyadmin
MasterZiv 2019-10-08 13:49:04
iosuser1 2019-10-08 13:45:57
How to check/see table names of mysql views in phpmyadmin

just use show tables and other SHOW commands

MasterZiv 2019-10-08 13:54:20
iosuser1 2019-10-08 13:45:57
How to check/see table names of mysql views in phpmyadmin

Please note, THAT chat is for Russian speaking persons only.
For English, this chat has been created.

iosuser1 2019-10-08 13:57:24
Ok
iosuser1 2019-10-08 14:01:05
mysql_en-395.jpg
How to check from which table is the view retreiving?
MasterZiv 2019-10-08 14:41:06
iosuser1 2019-10-08 14:01:05
How to check from which table is the view retreiving?

Don’t post pictures please

iosuser1 2019-10-08 14:41:37
Any reason?
MasterZiv 2019-10-08 14:42:05
iosuser1 2019-10-08 14:01:05
How to check from which table is the view retreiving?

show create view viewname

MasterZiv 2019-10-08 14:42:16
iosuser1 2019-10-08 14:41:37
Any reason?

RULEZZZ!

iosuser1 2019-10-08 14:42:18
And its working
iosuser1 2019-10-08 14:42:32
Sometimes its hard to type all
iosuser1 2019-10-08 14:42:35
Anyways fine
MasterZiv 2019-10-08 14:43:01
iosuser1 2019-10-08 14:41:37
Any reason?

Will be deleted next time…

iosuser1 2019-10-08 14:43:14
Ok
MasterZiv 2019-10-08 14:43:56
iosuser1 2019-10-08 14:42:32
Sometimes its hard to type all

whatever is text must be posted as text.

Suneelpotluri 2019-10-08 22:02:02
MasterZiv 2019-10-03 13:06:37
You must tune this particular driver via its connection string.
It is special knowledge for specific driver or for Java in common.

We have reinstalled the client and this solved the issue. Thank you for your inputs

Suneelpotluri 2019-10-08 22:03:25
In NDB cluster data nodes, where are the actual tables stored physically. I mean, similar to .ibd files, do we have anything such.
smlkw 2019-10-12 22:11:40
@Piterden add your bot to here
piterden 2019-10-13 16:28:19
Petka cames to Vasiliy Ivanych and asks:
– Vasilivanych what is nuance?
Vasiliy Ivanych says:
– Take off your pants, Petka!
Petka takes off pants…
Vasilivanych takes his dick and pushes it in to a Petya’s ass…
– Now listen here, Petka: you have a dick in the ass ….. and me have a dick in the ass. But there is one nuance!
Manogna 2019-10-15 18:41:07
I want MySQL queries related to data analytics
Manogna 2019-10-15 18:41:12
Could anyone help
piterden 2019-10-15 18:51:02
Do it!
|