perintah sql

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