queries.sql

init.sql

lab_5

queries.sql

init.sql

STDIN

Output:

+---------+--------------------+
| su_id   | su_name            |
+---------+--------------------+
| CSCI015 | Intro to Computing |
+---------+--------------------+
+----------+----------+---------+----------+----------+
| i_fname  | i_lname  | su_id   | s_stime  | s_etime  |
+----------+----------+---------+----------+----------+
| Dibu     | Martinez | CSIT115 | 12:30:00 | 00:00:00 |
| Dani     | Junior   | CSIT115 | 12:30:00 | 00:00:00 |
| Donia    | Akbar    | CSIT115 | 12:30:00 | 00:00:00 |
| Carlos   | Artour   | CSIT115 | 12:30:00 | 00:00:00 |
| Chritine | Diaz     | CSIT115 | 12:30:00 | 00:00:00 |
| Afrah    | Ahmed    | CSIT115 | 12:30:00 | 00:00:00 |
| Abdullah | Omar     | CSIT115 | 12:30:00 | 00:00:00 |
| Asma     | Hassan   | CSIT115 | 12:30:00 | 00:00:00 |
| Dibu     | Martinez | CSIT115 | 14:30:00 | 00:00:00 |
| Dani     | Junior   | CSIT115 | 14:30:00 | 00:00:00 |
| Donia    | Akbar    | CSIT115 | 14:30:00 | 00:00:00 |
| Carlos   | Artour   | CSIT115 | 14:30:00 | 00:00:00 |
| Chritine | Diaz     | CSIT115 | 14:30:00 | 00:00:00 |
| Afrah    | Ahmed    | CSIT115 | 14:30:00 | 00:00:00 |
| Abdullah | Omar     | CSIT115 | 14:30:00 | 00:00:00 |
| Asma     | Hassan   | CSIT115 | 14:30:00 | 00:00:00 |
| Dibu     | Martinez | CSCI316 | 13:30:00 | 00:00:00 |
| Dani     | Junior   | CSCI316 | 13:30:00 | 00:00:00 |
| Donia    | Akbar    | CSCI316 | 13:30:00 | 00:00:00 |
| Carlos   | Artour   | CSCI316 | 13:30:00 | 00:00:00 |
| Chritine | Diaz     | CSCI316 | 13:30:00 | 00:00:00 |
| Afrah    | Ahmed    | CSCI316 | 13:30:00 | 00:00:00 |
| Abdullah | Omar     | CSCI316 | 13:30:00 | 00:00:00 |
| Asma     | Hassan   | CSCI316 | 13:30:00 | 00:00:00 |
| Dibu     | Martinez | CSCI317 | 13:30:00 | 00:00:00 |
| Dani     | Junior   | CSCI317 | 13:30:00 | 00:00:00 |
| Donia    | Akbar    | CSCI317 | 13:30:00 | 00:00:00 |
| Carlos   | Artour   | CSCI317 | 13:30:00 | 00:00:00 |
| Chritine | Diaz     | CSCI317 | 13:30:00 | 00:00:00 |
| Afrah    | Ahmed    | CSCI317 | 13:30:00 | 00:00:00 |
| Abdullah | Omar     | CSCI317 | 13:30:00 | 00:00:00 |
| Asma     | Hassan   | CSCI317 | 13:30:00 | 00:00:00 |
| Dibu     | Martinez | MARK101 | 12:30:00 | 00:00:00 |
| Dani     | Junior   | MARK101 | 12:30:00 | 00:00:00 |
| Donia    | Akbar    | MARK101 | 12:30:00 | 00:00:00 |
| Carlos   | Artour   | MARK101 | 12:30:00 | 00:00:00 |
| Chritine | Diaz     | MARK101 | 12:30:00 | 00:00:00 |
| Afrah    | Ahmed    | MARK101 | 12:30:00 | 00:00:00 |
| Abdullah | Omar     | MARK101 | 12:30:00 | 00:00:00 |
| Asma     | Hassan   | MARK101 | 12:30:00 | 00:00:00 |
| Dibu     | Martinez | MARK101 | 12:30:00 | 00:00:00 |
| Dani     | Junior   | MARK101 | 12:30:00 | 00:00:00 |
| Donia    | Akbar    | MARK101 | 12:30:00 | 00:00:00 |
| Carlos   | Artour   | MARK101 | 12:30:00 | 00:00:00 |
| Chritine | Diaz     | MARK101 | 12:30:00 | 00:00:00 |
| Afrah    | Ahmed    | MARK101 | 12:30:00 | 00:00:00 |
| Abdullah | Omar     | MARK101 | 12:30:00 | 00:00:00 |
| Asma     | Hassan   | MARK101 | 12:30:00 | 00:00:00 |
| Dibu     | Martinez | ACCY101 | 10:30:00 | 00:00:00 |
| Dani     | Junior   | ACCY101 | 10:30:00 | 00:00:00 |
| Donia    | Akbar    | ACCY101 | 10:30:00 | 00:00:00 |
| Carlos   | Artour   | ACCY101 | 10:30:00 | 00:00:00 |
| Chritine | Diaz     | ACCY101 | 10:30:00 | 00:00:00 |
| Afrah    | Ahmed    | ACCY101 | 10:30:00 | 00:00:00 |
| Abdullah | Omar     | ACCY101 | 10:30:00 | 00:00:00 |
| Asma     | Hassan   | ACCY101 | 10:30:00 | 00:00:00 |
| Dibu     | Martinez | ACCY101 | 10:30:00 | 00:00:00 |
| Dani     | Junior   | ACCY101 | 10:30:00 | 00:00:00 |
| Donia    | Akbar    | ACCY101 | 10:30:00 | 00:00:00 |
| Carlos   | Artour   | ACCY101 | 10:30:00 | 00:00:00 |
| Chritine | Diaz     | ACCY101 | 10:30:00 | 00:00:00 |
| Afrah    | Ahmed    | ACCY101 | 10:30:00 | 00:00:00 |
| Abdullah | Omar     | ACCY101 | 10:30:00 | 00:00:00 |
| Asma     | Hassan   | ACCY101 | 10:30:00 | 00:00:00 |
| Dibu     | Martinez | MARK303 | 09:30:00 | 00:00:00 |
| Dani     | Junior   | MARK303 | 09:30:00 | 00:00:00 |
| Donia    | Akbar    | MARK303 | 09:30:00 | 00:00:00 |
| Carlos   | Artour   | MARK303 | 09:30:00 | 00:00:00 |
| Chritine | Diaz     | MARK303 | 09:30:00 | 00:00:00 |
| Afrah    | Ahmed    | MARK303 | 09:30:00 | 00:00:00 |
| Abdullah | Omar     | MARK303 | 09:30:00 | 00:00:00 |
| Asma     | Hassan   | MARK303 | 09:30:00 | 00:00:00 |
| Dibu     | Martinez | CSCI127 | 09:30:00 | 00:00:00 |
| Dani     | Junior   | CSCI127 | 09:30:00 | 00:00:00 |
| Donia    | Akbar    | CSCI127 | 09:30:00 | 00:00:00 |
| Carlos   | Artour   | CSCI127 | 09:30:00 | 00:00:00 |
| Chritine | Diaz     | CSCI127 | 09:30:00 | 00:00:00 |
| Afrah    | Ahmed    | CSCI127 | 09:30:00 | 00:00:00 |
| Abdullah | Omar     | CSCI127 | 09:30:00 | 00:00:00 |
| Asma     | Hassan   | CSCI127 | 09:30:00 | 00:00:00 |
| Dibu     | Martinez | FIN015  | 15:30:00 | 00:00:00 |
| Dani     | Junior   | FIN015  | 15:30:00 | 00:00:00 |
| Donia    | Akbar    | FIN015  | 15:30:00 | 00:00:00 |
| Carlos   | Artour   | FIN015  | 15:30:00 | 00:00:00 |
| Chritine | Diaz     | FIN015  | 15:30:00 | 00:00:00 |
| Afrah    | Ahmed    | FIN015  | 15:30:00 | 00:00:00 |
| Abdullah | Omar     | FIN015  | 15:30:00 | 00:00:00 |
| Asma     | Hassan   | FIN015  | 15:30:00 | 00:00:00 |
| Dibu     | Martinez | CSCI316 | 15:30:00 | 00:00:00 |
| Dani     | Junior   | CSCI316 | 15:30:00 | 00:00:00 |
| Donia    | Akbar    | CSCI316 | 15:30:00 | 00:00:00 |
| Carlos   | Artour   | CSCI316 | 15:30:00 | 00:00:00 |
| Chritine | Diaz     | CSCI316 | 15:30:00 | 00:00:00 |
| Afrah    | Ahmed    | CSCI316 | 15:30:00 | 00:00:00 |
| Abdullah | Omar     | CSCI316 | 15:30:00 | 00:00:00 |
| Asma     | Hassan   | CSCI316 | 15:30:00 | 00:00:00 |
+----------+----------+---------+----------+----------+
+-----------------------+-----------+
| su_name               | su_prereq |
+-----------------------+-----------+
| Intro to Accounting   | NULL      |
| Intro to Computing    | NULL      |
| Security              | NULL      |
| Big Data Applications | CSIT115   |
| Database Perfromance  | CSIT115   |
| Database Management   | NULL      |
| Intro to Finance      | ACCY101   |
| Intro to Marketing    | NULL      |
| Market Analysis       | MARK101   |
+-----------------------+-----------+
+-------------+---------------+
| i_email     | full name     |
+-------------+---------------+
| amd@uow.com | Asma Hassan   |
| af@uow.com  | Afrah Ahmed   |
| cld@uow.com | Chritine Diaz |
| dma@uow.com | Donia Akbar   |
+-------------+---------------+
+-----------+
| Paid Well |
+-----------+
|         5 |
+-----------+
+---------+
| su_id   |
+---------+
| CSIT115 |
| CSCI316 |
| MARK101 |
| ACCY101 |
| MARK303 |
| FIN015  |
+---------+
+--------+
| budget |
+--------+
|  66055 |
+--------+
+------+-------------+---------+-----------+----------+----------+---------+------------+------------+
| s_id | i_email     | su_id   | s_dayname | s_stime  | s_etime  | s_hours | s_sdate    | s_edate    |
+------+-------------+---------+-----------+----------+----------+---------+------------+------------+
|    3 | amd@uow.com | CSCI316 | Wednesday | 13:30:00 | 00:00:00 |       3 | 2023-02-15 | 2023-05-17 |
|   12 | amd@uow.com | CSCI316 | Monday    | 15:30:00 | 00:00:00 |       3 | 2023-10-02 | 2024-01-14 |
+------+-------------+---------+-----------+----------+----------+---------+------------+------------+

