Answers for "insert data into table mysql"

SQL
2

insert into table from another table mysql

INSERT INTO table1 (emp_id, fname)
SELECT emp_id, fname 
FROM table2
WHERE status = 'Active';
Posted by: Guest on May-31-2020
0

insert into mysql

INSERT INTO "table_name" ("column1", "column2", "column3", ...)
VALUES ('value1', "value2", 'value3', ...);
Posted by: Guest on May-02-2021

Code answers related to "insert data into table mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language