The solution to mysql error 1054modify is to add quotation marks to the string, such as "insert into stock(code,name,b_price,s_price,num,rate,profit) values (123,'qq',1 ).
Recommended: "mysql tutorial"
mysql 1054 error
Insert into the database An error is reported when inserting data. The data is inserted like this
[SQL] insert into stock(code,name,b_price,s_price,num,rate,profit) values (123,qq,1,2,100,2,10) [Err] 1054 - Unknown column 'qq' in 'field list'
Solution:
Add quotation marks to the string
[SQL] insert into stock(code,name,b_price,s_price,num,rate,profit) values (123,'qq',1,2,100,2,10)
Affected data columns : 1
Time: 0.003ms
The above is the detailed content of How to solve mysql error 1054modify. For more information, please follow other related articles on the PHP Chinese website!