We are adding a column to table with the help of alter table.
ALTER TABLE table_name ADD column_name datatype;
We fetching all records or data from customers table at where city is london and country is uk with the help of AND operator.
SELECT * FROM Customers WHERE City = "London" AND Country = "UK";
We fetching all records or data from products table at where price is any given prices with the help of ANY operator.
SELECT * FROM Products WHERE Price > ANY (SELECT Price FROM Products WHERE Price > 50);
We are doing delete or drop column from table with the help of alter table.
ALTER TABLE table_name DROP COLUMN column_name;
We modifying column in users table.
ALTER TABLE users MODIFY COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
We renaming column.
ALTER TABLE table_name RENAME COLUMN old_name to new_name;