How to insert data error?

[Code=sql]
[INSERT into ' Test ' (' id ', ' uid ', ' regdate ', ' remark ') VALUES ([],[xiaoming],[now ()],[software engineer])
/code]

Reply to discussion (solution)

INSERT into ' test ' (' id ', ' uid ', ' regdate ', ' remark ') VALUES (', ' xiaoming ', now (), ' software engineer ')

INSERT into ' test ' (' uid ', ' regdate ', ' remark ') VALUES (' Xiaoming ', now (), ' software engineer ')

INSERT into ' test ' (' id ', ' uid ', ' regdate ', ' remark ') VALUES (' ', ' Xiao Zhang ', ' Now () ', ' workers ')
Help me to look at this error, this is true, but every time you have to make such a mistake

INSERT into ' test ' (' id ', ' uid ', ' regdate ', ' remark ') VALUES (', ' xiaoming ', now (), ' software engineer ')

It would be better if you could help me see where I was wrong, thank you.

Now () is a function of MySQL, enclosed in quotation marks, it becomes a string.

Now () is a function of MySQL, enclosed in quotation marks, it becomes a string.

A change, a mistake.

If you are wrong, you will post the wrong message!

Paste the type, uid for Xiao Ming? It is possible that your UID is of type int ... Pure speculation.

So what about INSERT into ' test '? should be INSERT into ' test ' or nsert into test

So what about INSERT into ' test '? should be INSERT into ' test ' or nsert into test

The moderator is really careful.

Test keyword = ' test '

