Distinctive Analytics

A Place to enhance your analytical skills

SQL CRUD basics in 5 mins

Distinctive Analytics > Blog > Lessons > SQL CRUD basics in 5 mins

Learn SQL CRUD basics and Here’s a fast overview of how to utilize them in 5 minutes.

Topics: , ,

INSERT

To insert data into a table, you can use the INSERT INTO statement. You need to specify the name of the table, the columns that you want to insert values into, and the values themselves. For example, this code inserts a new row into the customers table with the values 1, ‘Alice’, ‘alice@example.com’, and ‘1234567890’.

SQL
SQL
SQL
INSERT INTO customers (id, name, email, phone)
VALUES (1, 'Alice', 'alice@example.com', '1234567890');

INSERT INTO customers (id, name, email, phone)
VALUES (2, 'Bob', 'bob@example.com', '9876543210');

1 row inserted. (Query took 0.0011 seconds.)

Next Tutorial

SELECT
INSERT INTO customers (id, name, email, phone) VALUES (1, ‘Alice’, ‘alice@example.com’, ‘1234567890’); INSERT INTO customers (id, name, email, phone) VALUES (2, ‘Bob’, ‘bob@example.com’, ‘9876543210’);

Next Tutorial

SELECT

Pages: 1 2 3 4 5

How useful was this post?

Click on a star to rate it!

Facebook
Instagram
WhatsApp
error: Content is protected !!