Skip to content

Mysql | Insert

Check here

MySQL
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
MySQL
INSERT INTO Customers(ID, FirstName, LastName)
VALUES ('1', 'User', 'Test');
  • insert values to all columns
MySQL
INSERT INTO Products01
VALUES ('01', 'iPhoneX', 'Apple', 35000, 3);
  • insert the default value
MySQL
INSERT INTO Products01(ProductName, Manufacturer, Price, ProductCount)
VALUES ('Nokia 9', 'HD Global', '41000', DEFAULT);
MySQL
INSERT INTO Products01 (ProductName, Manufacturer, Price, ProductCount)
VALUES ('Nokia 9', 'HD Global', '41000', NULL);
  • insert a specific value
MySQL
INSERT INTO Customers SET ID=2, FirstName='User2';
  • insert data from another table
MySQL
INSERT INTO Products01 SELECT * FROM Smartphones;
MySQL
INSERT INTO Products01 SELECT * FROM Smartphones WHERE Price=34000;