create.sql

来自「JAVA Servlet2.3外文书籍源码」· SQL 代码 · 共 15 行

CREATE DATABASE inventory;
USE inventory;

CREATE TABLE item (
  id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(30) NOT NULL,
  description VARCHAR(30) NOT NULL,
  price DOUBLE NOT NULL,
  stock INTEGER NOT NULL);

  INSERT INTO item (name, description, price, stock)
  VALUES ('Straw Hat', 'The best in town', 78.99, 9012);
INSERT INTO item (name, description, price, stock)
  VALUES ('Polo Shirt', 'The latest fashion', 49.99, 99);