Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **Company:**
- id (pk auto inc)
- name (varchar)
- **ScereenSavers:**
- id (pk auto inc)
- name (varchar)
- path (varchar)
- company_id (int) # This is pk of Company
- SELECT id AS c_id From company
- INSERT INTO screen_savers VALUES (
- name='Screen Saver-I',
- path='screen_save_i_path',
- company_id=c_id
- ),(
- name='Screen Saver-II',
- path='screen_save_ii_path',
- company_id=c_id
- ),(
- name='Screen Saver-III',
- path='screen_save_iii_path',
- company_id=c_id
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement