Tagged Questions
0
votes
1answer
17 views
HOW to “SUM” and “JOIN” for single query of a poll results?
I have a poll database as
CREATE TABLE poll_answer
answer_id,
answer varchar(255),
poll_id int(11),
FOREIGN KEY(poll_id) REFERENCES polls(poll_id) ON DELETE CASCADE,
PRIMARY KEY(answer_id)
) ...
0
votes
1answer
55 views
Is it possible to force drop of mysql tables with FK?
For dropping a table in which a Foreign Key is used in other tables, it is necessary to drop all other tables having FK connection with the corresponding table.
Is there a short way to drop a table, ...
0
votes
1answer
97 views
Handling error of foreign key
How to set a FK value NULL upon receiving error for foreign key constraint?
Consider a simple table a
CREATE TABLE test
(
id int(11) NOT NULL AUTO_INCREMENT
ex_key int(11),
FOREIGN ...
0
votes
0answers
40 views
How can I make MySQL rework its foreign keys?
I somehow tricked MySQL into believing I have a foreign key that does not exist.
I had a table with both an Id column and a Number column. I wanted to merge the two, so I cleared the few tables ...
