MySQL INSERT statement

1.value and Values Differences

There is no grammatical difference between the two, the difference is only the execution time.

After testing, you can find that the values insert a single line faster, and value inserts multiple lines faster.

The 2.insert statement has no value usage:

The plus value is a fixed value insert, not a dynamic insert, and is usually used with select.

　　

Insert into Imagetable_upload (ImageID) Select ImageID from ImageTable im, (    select Seriesid from seriestable S,    ( Select CustomerID from customerinfo where CustomerName = ' Lin Mei-ling ') c     where S.customerid = C.customerid) Sswhere im.series ID = Ss.seriesid

MySQL INSERT statement