Sanket Jain Posted April 2, 2019 Share Posted April 2, 2019 Hello, Milk is a basic commodity and I request to add it under beverages column. Table name is Categories and it is a SQL database of W3Schools. Link to comment Share on other sites More sharing options...
Funce Posted April 3, 2019 Share Posted April 3, 2019 Good suggestion. Though, I believe that the beverages description column is describing possible examples of beverages, and isn't meant to be taken as an exhaustive list. Of course, you could always give it a shot in the try-it and see your own update! (Until reset) https://www.w3schools.com/sql/trysql.asp?filename=trysql_asc Try something like this: UPDATE Categories SET Description = "Soft drinks, coffees, teas, milk, beers, and ales" WHERE CategoryName = "Beverages" Then run this to see your handiwork SELECT * FROM Categories Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now