title: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax
body: <p>I wrote a MySQL stored procedure: </p>
  
  <pre><code>CREATE PROCEDURE add_Customer
       (
          IN  p_customer_id                   INT(11)       , 
          IN  p_Email                         VARCHAR(70)   , 
          IN  p_password                      VARCHAR(15)   ,        
          IN  p_firstname                     VARCHAR(40)   , 
          IN  p_lastname                      VARCHAR(40)   , 
          IN  p_birth_date                    DATE          ,
          IN  p_gender                        VARCHAR(20)   ,      
          IN  p_address_1                     VARCHAR(200)  ,
          IN  p_address_2                     VARCHAR(200)  ,
          IN  p_city                          VARCHAR(40)   ,    
          IN  p_state                         VARCHAR(40)   ,
          IN  p_country                       VARCHAR(50)   ,
          IN  p_phoneNumber                   VARCHAR(20)   ,
          IN  p_postalcode                    VARCHAR(10)   ,
          IN  p_billingAddress                VARCHAR(200)  ,
          IN  p_billingCity                   VARCHAR(60)   ,
          IN  p_billingCountry                VARCHAR(70)   ,
          IN  p_billingState                  VARCHAR(70)   ,
          IN  p_billing_Zip_code              VARCHAR(15)   ,
          IN  p_shippingAddress               VARCHAR(250)  ,
          IN  p_shippingCity                  VARCHAR(50)   ,
          IN  p_shippingCountry               VARCHAR(60)   ,
          IN  p_shippingState                 VARCHAR(60)   ,
          IN  p_shipping_zip_code             VARCHAR(15)   ,
          IN  p_credit_card_number            VARCHAR(20)   ,
          IN  p_name_on_creditCard            VARCHAR(70)   ,
          IN  p_credit_card_type              VARCHAR(20)   ,
          IN  p_cardSecurityCode              INT(4)        ,
          IN  p_card_exp_date                 DATE          ,
          IN  p_K_net_account                 VARCHAR(40)   ,
          IN  p_account_status                VARCHAR(30)   ,
          IN  p_email_verified                VARCHAR(20)   ,
          IN  p_registration_date             DATE          ,
          IN  p_verification_code             VARCHAR(20)   ,
          IN  p_last_login                    TIMESTAMP        )              
  
  
  
  BEGIN 
  
      INSERT INTO customer
           (
              CustomerID          ,
              CustomerEmail       ,
              CustomerPassword    ,
              FirstName           ,
              LastName            ,
              DateOfBirth         ,
              Gender              ,
              Address_1           ,
              Address_2           ,
              City                ,
              Region              ,
              Country             ,
              PhoneNumber         ,
              PostalCode          ,
              BillingAddress      ,
              BillingCity         ,
              BillingState        ,
              BillingCountry      ,
              BillingPostalCode   ,
              ShippingAddress     ,
              ShippingCity        ,
              ShippingState       ,
              ShippingCountry     ,
              ShippingPostalCode  ,
              CreditCardType      ,
              CreditCardNumber    ,
              NameOnCreditCard    ,
              CardSecurityCode    ,
              CardExpDate         ,
              K_NetAccount        ,
              AccountStatus       ,
              VerivecationCode    ,
              EmailVerified       ,
              RegistrationDate    ,
              LastLogin           ,
            )  
  
         VALUES
           ( 
            p_customer_id                     , 
            p_Email                           , 
            p_password                        ,        
            p_firstname                       , 
            p_lastname                        , 
            p_birth_date                      ,
            p_gender                          ,      
            p_address_1                       ,
            p_address_2                       ,
            p_city                            ,    
            p_state                           ,
            p_country                         ,
            p_phoneNumber                     ,
            p_postalcode                      ,
            p_billingAddress                  ,
            p_billingCity                     ,
            p_billingState                    ,
            p_billingCountry                  ,
            p_billing_Zip_code                ,
            p_shippingAddress                 ,
            p_shippingCity                    ,
            p_shippingState                   ,
            p_shippingCountry                 ,      
            p_shipping_zip_code               ,
            p_credit_card_type                ,
            p_credit_card_number              ,
            p_name_on_creditCard              ,
            p_cardSecurityCode                ,
            p_card_exp_date                   ,
            p_K_net_account                   ,
            p_account_status                  ,
            p_verification_code               ,
            p_email_verified                  ,
            p_registration_date               ,               
            p_last_login                   )     
  END 
  </code></pre>
  
  <p>and when execute it shows this message </p>
  
  <blockquote>
    <p>" #1064 - You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use
    near ') VALUES ( p_customer_id ' at line 80"</p>
  </blockquote>
  
  <p>How can I fix it?</p>