created 1 year ago by something

MySQL online editor

Write, Run & Share MySQL queries online using OneCompiler's MySQL online editor and compiler for free. It's one of the robust, feature-rich online editor and compiler for MySQL. Getting started with the OneCompiler's MySQL editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose language as 'MySQL' and start writing queries to learn and test online without worrying about tedious process of installation.

About MySQL

MySQL is a open-source, free and very popular relational database management system which is developed, distributed and supported by Oracle corporation.

Key Features:

Open-source relational database management systems.
Reliable, very fast and easy to use database server.
Works on client-server model.
Highly Secure and Scalable
High Performance
High productivity as it uses stored procedures, triggers, views to write a highly productive code.
Supports large databases efficiently.
Supports many operating systems like Linux*,CentOS*, Solaris*,Ubuntu*,Windows*, MacOS*,FreeBSD* and others.

lab_5

MySQL online editor

About MySQL

Key Features:

Syntax help

Commands

1. CREATE

Example

2. ALTER

Example

3. TRUNCATE

4. DROP

5. RENAME

6. COMMENT

Single-Line Comments:

Multi-Line comments:

DML Commands

1. INSERT

Example

2. SELECT

Example

3. UPDATE

Example

4. DELETE

Example

Indexes

1. CREATE INDEX

2. DROP INDEX

Views

1. Create a View

2. How to call view

3. Altering a View

4. Deleting a View

Triggers

1. Create a Trigger

2. Drop a Trigger

Stored Procedures

1. Create a Stored Procedure

2. How to call Stored procedure

3. How to delete stored procedure

Joins

1. INNER JOIN

2. LEFT JOIN

3. RIGHT JOIN

4. CROSS JOIN

OneCompiler.com

Languages

More