Patulong naman akooooo
Great! Let's start by creating a database to store the information about vehicles, people, and countries. You can use the following SQL statements to create the necessary tables:Vehicles, people, country
CREATE DATABASE menu_db;
USE menu_db;
CREATE TABLE vehicles (
id INT PRIMARY KEY AUTO_INCREMENT,
brand VARCHAR(100),
model VARCHAR(100),
year INT,
price DECIMAL(10,2)
);
CREATE TABLE people (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100),
age INT,
gender VARCHAR(10)
);
CREATE TABLE countries (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100),
capital VARCHAR(100),
population INT
);
vehicles
, people
, and countries
, each...Pagawa ng menu sa MySQLTulungan kita! Ano ba ang kailangan mo?
Sure! I'd be happy to help you create a menu in MySQL. Can you provide more details on what you want the menu to include? Do you have a specific table structure in mind?Pagawa ng menu sa MySQL
Vehicles, people, countrySure! I'd be happy to help you create a menu in MySQL. Can you provide more details on what you want the menu to include? Do you have a specific table structure in mind?
Great! Let's start by creating a database to store the information about vehicles, people, and countries. You can use the following SQL statements to create the necessary tables:Vehicles, people, country
CREATE DATABASE menu_db;
USE menu_db;
CREATE TABLE vehicles (
id INT PRIMARY KEY AUTO_INCREMENT,
brand VARCHAR(100),
model VARCHAR(100),
year INT,
price DECIMAL(10,2)
);
CREATE TABLE people (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100),
age INT,
gender VARCHAR(10)
);
CREATE TABLE countries (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100),
capital VARCHAR(100),
population INT
);
vehicles
, people
, and countries
, each with their respective columns.INSERT INTO vehicles (brand, model, year, price) VALUES
('Toyota', 'Camry', 2018, 25000),
('Honda', 'Civic', 2019, 22000),
('Ford', 'Mustang', 2020, 40000);
INSERT INTO people (name, age, gender) VALUES
('John Doe', 30, 'Male'),
('Jane Smith', 25, 'Female'),
('Robert Johnson', 40, 'Male');
INSERT INTO countries (name, capital, population) VALUES
('USA', 'Washington D.C.', 328200000),
('Canada', 'Ottawa', 37360000),
('Australia', 'Canberra', 25690000);