Advertisement
Guest User

Untitled

a guest
May 6th, 2015
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. CREATE TABLE stars_in_movies(
  2. star_id int NOT NULL,
  3. movie_id int NOT NULL,
  4. KEY 'star_id' ('star_id'),
  5. KEY 'movie_id' ('movie_id'),
  6. CONSTRAINT 'stars_in_movies_ibfk_1' FOREIGN KEY('star_id') REFERENCES 'stars'('id'),
  7. CONSTRAINT 'stars_in_movies_ibfk_2' FOREIGN KEY('movie_id') REFERENCES 'movies'('id'),
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  9.  
  10. INSERT INTO stars_in_movies (907010, 834410);
  11.  
  12. ERROR 1064 (4200): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to user near '907010, 834410)' at line 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement