0% found this document useful (0 votes)

118 views18 pages

DB

The document shows SQL commands used to create databases and tables, insert sample data, and perform queries. Tables are created for customers, products, orders, and order items. Data is inserted and queries are run to view the data.

Uploaded by

Srinidhi P

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

118 views18 pages

DB

Uploaded by

Srinidhi P

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

You are on page 1/ 18

Last login: Fri Aug 18 19:17:12 on ttys008

The default interactive shell is now zsh.

To update your account to use zsh, please run `chsh -s /bin/zsh`.
For more details, please visit https://support.apple.com/kb/HT208050.
Lokranjans-MacBook-Air:~ lokranjan$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.33 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database Project;

Query OK, 1 row affected (0.01 sec)

mysql> use Project;

Database changed
mysql> CREATE TABLE Customers (
-> customer_id INT AUTO_INCREMENT PRIMARY KEY,
-> first_name VARCHAR(50),
-> last_name VARCHAR(50),
-> email VARCHAR(100),
-> address VARCHAR(255),
-> city VARCHAR(100),
-> state VARCHAR(50),
-> zip_code VARCHAR(10)
-> );
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE Products (

-> product_id INT AUTO_INCREMENT PRIMARY KEY,
-> name VARCHAR(100),
-> price DECIMAL(10, 2),
-> description TEXT
-> );
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE Orders (

-> order_id INT AUTO_INCREMENT PRIMARY KEY,
-> customer_id INT,
-> order_date DATE,
-> total_amount DECIMAL(10, 2),
-> FOREIGN KEY (customer_id) REFERENCES Customers(customer_id)
-> );
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE Order_Items (

-> order_item_id INT AUTO_INCREMENT PRIMARY KEY,
-> order_id INT,
-> product_id INT,
-> quantity INT,
-> subtotal DECIMAL(10, 2),
-> FOREIGN KEY (order_id) REFERENCES Orders(order_id),
-> FOREIGN KEY (product_id) REFERENCES Products(product_id)
-> );
Query OK, 0 rows affected (0.02 sec)

mysql> show tables;

mysql> Insert dummy data into Customers table

