Skip to content

Instantly share code, notes, and snippets.

@INDIAN2020

INDIAN2020/gist:5591641

Created May 16, 2013 13:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save INDIAN2020/5591641 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save INDIAN2020/5591641 to your computer and use it in GitHub Desktop.
Download ZIP
links
Raw
gistfile1
//create a new theater
INSERT INTO `mydb`.`theater` (`theater_id`, `theater_name`) VALUES (NULL, 'Bollywood'), (NULL, 'Hollywood');
//creating movie
INSERT INTO `mydb`.`movie` (`movie_id`, `movie_name`, `movie_released`, `movie_end`, `movie_budget`, `movie_status`, `theater_theater_id`) VALUES (NULL, 'Gundejari Gallantainde', '2013-05-01', NULL, 'high', '1', '1'), (NULL, 'Siva', '2013-04-01', '2013-04-30', 'low', '1', '1');
http://stackoverflow.com/questions/6446288/php-mysql-search-code-and-logic-for-relational-database-schema
http://www.sitepoint.com/understanding-sql-joins-mysql-database/
http://www.9lessons.info/2010/07/database-sql-searching-techniques.html
http://coddswallop.wordpress.com/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment