Patulooooong pleaseeeee pagawa ng car menu sa MySQL
CREATE DATABASE car_menu;
USE car_menu;
CREATE TABLE cars (
id INT PRIMARY KEY AUTO_INCREMENT,
brand VARCHAR(255) NOT NULL,
model VARCHAR(255) NOT NULL,
year INT NOT NULL,
price DECIMAL(10, 2) NOT NULL,
mileage INT NOT NULL
);
id
: A unique identifier for each car.brand
: The brand or manufacturer of the car.model
: The model name of the car.year
: The manufacturing year of the car.price
: The price of the car.mileage
: The number of miles the car has been driven.INSERT INTO cars (brand, model, year, price, mileage)
VALUES
('Toyota', 'Camry', 2015, 15000.50, 50000),
('Honda', 'Civic', 2018, 18000.00, 30000),
('Ford', 'Mustang', 2020, 40000.75, 10000);
INSERT INTO
statements.SELECT * FROM cars;