Pasted

 
 
No, Product Id, Product Url, Product Name, Brand, Category level 1, Category level 2, Category level 3, Price, Discount Price, Color, Availability, Gender, Image link 1, Image link 2, Image link 3, Affiliate, Link Affiliate
 
 
 
SELECT no, nama, alamat, url
FROM
(
    SELECT * from table1
    UNION ALL
    SELECT * from table2
) t
ORDER BY no ASC
 
 
 
Select * from bukalapak UNION select * FROM tokopedia
 
ALTER TABLE bukalapak DROP COLUMN No;
 
 
ALTER TABLE all_column ADD No bigint(20);
 
ALTER TABLE bukalapak,tokopedia,blibli,mataharimall,thechildrenstore DROP COLUMN No;
 
 
CREATE TABLE newcolumn as
Select * from bukalapak,tokopedia,blibli,mataharimall,thechildrenstore UNION select * FROM bukalapak,tokopedia,blibli,mataharimall,thechildrenstore
 
 
UPDATE all_column
JOIN (SELECT @rank := 0) r
SET No=@rank:=@rank+1;
 
ALTER TABLE bukalapak ADD No int IDENTITY(1, 2) NOT NULL
ALTER TABLE bukalapak ADD (No char(30);
ALTER TABLE bukalapak ADD No VARCHAR2(20) DEFAULT 'N';
ALTER TABLE table_name ADD column_name varchar2(1) DEFAULT 'N' not null;
 
SELECT nama_tabel_tampil   .   nama_kolom_tampil FROM nama_tabel_pertama INNER JOIN nama_tabel_kedua ON nama_tabel_pertama . kolom_penghubung = nama_tabel_kedua . kolom_penghubung ;
 
 
SELECT * 
FROM bukalapak INNER JOIN tokopedia
ON (tokopedia.Product Id, tokopedia.Product Url, .tokopedia.Product Name, tokopedia.Brand, tokopedia.Category level 1, tokopedia.Category level 2, tokopedia.Category level 3, tokopedia.Price, tokopedia.Discount Price, tokopedia.Color, tokopedia.Availability, tokopedia.Gender, tokopedia.Image link 1, tokopedia.Image link 2, tokopedia.Image link 3, tokopedia.Affiliate, tokopedia.Link Affiliate)=(bukalapak.Product Id, bukalapak.Product Url, .bukalapak.Product Name, bukalapak.Brand, bukalapak.Category level 1, bukalapak.Category level 2, bukalapak.Category level 3, bukalapak.Price, bukalapak.Discount Price, bukalapak.Color, bukalapak.Availability, bukalapak.Gender, bukalapak.Image link 1, bukalapak.Image link 2, bukalapak.Image link 3, bukalapak.Affiliate, bukalapak.Link Affiliate)
 
 
 
SELECT ROW_NUMBER() OVER (ORDER BY "Product Id" ASC) AS No, Product Id, Product Url, Product Name, Brand, "Category level 1", "Category level 2", "Category level 3", Price, Discount Price, Color, Availability, Gender, "Image link 1", "Image link 2", "Image link 3", Affiliate, Link Affiliate
FROM tokopedia
 
UPDATE produk SET `slug` = `Product Name`
 
To add primary key in the column.
 
ALTER TABLE table_name ADD PRIMARY KEY (column_name);
To remove primary key from the table.
 
ALTER TABLE table_name DROP PRIMARY KEY;
 
UPDATE table SET field1 = field2