Select Code to Download

CREATE TABLE payment_types (
    id     int primary key auto_increment, 
...
INSERT INTO order (pay_type) VALUES (
    (SELECT id FROM payment_type WHERE name = 'VISA')
)