Geek Slack

Become an instructor

Start creating your course and become a part of GeekSlack.

Login
Facebook Linkedin
Course Content
MySQL
0/33
MySQL Basics
00:00
MySQL SELECT
00:00
MySQL WHERE
00:00
MySQL AND, OR & NOT
00:00
MySQL ORDER BY
00:00
MySQL INSERT INTO
00:00
MySQL NULL
00:00
MySQL UPDATE
00:00
MySQL DELETE
00:00
MySQL LIMIT
00:00
MySQL MIN() and MAX()
00:00
MySQL COUNT, AVG and SUM
00:00
MySQL LIKE
00:00
MySQL Wildcards
00:00
MySQL IN
00:00
MySQL BETWEEN
00:00
MySQL Aliases
00:00
MySQL Joins
00:00
MySQL INNER JOIN
00:00
MySQL LEFT JOIN
00:00
MySQL RIGHT JOIN
00:00
MySQL CROSS JOIN
00:00
MySQL Self Join
00:00
MySQL UNION
00:00
MYSQL GROUP BY
00:00
MySQL HAVING Clause
00:00
MySQL EXISTS
00:00
MySQL ANY, ALL
00:00
MySQL INSERT INTO
00:00
MySQL CASE Statement
00:00
MySQL NULL Functions
00:00
MySQL Comments
00:00
MySQL Operators
00:00
My SQL Tutorial



    MySQL UPDATE Statement


    MySQL UPDATE Statement

    The UPDATE statement in MySQL is used to modify existing records in a table.

    Basic Syntax:

    Example: Basic UPDATE Syntax

    UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

    This SQL command updates existing records in table_name by setting values for specified columns (column1, column2, …) based on a specified condition.

    Example Using UPDATE:

    Example: Updating Data

    UPDATE users
SET email = 'newemail@example.com'
WHERE user_id = 1;

    This SQL command updates the email of the user with user_id 1 in the users table to newemail@example.com.

    Updating Multiple Columns:

    Example: Updating Multiple Columns

    UPDATE products
SET price = price * 1.1,
    stock = stock - 1
WHERE product_id = 101;

    This SQL command updates the price of the product with product_id 101 in the products table by increasing it by 10% and decreases the stock by 1.

    Updating All Rows:

    Example: Updating All Rows

    UPDATE orders
SET status = 'Cancelled';

    This SQL command updates the status column of all rows in the orders table to 'Cancelled', effectively cancelling all orders.

    Conclusion

    The UPDATE statement in MySQL allows for the modification of existing records in database tables, providing flexibility in updating specific columns or entire rows based on specified conditions.

    Previous
    Next