Sql Programming Tutorials, Guides & Best Practices

Then you'll need to restart MySQL:

sudo systemctl restart mysql

Find the line:

datadir = /var/lib/mysql

Begin by updating your package index to ensure you have the latest information on available packages:

sudo apt update

No preview available for this content.

• JSON_EXTRACT(order_details, '$.quantity'): Extracts the value of the quantity key from the JSON order_details column.
• JSON_UNQUOTE(...): Removes any quotes from the extracted JSON value.
• CAST(... AS UNSIGNED): Converts the extracted value to an unsigned integer to allow for summation.
• SUM(...): Sums all the quantities across the rows.

When you run the above query, MySQL will return the total quantity of products ordered by all customers: