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

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
1
Expert's answer
2014-08-27T09:33:59-0400
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;

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

Assignment Expert
28.08.14, 12:30

Dear visitor, Do you have any errors in the output?

Asha N
28.08.14, 08:15

please can you provide the out put screenshot for the above answer

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS