Looking to buy a domain?
Many hosting services throw in the name for free and even let users register it as part of the package. By offering the first year free of charge, these partners give their customers real value for money. 113 more words
Tags » Mysql
Example to add multiple foreign keys in one go:–
ALTER TABLE users_role_map ADD CONSTRAINT FK_users_role_map1 FOREIGN KEY (email) REFERENCES usert(email) ON UPDATE CASCADE ON DELETE CASCADE, ADD CONSTRAINT FK_users_role_map2 FOREIGN KEY (id) REFERENCES rolet(id) ON UPDATE CASCADE ON DELETE CASCADE;45 more words
I faced this error when exporting the database from one server to other server, as the user doesn’t exist. So I changed the incorrect username into right one as given below. 244 more words