How to solve mysql error 1054modify

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!