Answer to Question #45320 in Databases | SQL | Oracle | MS Access for Asha N

Question

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

Answer 1

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;