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: , ,

UPDATE

To update data in a table, you can use the UPDATE statement. You need to specify the name of the table, the columns that you want to update, and the new values. You can also use a WHERE clause to specify which rows you want to update. For example, this code updates the email column of the customer’s table with the value ‘bob@example.com’ where the id column is equal to 2.

SQL
SQL
SQL
UPDATE customers
SET email = 'bob@example.com'
WHERE id = 2;

1 row affected. (Query took 0.0006 seconds.)

Next Tutorial

DELETE
UPDATE customers SET email = ‘bob@example.com’ WHERE id = 2;

Next Tutorial

DELETE

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 !!