It does not work. What should i do? #8
Description
Hello, i am thankful for your worthwile cause but i couldn't make it work.
Here what i did:
"CTRL+A" and "Execute".
Here what i saw:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '`'.
Msg 105, Level 15, State 1, Line 1111
Unclosed quotation mark after the character string ');
--
-- Indexes for dumped tables
--
-- Indexes for table categories
ALTER TABLE categories
ADD PRIMARY KEY (CategoryID);
--
-- Indexes for table customers
ALTER TABLE customers
ADD PRIMARY KEY (CustomerID);
--
-- Indexes for table employees
ALTER TABLE employees
ADD PRIMARY KEY (EmployeeID);
--
-- Indexes for table orders
ALTER TABLE orders
ADD PRIMARY KEY (OrderID),
ADD KEY CustomerID (CustomerID),
ADD KEY EmployeeID (EmployeeID),
ADD KEY ShipperID (ShipperID);
--
-- Indexes for table order_details
ALTER TABLE order_details
ADD PRIMARY KEY (OrderDetailID),
ADD KEY OrderID (OrderID),
ADD KEY ProductID (ProductID);
--
-- Indexes for table products
ALTER TABLE products
ADD PRIMARY KEY (ProductID),
ADD KEY CategoryID (CategoryID),
ADD KEY SupplierID (SupplierID);
--
-- Indexes for table shippers
ALTER TABLE shippers
ADD PRIMARY KEY (ShipperID);
--
-- Indexes for table suppliers
ALTER TABLE suppliers
ADD PRIMARY KEY (SupplierID);
--
-- AUTO_INCREMENT for dumped tables
--
-- AUTO_INCREMENT for table categories
ALTER TABLE categories
MODIFY CategoryID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table customers
ALTER TABLE customers
MODIFY CustomerID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
--
-- AUTO_INCREMENT for table employees
ALTER TABLE employees
MODIFY EmployeeID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table orders
ALTER TABLE orders
MODIFY OrderID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10444;
--
-- AUTO_INCREMENT for table order_details
ALTER TABLE order_details
MODIFY OrderDetailID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=519;
--
-- AUTO_INCREMENT for table products
ALTER TABLE products
MODIFY ProductID int(11) NOT NULL AUTO_INCREMENT, AUTO_INCRE...