Talk:Relational Database Design/Introduction

CREATE TABLE order ( order_id INT AUTO_INCREMENT PRIMARY KEY, Customer_id INT, amount double FOREIGN KEY(CUSTOMER_ID)REFRENCES customers(customer.id)