Home>Article>Database> How to solve mysql error 1054modify

How to solve mysql error 1054modify

藏色散人
藏色散人 Original
2020-10-26 09:26:33 4052browse

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 ).

How to solve mysql error 1054modify

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn