INSERT Basics: A Beginner’s Hands‑On Guide to Adding Data

INSERT is the first step of CRUD, used to add new rows to a table. The article presents two syntax styles: specifying columns (recommended for beginners because it is flexible and less error‑prone) and inserting all fields (not recommended since schema changes cause errors).

Typical use cases include adding new users, orders, or products, bulk‑loading test data, and initializing core business data.

Practical example (UserInfo table)

Single‑row insertion (column‑specified):

INSERT INTO UserInfo(UserName,Phone,Age)
VALUES ('张三','13800138000',25);
GO

Batch insertion (multiple rows):

INSERT INTO UserInfo(UserName,Phone,Age)
VALUES
('李四','13900139000',28),
('王五','13700137000',22),
('赵六','13600136000',30);
GO

Beginner pitfalls

The order of columns must exactly match the order of values.

String literals, text, and phone numbers must be enclosed in single quotes; numeric values do not require quotes.

Auto‑increment primary key IDs should not be supplied manually; the system generates them automatically.