title: Unknown column 'quantityInStock' in field list (No PHP)
body: <p>I know that this is the n-time this has been asked but the other questions were not useful (as far as i know).</p>
  
  <p>I downloaded the DB <code>classicmodels</code> for some testing, but when i run the following query:</p>
  
  <pre><code>UPDATE `products` SET `quantityInStock` = 5 WHERE `productCode` = 'S10_1678';
  </code></pre>
  
  <p>It throws the error: </p>
  
  <pre><code>Error Code: 1054. Unknown column 'quantityInStock' in 'field list';
  </code></pre>
  
  <p>I used <code>SHOW COLUMNS FROM products;</code> to check the columns:</p>
  
  <pre><code># Field,                  Type,       Null,   Key,   Default, Extra
  'productCode',         'varchar(15)', 'NO',   'PRI', NULL,     ''
  'productName',         'varchar(70)', 'NO',   '',    NULL,     ''
  'productLine',         'varchar(50)', 'NO',   'MUL', NULL,     ''
  'productScale',        'varchar(10)', 'NO',   '',    NULL,     ''
  'productVendor',       'varchar(50)', 'NO',   '',    NULL,     ''
  'productDescription',  'text',        'NO',   '',    NULL,     ''
  'quantityInStock',     'smallint(6)', 'NO',   '',    NULL,     ''
  'buyPrice',            'double',      'NO',   '',    NULL,     ''
  'MSRP',                'double',      'NO',   '',    NULL,     ''
  </code></pre>
  
  <p>I tried with another query to verify: <code>UPDATE products SET productScale = '1:1' WHERE productCode = 'S10_1678';</code> but got the same error.</p>
  
  <p>does anyone have any idea what could be causing this error?</p>
  
  <p>Here's the DDL...</p>
  
  <pre><code>CREATE TABLE Products (
    productCode VARCHAR(15) NOT NULL,
    productName VARCHAR(70) NOT NULL,
    productLine VARCHAR(50) NOT NULL,
    productScale VARCHAR(10) NOT NULL,
    productVendor VARCHAR(50) NOT NULL,
    productDescription TEXT NOT NULL,
    quantityInStock SMALLINT NOT NULL,
    buyPrice DOUBLE NOT NULL,
    MSRP DOUBLE NOT NULL,
    PRIMARY KEY (productCode)
  );
  </code></pre>