MySQL CREATE TABLE with AUTO_INCREMENT #41

Medium 30 pts New · no attempts yet sql

Topics

Toolliyo edge

MySQL: MySQL CREATE TABLE with AUTO_INCREMENT #41

Static hints

Use MySQL docs syntax for LIMIT and functions

Toolliyo Coach

Stuck? Get a nudge — not the answer

Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.

Your solution

Editor is open — no login wall to practice.

Ready — edit the code above and click Run or Submit.

Official solution

CREATE TABLE orders (
  id INT AUTO_INCREMENT PRIMARY KEY,
  customer_id INT NOT NULL,
  amount DECIMAL(12,2) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT fk_customer FOREIGN KEY (customer_id) REFERENCES customers(id)
) ENGINE=InnoDB;

Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.

Explanation

MySQL-specific syntax: LIMIT, AUTO_INCREMENT, ENGINE=InnoDB, DELIMITER for procedures.

Prev Next All problems

MySQL CREATE TABLE with AUTO_INCREMENT #41

Stuck? Get a nudge — not the answer

Your solution

Official solution

Explanation

Your submissions

Discussion