Question #45320
IMPLEMENT USING PHP/MYSQL
a) Create a database and some tables
b) Insert Some Values into Table
c) Update particular field
d) Select all or specific values from the table and display using Web Browser
e) Alter the table name
f) Delete the table from the database
a) Create a database and some tables
b) Insert Some Values into Table
c) Update particular field
d) Select all or specific values from the table and display using Web Browser
e) Alter the table name
f) Delete the table from the database
Expert's answer
CREATE DATABASE shop;USE shop;CREATE TABLE products (id AUTO_INCREMENT,name text,price decimal,category text,PRIMARY KEY (id));INSERT INTO products VALUES ("Banana", 25.2, "food"), ("Apple", 2.1, "food");UPDATE products SET price = 30 WHERE ID = 1;SELECT * FROM products;ALTER TABLE products RENAME products_new;DROP TABLE products_new;
