SELECT COUNT(*) FROM Main WHERE Name = 'New Name Value'

INSERT INTO Main (Name) VALUES ('New Name Value')

SELECT id FROM Main WHERE Name = 'New Name Value'

INSERT INTO Details (Main_ID, Detail) VALUES ('obtained ID value', 'New Detail value')

INSERT INTO Details (Main_ID, Detail)
SELECT id, 'New Detail value' FROM Main WHERE Name = 'New Name Value'