Mysql | Insert

Check here

CREATE TABLE Customers
(
  ID int,
  Age int,
  FirstName varchar(20),
  LastName varchar(20)
);

-- Creating the Products table

CREATE TABLE Products01
(
  ID int,
  ProductName varchar(30) NOT NULL,
  Manufacturer varchar(20) NOT NULL,
  Price decimal NOT NULL,
  ProductCount int DEFAULT 0
);

CREATE TABLE Smartphones
(
  ID int,
  ProductName varchar(30) NOT NULL,
  Manufacturer varchar(20) NOT NULL,
  Price decimal NOT NULL,
  ProductCount int DEFAULT 0
);

insert specified values

INSERT INTO Customers(ID, FirstName, LastName)
VALUES ('1', 'User', 'Test');

insert values to all columns

INSERT INTO Products01
VALUES ('01', 'iPhoneX', 'Apple', 35000, 3);

insert the default value

INSERT INTO Products01(ProductName, Manufacturer, Price, ProductCount)
VALUES ('Nokia 9', 'HD Global', '41000', DEFAULT);

INSERT INTO Products01 (ProductName, Manufacturer, Price, ProductCount)
VALUES ('Nokia 9', 'HD Global', '41000', NULL);

insert a specific value

INSERT INTO Customers SET ID=2, FirstName='User2';

insert data from another table

INSERT INTO Products01 SELECT * FROM Smartphones;

INSERT INTO Products01 SELECT * FROM Smartphones WHERE Price=34000;