你即將離開本站

並前往https://www.daniweb.com/programming/databases/threads/369353/insert-with-select-and-values

INSERT with SELECT and VALUES - mysql - DaniWeb

I am not sure what you mean by "A value that I choose" but there are several ways. Here is an example from the mysql cookbook that should do ...

確定！ 回上一頁

查詢 「MySQL INSERT SELECT」的人也找了：

  1. MySQL INSERT SELECT
    2.
  2. insert into select用法
    3.
  3. Mysql insert value from select
    4.
  4. INSERT INTO SELECT JOIN
    5.
  5. INSERT INTO VALUES SELECT
    6.
  6. SELECT INTO
    7.
  7. INSERT SELECT Oracle
    8.
  8. SQL INSERT INTO multiple rows
    9.