Help for this page

Select Code to Download


  1. or download this
    DELETE FROM page WHERE user_id = 1
    DELETE FROM user WHERE user_id = 1
    
  2. 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'
    
  3. 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