What are the causes of SQL query values syntax errors? How do I modify it?

The data type given by the sno int primary key is int, and the data you give is character!

insert into course

values ('c02','Data structures','c05',2),('c03','Databases','c02',2),('c04','Testing','c08'2) Try it this way? I've had this problem today, and the above can be successful.

After the first value is finished, insert into the course

values ('c02','Data structures','c05',2),values ('c03','Databases','c02',2)

No error messages found.

Listing Chinese in parentheses, try it!

The movie Forrest Gump This is a classic picture, the meaning is in place, the heart understands, and there is no need to investigate the grammar;

MySQL doesn't know, but I do know that SQL Server is written:

insert into sdb_cs_members(username,password,status)

select username,password,status from sdb_cs_members

If you use a subquery as the value value, there may be a problem with the data you find, so you can run a separate query to see what the data looks like.

Select Student Number, Name, Grade from Student Grade Sheet where Grade 90

Go Select Student Number, Name, Grade from Student Grade Sheet where Grade 80

delete from student grade sheet where grade 80update student grade sheet set grade=81 where grade 80insert into student grade card (student number, name, grade) values

Is there no space separating the select student number, it should be the select student number and pay attention to the punctuation in English.

The ** that created the table is right.

But the insertion is wrong.

Grammatical errors. insert into the table (field) values ('data')

The inserted values are also incorrect.

It should be''You try to insert the statement.

insert into missingpersonreport values ('001','2003-01-15 00:00:00','brown' )

Msg 8152, Level 16, State 14, Line 1.

Strings or binary data will be truncated.

The statement has been terminated.

It's a matter of setting the size of your field.

Run the SQL statement to delete the table.

drop table missingpersonreport

Then run (build table).

create table missingpersonreport (mpr_num varchar(50) not null primary key, mpr_dor datetime not null, mp_sname varchar(50) not null)

Then perform the insertion.

insert into missingpersonreport values ('001','2003-01-15 00:00:00','brown' )

1 line affected).

Succeed. Let's learn!

Encoding issues, depending on whether your database is GBK or UTF8.

strsql = "insert into jigoubaobiao (column_test,'Agency number','Branches') values('work',12,'6 branches')";Apostrophe.

What is stmt?,Did you translate it for you?。