ALTER TABLE FOREIGN
Hi:
Three tables. users, users_initial and users_dues
Trying to set relation form users_dues to users_initial in php MyAdmin SQL
SQL query:
ALTER TABLE users_dues
ADD FOREIGN KEY (user_id)
REFERENCES users_initial(user_id)
ON DELETE CASCADE
ON UPDATE CASCADE;
MySQL said: Documentation
#1146 - Table 'bwmjcmus_mem_mgr.users_dues' doesn't exist
The table does exist. Don't understand
bwmjcmus_mem_mgr
Procedures
Tables
Tables
sessions
users
users-dues
users-initial
Also, why isn't there an ON INSERT CASCADE?
Subject
Views
Written By
Posted
ALTER TABLE FOREIGN
1853
April 07, 2018 11:34AM
743
April 07, 2018 12:09PM
730
April 07, 2018 06:56PM
767
April 07, 2018 12:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.