- or download this
DELETE FROM page WHERE user_id = 1
DELETE FROM user WHERE user_id = 1
- or download this
DELETE FROM page WHERE page_id = '1'
DELETE FROM page WHERE page_id = '2'
...
DELETE FROM page WHERE page_id = '4'
DELETE FROM page WHERE page_id = '5'
DELETE FROM user WHERE user_id = '1'
- or download this
FOREIGN KEY (user_id) references user (user_id) ON DELETE CASCADE,
KEY user_id (user_id)
# and replace "MyISAM" with "InnoDB" for both tables