-> INSERT INTO Customers (first_name, last_name, email, address, city, state,
zip_code)
-> VALUES
-> ('John', 'Doe', 'john.doe@example.com', '123 Main St', 'Anytown', 'CA',
'12345'),
-> ('Jane', 'Smith', 'jane.smith@example.com', '456 Oak Ave', 'Sometown',
'NY', '67890'),
-> ('Michael', 'Johnson', 'michael.johnson@example.com', '789 Elm Rd',
'Cityville', 'TX', '54321'),
-> ('Emily', 'Lee', 'emily.lee@example.com', '101 Pine Dr', 'Townsville',
'IL', '98765'),
-> ('William', 'Wong', 'william.wong@example.com', '555 Cedar Ln',
'Villagetown', 'FL', '13579');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'data
into Customers table
INSERT INTO Customers (first_name, last_name, email, a' at line 1
mysql> INSERT INTO Customers (first_name, last_name, email, address, city, state,
zip_code)
-> VALUES
-> ('John', 'Doe', 'john.doe@example.com', '123 Main St', 'Anytown', 'CA',
'12345'),
-> ('Jane', 'Smith', 'jane.smith@example.com', '456 Oak Ave', 'Sometown',
'NY', '67890'),
-> ('Michael', 'Johnson', 'michael.johnson@example.com', '789 Elm Rd',
'Cityville', 'TX', '54321'),
-> ('Emily', 'Lee', 'emily.lee@example.com', '101 Pine Dr', 'Townsville',
'IL', '98765'),
-> ('William', 'Wong', 'william.wong@example.com', '555 Cedar Ln',
'Villagetown', 'FL', '13579');
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0

mysql> INSERT INTO Products (name, price, description)

-> VALUES
-> ('Laptop', 799.99, 'High-performance laptop with a sleek design.'),
-> ('Smartphone', 499.00, 'Latest smartphone with advanced features.'),
-> ('Headphones', 129.95, 'Noise-canceling headphones for immersive
audio.'),
-> ('Tablet', 349.50, 'Portable tablet with a high-resolution display.'),
-> ('Camera', 699.00, 'Professional DSLR camera for stunning photos.'),
-> ('Smartwatch', 199.99, 'Smartwatch with fitness tracking and
notifications.');
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0

mysql> INSERT INTO Orders (customer_id, order_date, total_amount)

-> VALUES
-> (1, '2023-07-24', 1699.97),
-> (2, '2023-07-23', 798.00),
-> (3, '2023-07-22', 977.45),
-> (4, '2023-07-21', 2248.95),
-> (5, '2023-07-20', 499.99);
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0

mysql> INSERT INTO Order_Items (order_id, product_id, quantity, subtotal)

-> VALUES
-> (1, 1, 2, 1599.98),
-> (1, 3, 1, 129.95),
-> (2, 2, 1, 499.00),
-> (3, 4, 3, 2098.50),
-> (4, 5, 1, 699.00),
-> (5, 6, 1, 199.99);
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0

mysql> desc Customers;

mysql> INSERT INTO Customers (first_name, last_name, email, address, city, state,
zip_code)
-> VALUES
-> ('Rahul', 'Kumar', 'rahul@example.com', '123 Main St', 'Mumbai', 'MH',
'400001'),
-> ('Priya', 'Sharma', 'priya@example.com', '456 Park Ave', 'Delhi', 'DL',
'110001'),
-> ('Rajesh', 'Patel', 'rajesh@example.com', '789 Oak Rd', 'Ahmedabad',
'GJ', '380001'),
-> ('Sanya', 'Gupta', 'sanya@example.com', '101 Pine Dr', 'Bangalore',
'KA', '560001'),
-> ('Manish', 'Singh', 'manish@example.com', '555 Cedar Ln', 'Kolkata',
'WB', '700001'),
-> ('Neha', 'Desai', 'neha@example.com', '888 Maple Blvd', 'Chennai', 'TN',
'600001'),
-> ('Ravi', 'Verma', 'ravi@example.com', '333 Elm St', 'Hyderabad', 'TS',
'500001'),
-> ('Anjali', 'Reddy', 'anjali@example.com', '222 Birch Ave', 'Pune', 'MH',
'411001'),
-> ('Rohit', 'Choudhury', 'rohit@example.com', '777 Oak Rd', 'Jaipur',
'RJ', '302001');
Query OK, 9 rows affected (0.00 sec)
Records: 9 Duplicates: 0 Warnings: 0

mysql> select * from Customers;

mysql> Insert into Customers

mysql> alter table Customers

-> add column zip_code int(6);
Query OK, 0 rows affected, 1 warning (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 1

mysql> select *from cutomers;

mysql> insert into customers(zip_code)

-> values()
-> values()
-> values()
-> values()
-> values()
-> values()
-> values()
-> values()
-> values()
-> values()
-> values()
-> values()
-> values()
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'values()
values()
values()
values()
values()
values()
values()
values()
values()' at line 3
mysql> insert into Customers
-> (zip_code)values(570089);
Query OK, 1 row affected (0.00 sec)

mysql> select * from Customers;

mysql> modify table Customers

-> drop row where customer_id=15;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'modify
table Customers
drop row where customer_id=15' at line 1
mysql> delte from Customers where customer_id=15;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'delte
from Customers where customer_id=15' at line 1
mysql> delete from Customers where customer_id=15;
Query OK, 1 row affected (0.01 sec)

mysql> delete from Customers where customer_id=15;

Query OK, 0 rows affected (0.00 sec)

mysql> desc Customers;

mysql> select * from Customers;

mysql> modify table Customers

-> set zip_code=570069 where customer_id=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'modify
table Customers
set zip_code=570069 where customer_id=1' at line 1
mysql> modify Customers set zip_code=570069 where customer_id=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'modify
Customers set zip_code=570069 where customer_id=1' at line 1
mysql> update Customers set zip_code=570069 where customer_id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from Customers;

mysql> update Customers set zip_code=570007 where customer_id=2;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570345 where customer_id=3;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570045 where customer_id=4;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570745 where customer_id=5;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570000 where customer_id=6;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570035 where customer_id=7;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570057 where customer_id=8;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570012 where customer_id=9;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570007 where customer_id=10;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570017 where customer_id=11;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570070 where customer_id=12;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570071 where customer_id=13;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Customers set zip_code=570008 where customer_id=14;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from Customers;

mysql> select *from products;

+------------+------------+--------
+-----------------------------------------------------+
| product_id | name | price | description
|
+------------+------------+--------
+-----------------------------------------------------+
| 1 | Laptop | 799.99 | High-performance laptop with a sleek design.
|
| 2 | Smartphone | 499.00 | Latest smartphone with advanced features.
|
| 3 | Headphones | 129.95 | Noise-canceling headphones for immersive
audio. |
| 4 | Tablet | 349.50 | Portable tablet with a high-resolution
display. |
| 5 | Camera | 699.00 | Professional DSLR camera for stunning photos.
|
| 6 | Smartwatch | 199.99 | Smartwatch with fitness tracking and
notifications. |
+------------+------------+--------
+-----------------------------------------------------+
6 rows in set (0.00 sec)

mysql> alter table products add rating;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 1
mysql> alter table products add column rating;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 1
mysql> alter table products add column rating;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 1
mysql> alter table products add column rating int(5);
Query OK, 0 rows affected, 1 warning (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 1

mysql> select * from Customers;

mysql> select * from Customers;

mysql> select * from products;

mysql> update table products set rating=3 where product_id=1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'table
products set rating=3 where product_id=1' at line 1
mysql> update products set rating=3 where product_id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from products;

mysql> update products set rating=4 where product_id=2;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update products set rating=4 where product_id=3;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update products set rating=3 where product_id=4;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update products set rating=5 where product_id=5;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update products set rating=2 where product_id=6;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from products;

+------------+------------+--------
+-----------------------------------------------------+--------+
| product_id | name | price | description
| rating |
+------------+------------+--------
+-----------------------------------------------------+--------+
| 1 | Laptop | 799.99 | High-performance laptop with a sleek design.
| 3 |
| 2 | Smartphone | 499.00 | Latest smartphone with advanced features.
| 4 |
| 3 | Headphones | 129.95 | Noise-canceling headphones for immersive
audio. | 4 |
| 4 | Tablet | 349.50 | Portable tablet with a high-resolution
display. | 3 |
| 5 | Camera | 699.00 | Professional DSLR camera for stunning photos.
| 5 |
| 6 | Smartwatch | 199.99 | Smartwatch with fitness tracking and
notifications. | 2 |
+------------+------------+--------
+-----------------------------------------------------+--------+
6 rows in set (0.00 sec)

mysql> show tables;

mysql> select * from cutomers where customer_id=(select customer_id from orders

where O;rder_id=(select order_id from Order_Items where ))
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 1
-> select * from Orders;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'rder_id=(select order_id from Order_Items where ))
select * from Orders' at line 1
mysql> select * from Orders;
+----------+-------------+------------+--------------+
| order_id | customer_id | order_date | total_amount |
+----------+-------------+------------+--------------+
| 1 | 1 | 2023-07-24 | 1699.97 |
| 2 | 2 | 2023-07-23 | 798.00 |
| 3 | 3 | 2023-07-22 | 977.45 |
| 4 | 4 | 2023-07-21 | 2248.95 |
| 5 | 5 | 2023-07-20 | 499.99 |
+----------+-------------+------------+--------------+
5 rows in set (0.00 sec)

mysql> select * from Order_Items;

mysql> select * from customers;

mysql> select * from products;

+------------+------------+--------
+-----------------------------------------------------+--------+
| product_id | name | price | description
| rating |
+------------+------------+--------
+-----------------------------------------------------+--------+
| 1 | Laptop | 799.99 | High-performance laptop with a sleek design.
| 3 |
| 2 | Smartphone | 499.00 | Latest smartphone with advanced features.
| 4 |
| 3 | Headphones | 129.95 | Noise-canceling headphones for immersive
audio. | 4 |
| 4 | Tablet | 349.50 | Portable tablet with a high-resolution
display. | 3 |
| 5 | Camera | 699.00 | Professional DSLR camera for stunning photos.
| 5 |
| 6 | Smartwatch | 199.99 | Smartwatch with fitness tracking and
notifications. | 2 |
+------------+------------+--------
+-----------------------------------------------------+--------+
6 rows in set (0.01 sec)

mysql> select first_name from Customers inner join on Orders;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'on
Orders' at line 1
mysql> select c.first_name from Customers c inner join Orders o where o.customer_id
= c.customer_id;
+------------+
| first_name |
+------------+
| John |
| Jane |
| Michael |
| Emily |
| William |
+------------+
5 rows in set (0.00 sec)

mysql> select * from orders;

+----------+-------------+------------+--------------+
| order_id | customer_id | order_date | total_amount |
+----------+-------------+------------+--------------+
| 1 | 1 | 2023-07-24 | 1699.97 |
| 2 | 2 | 2023-07-23 | 798.00 |
| 3 | 3 | 2023-07-22 | 977.45 |
| 4 | 4 | 2023-07-21 | 2248.95 |
| 5 | 5 | 2023-07-20 | 499.99 |
+----------+-------------+------------+--------------+
5 rows in set (0.00 sec)

mysql> select * from Order_items;

+---------------+----------+------------+----------+----------+
| order_item_id | order_id | product_id | quantity | subtotal |
+---------------+----------+------------+----------+----------+
| 1 | 1 | 1 | 2 | 1599.98 |
| 2 | 1 | 3 | 1 | 129.95 |
| 3 | 2 | 2 | 1 | 499.00 |
| 4 | 3 | 4 | 3 | 2098.50 |
| 5 | 4 | 5 | 1 | 699.00 |
| 6 | 5 | 6 | 1 | 199.99 |
+---------------+----------+------------+----------+----------+
6 rows in set (0.00 sec)
mysql> select select * from Customers where (select Order_id from Orders where
(select Order_id from Order_items where product_id = 1));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'select *
from Customers where (select Order_id from Orders where (select Order_i' at line 1
mysql> select * from Customers where (select Order_id from Orders where (select
Order_id from Order_items where product_id = 1));
ERROR 1242 (21000): Subquery returns more than 1 row
mysql> select first_name from Customers where (select Order_id from Orders where
(select Order_id from Order_items where product_id
= 1));
ERROR 1242 (21000): Subquery returns more than 1 row
mysql> select first_name from Customers where customer_id = (select Customer_id
from Orders where order_id = (select Order_id from O
rder_items where product_id = 1));
+------------+
| first_name |
+------------+
| John |
+------------+
1 row in set (0.01 sec)

mysql> SELECT c.customer_id, c.first_name, c.last_name, p.name AS product_name

mysql> select * from Orders order by Order_date limit 1;

mysql> sect * from customers where customer_id=(select ccustomer_id from orders

order by order_date limit=1);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'sect *
from customers where customer_id=(select ccustomer_id from orders order b' at line
1
mysql> sect * from customers where customer_id=(select customer_id from orders
order by order_date limit=1);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'sect *
from customers where customer_id=(select customer_id from orders order by' at line
1
mysql> sect * from Customers where customer_id=(select customer_id from Orders
order by Order_date limit=1);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'sect *
from Customers where customer_id=(select customer_id from Orders order by' at line
1
mysql>

MYSQL Day1
No ratings yet
MYSQL Day1
4 pages
Task 1
No ratings yet
Task 1
5 pages
April Assignment
No ratings yet
April Assignment
7 pages
Store Project - SQL
No ratings yet
Store Project - SQL
3 pages
Joins
No ratings yet
Joins
9 pages
MySQL Database and Table Errors
No ratings yet
MySQL Database and Table Errors
15 pages
Create DB Store
No ratings yet
Create DB Store
3 pages
DBMS Lab Ex 1& 2
No ratings yet
DBMS Lab Ex 1& 2
22 pages
Inventory Management
No ratings yet
Inventory Management
20 pages
Dbms Introduction
No ratings yet
Dbms Introduction
29 pages
MySQL Database and Table Creation
No ratings yet
MySQL Database and Table Creation
23 pages
Act 2
No ratings yet
Act 2
30 pages
Quiz
No ratings yet
Quiz
8 pages
Mysql Queries
No ratings yet
Mysql Queries
16 pages
My SQL File
No ratings yet
My SQL File
9 pages
SQL File-2
No ratings yet
SQL File-2
10 pages
MySQL Database Management Guide
No ratings yet
MySQL Database Management Guide
8 pages
Day 3 Dbms
No ratings yet
Day 3 Dbms
6 pages
MYSQL Warnings, String Functions
No ratings yet
MYSQL Warnings, String Functions
7 pages
BDM - CP5
No ratings yet
BDM - CP5
11 pages
Day2 Dbms Lab
No ratings yet
Day2 Dbms Lab
5 pages
2nd Assign
No ratings yet
2nd Assign
13 pages
DBMS Ass
No ratings yet
DBMS Ass
14 pages
Dbms Expt6 Delta
No ratings yet
Dbms Expt6 Delta
7 pages
DBMS Lab Manual 2020 - 21 Student Copy Updated
100% (1)
DBMS Lab Manual 2020 - 21 Student Copy Updated
59 pages
DB pr2 Ass1
No ratings yet
DB pr2 Ass1
9 pages
DBMS Practical Code
No ratings yet
DBMS Practical Code
76 pages
Q 2
No ratings yet
Q 2
2 pages
Dbms Compelete Manual
No ratings yet
Dbms Compelete Manual
43 pages
Grocery SQL
No ratings yet
Grocery SQL
3 pages
SQL Intro
No ratings yet
SQL Intro
3 pages
SQL Queries - Madhu
No ratings yet
SQL Queries - Madhu
25 pages
DBMS EXp 2
No ratings yet
DBMS EXp 2
33 pages
Code Part
No ratings yet
Code Part
42 pages
Assignment 1A
No ratings yet
Assignment 1A
13 pages
SQL DDL for Database Design
No ratings yet
SQL DDL for Database Design
9 pages
Client Master
No ratings yet
Client Master
8 pages
SQL Docx
No ratings yet
SQL Docx
57 pages
Mysqljournal - Doc VISHU004
No ratings yet
Mysqljournal - Doc VISHU004
39 pages
Mysql Assn1
No ratings yet
Mysql Assn1
3 pages
Practical No.2
No ratings yet
Practical No.2
9 pages
Assignment 6
No ratings yet
Assignment 6
11 pages
DBS Journal (2020) (E-Next - In)
No ratings yet
DBS Journal (2020) (E-Next - In)
39 pages
Best Practices For Writing MySQL Queries
No ratings yet
Best Practices For Writing MySQL Queries
17 pages
Mysql: Dr. Hsiang-Fu Yu National Taipei University of Education Original by Qunfeng Dong
No ratings yet
Mysql: Dr. Hsiang-Fu Yu National Taipei University of Education Original by Qunfeng Dong
25 pages
SQL Commands (Command Prompt)
No ratings yet
SQL Commands (Command Prompt)
3 pages
Dwmexp 1
No ratings yet
Dwmexp 1
3 pages
Group (A) - 2A
No ratings yet
Group (A) - 2A
9 pages
Ecom Merece
No ratings yet
Ecom Merece
4 pages
SQL Day 1.2
No ratings yet
SQL Day 1.2
4 pages
Online Shopping System-Database Design - Bhupal Sapkota
100% (1)
Online Shopping System-Database Design - Bhupal Sapkota
4 pages
Dbms
No ratings yet
Dbms
2 pages
Mysql Practicals
No ratings yet
Mysql Practicals
13 pages
New Text Document
No ratings yet
New Text Document
4 pages
Inuwa Printable
No ratings yet
Inuwa Printable
4 pages
Sub Query
No ratings yet
Sub Query
6 pages
Basic SQL Queries-1
No ratings yet
Basic SQL Queries-1
9 pages
MIS 406 Final Practical Assignment 2018-2!10!017
No ratings yet
MIS 406 Final Practical Assignment 2018-2!10!017
27 pages
Class #1 - Test
No ratings yet
Class #1 - Test
7 pages
Legal, Ethical, and Professional
No ratings yet
Legal, Ethical, and Professional
18 pages
(Ebook PDF) Contemporary Management 11th Edition by Gareth Jones PDF Download
100% (1)
(Ebook PDF) Contemporary Management 11th Edition by Gareth Jones PDF Download
57 pages
Manual Guide: 32-Bit High-Speed CPU V3.00
No ratings yet
Manual Guide: 32-Bit High-Speed CPU V3.00
6 pages
Venom Audio Plug-In Guide
No ratings yet
Venom Audio Plug-In Guide
10 pages
A Hybrid Approach For Mortality Prediction For Heart Patients Using ACO-HKNN 2020
No ratings yet
A Hybrid Approach For Mortality Prediction For Heart Patients Using ACO-HKNN 2020
8 pages
Unreleased Quorum Based Computations Paper
No ratings yet
Unreleased Quorum Based Computations Paper
19 pages
M Tech Thesis Guidance in Chandigarh
100% (3)
M Tech Thesis Guidance in Chandigarh
8 pages
Supervisory (AUX1, AUX2, AUX3, AUX4) Circuit Current (Ma)
No ratings yet
Supervisory (AUX1, AUX2, AUX3, AUX4) Circuit Current (Ma)
1 page
Hacker Rank
No ratings yet
Hacker Rank
44 pages
24.data Encryption Standard (DES) & The Strength of DES
No ratings yet
24.data Encryption Standard (DES) & The Strength of DES
5 pages
Powner, L.C. - Empirical Research and Writing - CH 3
No ratings yet
Powner, L.C. - Empirical Research and Writing - CH 3
26 pages
Bdwtvdytw
No ratings yet
Bdwtvdytw
11 pages
WGS345 Pre Lab 6
No ratings yet
WGS345 Pre Lab 6
4 pages
It Paper 12TH 2025-26
No ratings yet
It Paper 12TH 2025-26
2 pages
Algorithmic Forex Trading Using Combination of Numeric Time Series and News Analysis
No ratings yet
Algorithmic Forex Trading Using Combination of Numeric Time Series and News Analysis
5 pages
E-Freelancing System Report
No ratings yet
E-Freelancing System Report
27 pages
Email Services
No ratings yet
Email Services
16 pages
LP Ventilator Mekanik
No ratings yet
LP Ventilator Mekanik
51 pages
Formats For The Geoid Models: Content
No ratings yet
Formats For The Geoid Models: Content
7 pages
24-Analog Electronic Filters - Hercules G. Dimopoulos
No ratings yet
24-Analog Electronic Filters - Hercules G. Dimopoulos
9 pages
Launcher Log
No ratings yet
Launcher Log
506 pages
Corporate Governance Practices-Final Project
No ratings yet
Corporate Governance Practices-Final Project
58 pages
Os Lab Manual
No ratings yet
Os Lab Manual
36 pages
2 Joystick Remote Controller Document-06!10!24
No ratings yet
2 Joystick Remote Controller Document-06!10!24
24 pages
Ultimate Photoshop Training: From Beginner To Pro: WORKBOOK - Section 1
No ratings yet
Ultimate Photoshop Training: From Beginner To Pro: WORKBOOK - Section 1
7 pages
What Is LILO and GRUB Linux Boot Loader
No ratings yet
What Is LILO and GRUB Linux Boot Loader
2 pages
DSA Lab Report 10 Anas Zohrab
No ratings yet
DSA Lab Report 10 Anas Zohrab
7 pages
NM Project Final 820322104008
No ratings yet
NM Project Final 820322104008
16 pages
Ceragon IP-20 Split-Mount Release Notes 12.0 Rev A.02
No ratings yet
Ceragon IP-20 Split-Mount Release Notes 12.0 Rev A.02
126 pages

DB

Uploaded by

DB

Uploaded by

Last login: Fri Aug 18 19:17:12 on ttys008

The default interactive shell is now zsh.

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its

mysql> create database Project;

mysql> use Project;

mysql> CREATE TABLE Products (

mysql> CREATE TABLE Orders (

mysql> CREATE TABLE Order_Items (

mysql> show tables;

mysql> Insert dummy data into Customers table

mysql> INSERT INTO Products (name, price, description)

mysql> INSERT INTO Orders (customer_id, order_date, total_amount)

mysql> INSERT INTO Order_Items (order_id, product_id, quantity, subtotal)

mysql> desc Customers;

mysql> select * from Customers;

mysql> Insert into Customers

mysql> alter table Customers

mysql> select *from cutomers;

mysql> insert into customers(zip_code)

mysql> select * from Customers;

mysql> modify table Customers

mysql> delete from Customers where customer_id=15;

mysql> desc Customers;

mysql> select * from Customers;

mysql> modify table Customers

mysql> select * from Customers;

mysql> update Customers set zip_code=570007 where customer_id=2;

mysql> update Customers set zip_code=570345 where customer_id=3;

mysql> update Customers set zip_code=570045 where customer_id=4;

mysql> update Customers set zip_code=570745 where customer_id=5;

mysql> update Customers set zip_code=570000 where customer_id=6;

mysql> update Customers set zip_code=570035 where customer_id=7;

mysql> update Customers set zip_code=570057 where customer_id=8;

mysql> update Customers set zip_code=570012 where customer_id=9;

mysql> update Customers set zip_code=570007 where customer_id=10;

mysql> update Customers set zip_code=570017 where customer_id=11;

mysql> update Customers set zip_code=570070 where customer_id=12;

mysql> update Customers set zip_code=570071 where customer_id=13;

mysql> update Customers set zip_code=570008 where customer_id=14;

mysql> select * from Customers;

mysql> select *from products;

mysql> alter table products add rating;

mysql> select * from Customers;

mysql> select * from Customers;

mysql> select * from products;

mysql> update table products set rating=3 where product_id=1;

mysql> select * from products;

mysql> update products set rating=4 where product_id=2;

mysql> update products set rating=4 where product_id=3;

mysql> update products set rating=3 where product_id=4;

mysql> update products set rating=5 where product_id=5;

mysql> select * from products;

mysql> show tables;

mysql> select * from cutomers where customer_id=(select customer_id from orders

mysql> select * from Order_Items;

mysql> select * from customers;

mysql> select * from products;

mysql> select first_name from Customers inner join on Orders;

mysql> select * from orders;

mysql> select * from Order_items;

mysql> SELECT c.customer_id, c.first_name, c.last_name, p.name AS product_name

mysql> select * from Orders order by Order_date limit 1;

mysql> sect * from customers where customer_id=(select ccustomer_id from orders

You might also like