insert_into tb_loan (Product_Code, Customer_Code, Loan_Amount, Rate_Interest, Amount_Tenure, Emi_Amount, Emi_Start, Emi_End) VALUES (0,0,'10000',10.37,'20','546.6','25-10-2013','25-10-2013')
无法插入:您的 SQL 语法有错误;请查看与您的 MySQL 服务器版本对应的手册,了解在第 1 行的"insert_into tb_loan(Product_Code、Customer_Code、Loan_Amount、Rate_Interest、Am'"附近使用的正确语法
替换
insert_into
跟
insert into
并更好地使用YYYY-MM-DD
日期格式
insert into tb_loan (Product_Code, Customer_Code, Loan_Amount, Rate_Interest, Amount_Tenure, Emi_Amount, Emi_Start, Emi_End)
VALUES (0,0,'10000',10.37,'20','546.6','2013-10-25','2013-10-25')
您的插入查询是错误的,请尝试此操作
INSERT INTO tb_loan(Product_Code, Customer_Code, Loan_Amount, Rate_Interest, Amount_Tenure, Emi_Amount, Emi_Start, Emi_End) VALUES (0,0,'10000',10.37,'20','546.6','25-10-2013','25-10-2013')
将insert_into
替换为INSERT INTO