title: Insert Into Values?
body: <p>So I was ask to create a table, then insert into w/ values.  I'm not looking for someone to do it for me just need some help with it.</p>
  
  <p>All the book said was to, Insert values into the table with the INSERT INTO .. VALUES option.  Use the form of INSERT INTO.. VALUES that requires you to have a value for each column; therefore, if if you have a customer number, address, balance, you must insert three values with INSERT INTO .. VALUES.</p>
  
  <pre><code>CREATE TABLE Cust (Customer_Number CHAR(3),
  Adress CARCHAR(20),
  Balance SMALLMONEY)
  </code></pre>
  
  <p>I have that for my table, then</p>
  
  <pre><code>INSERT INTO Cust (Customer_Number, Balance, Address)
  VALUES ('101', '200'
  '102', '700'
  '103', '1000'
  '104', '1500'
  '105', '2000')
  </code></pre>
  
  <p>Not sure if any of what I asked or what I have down is right, but any help will help me alot, thanks.</p>