Answers for "combine a column with another table mysql"

SQL
0

how to combine 2 tables in MySQL

create table yourTableName
(
   select *from yourTableName1
)
UNION
(
   select *from yourTableName2
);
Posted by: Guest on October-20-2020
0

how to add more columns to a table in mysql

CREATE TABLE IF NOT EXISTS vendors (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);
ALTER TABLE vendors
ADD COLUMN phone VARCHAR(15) AFTER name;
Posted by: Guest on March-16-2021

Code answers related to "combine a column with another table mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language