Home  >  Q&A  >  body text

mysql - sql字段包含逗号

我做数据库插入时,碰到插入字段有逗号。执行提示语法错误,这个应该怎样处理??
其中某一条:
。。。(word , pos , from) VALUES ('word','noun,verb','word')'

PHP中文网PHP中文网2742 days ago615

reply all(2)I'll reply

  • ringa_lee

    ringa_lee2017-04-17 11:53:13

    From is the keyword and should be written as `from`

    reply
    0
  • PHP中文网

    PHP中文网2017-04-17 11:53:13

    That doesn’t make sense. Can you post the SQL insertion statement?


    I just tested it on MySQL and there is no problem if there are commas in the input.
    Can you post your error message?


    If you see that there is a problem with your field definition and it has been resolved, please close this issue.

    reply
    0
  • Cancelreply