MySQL Forums
Forum List  »  Microsoft Access

ALTER TABLE FOREIGN
Posted by: Robert Tulloch
Date: April 07, 2018 11:34AM

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?

Options: ReplyQuote


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.