Search
Search

Insert new rows into table that's connected to another table on Database

debugcn Published at Dev
13
user123456789

I have two tables in a Database: Menu and Companies. Both are connected by the CompanyID. In the company table there are nearly 100 rows of information on different companies. I can insert one row into the Menu table by this sql query:

INSERT INTO `menu` (`CompanyID`, `MenuName`, `MenuLink`, `ImageLink`,
`ListOrder`, `Popup`, `ParentMenuID`, `IsActive`, `IsAdmin`) VALUES
('11', 'Holidays', 'lookups/Holidays.aspx', 'images/Archive.png', '11',
'1', '1807', '1', '0');

I set the CompanyID to 11 here. But I don't want to do an insert query for each CompanyID so if there a way to insert for all the companies?

Randy 
INSERT INTO menu (CompanyID
, MenuName
, MenuLink
, ImageLink
, ListOrder
, Popup
, ParentMenuID
, IsActive
, IsAdmin) 
SELECT CompanyID
, 'Holidays'
, 'lookups/Holidays.aspx'
, 'images/Archive.png'
, '11'
, '1'
, '1807'
, '1'
, '0'
FROM companies

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Insert multiple rows in one table based on number in another table

From Dev

Create a Trigger to insert a rows in another table

From Dev

Creating a trigger on insert on a table, that creates new rows on another table, according to amount of row on another (3rd) table

From Dev

How to insert rows in another table based on insert in first table

From Dev

SQL - Insert new row into an existing table based on another table entry

From Dev

Insert multiple rows into a MySQL database from a table

From Dev

Insert multiple rows from select into another table

From Dev

Insert new rows into table that's connected to another table on Database

From Dev

JQuery clear HTML table and insert new rows

From Dev

PDO Insert query in table in another database not working

From Dev

Insert and update from table in tmp database to table in another database

From Dev

Insert (multiple) new rows into a table from another table using a subquery?

From Dev

insert multiple rows mysql from another table

From Dev

Insert values of one table in a database to another table in another database

From Dev

How to insert into a table new records based on info from another table?

From Dev

How to insert multiple rows into one table for each id of another table

From Dev

Insert and update from table in tmp database to table in another database

From Dev

Insert many rows from a table into one unique row in another table

From Dev

Update, Insert and Delete rows in a table based on changes in another table

From Dev

Insert new rows into table but copy data from another row in the table

From Dev

How to check if new rows is insert in specific table

From Dev

Select rows conditionally and insert into another table conditionally

From Dev

How to use SQL TRIGGER to insert rows from another table into a new one?

From Dev

Insert from one Database table to another Database table in ANDROID

From Dev

laravel 5.3 - multiple rows insert to database table

From Dev

mysql insert into table select from another database

From Dev

SQL Insert new columns in table B from rows of table A

From Dev

Insert specific rows from one table in database into another with different columns

From Dev

How to insert one row of a table into two rows of another table

Related Related

  1. 1

    Insert multiple rows in one table based on number in another table

  2. 2

    Create a Trigger to insert a rows in another table

  3. 3

    Creating a trigger on insert on a table, that creates new rows on another table, according to amount of row on another (3rd) table

  4. 4

    How to insert rows in another table based on insert in first table

  5. 5

    SQL - Insert new row into an existing table based on another table entry

  6. 6

    Insert multiple rows into a MySQL database from a table

  7. 7

    Insert multiple rows from select into another table

  8. 8

    Insert new rows into table that's connected to another table on Database

  9. 9

    JQuery clear HTML table and insert new rows

  10. 10

    PDO Insert query in table in another database not working

  11. 11

    Insert and update from table in tmp database to table in another database

  12. 12

    Insert (multiple) new rows into a table from another table using a subquery?

  13. 13

    insert multiple rows mysql from another table

  14. 14

    Insert values of one table in a database to another table in another database

  15. 15

    How to insert into a table new records based on info from another table?

  16. 16

    How to insert multiple rows into one table for each id of another table

  17. 17

    Insert and update from table in tmp database to table in another database

  18. 18

    Insert many rows from a table into one unique row in another table

  19. 19

    Update, Insert and Delete rows in a table based on changes in another table

  20. 20

    Insert new rows into table but copy data from another row in the table

  21. 21

    How to check if new rows is insert in specific table

  22. 22

    Select rows conditionally and insert into another table conditionally

  23. 23

    How to use SQL TRIGGER to insert rows from another table into a new one?

  24. 24

    Insert from one Database table to another Database table in ANDROID

  25. 25

    laravel 5.3 - multiple rows insert to database table

  26. 26

    mysql insert into table select from another database

  27. 27

    SQL Insert new columns in table B from rows of table A

  28. 28

    Insert specific rows from one table in database into another with different columns

  29. 29

    How to insert one row of a table into two rows of another table

HotTag

Archive