#1064 - 您的SQL语法有错误;查看与MySQL服务器版本对应的手册,以获得正确的语法

时间:2022-04-11 14:57:24

I wrote a MySQL stored procedure:

我写了一个MySQL存储过程:

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 

and when execute it shows this message

并在执行时显示此消息

" #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"

“#1064 - 您的SQL语法有错误;请查看与您的MySQL服务器版本对应的手册,以便在附近使用正确的语法')VALUES(第80行的p_customer_id')

How can I fix it?

我该如何解决?

2 个解决方案

#1


1  

You have a redundant comma (,) before the closing brackets ()) in the columns clause.

在columns子句中,在结束括号()之前有一个冗余逗号(,)。

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           -- Comma removed here
      )  

   VALUES
      -- Snipped

#2


0  

Remove the trailing "," (comma) in

删除尾随的“,”(逗号)

LastLogin           ,

                    ^
                    |

#1


1  

You have a redundant comma (,) before the closing brackets ()) in the columns clause.

在columns子句中,在结束括号()之前有一个冗余逗号(,)。

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           -- Comma removed here
      )  

   VALUES
      -- Snipped

#2


0  

Remove the trailing "," (comma) in

删除尾随的“,”(逗号)

LastLogin           ,

                    ^
                    |