Enter password:
c:/wamp64/bin/mysql/mysql5.7.31/bin/mysql: Unknown OS character set 'cp857'.
c:/wamp64/bin/mysql/mysql5.7.31/bin/mysql: Switching to the default character set 'latin1'.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.31 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

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 table Course(Code varchar(10) primary key, CName varchar(200)) eNGINE = InnoDb;
ERROR 1046 (3D000): No database selected
mysql> use CRS;
ERROR 1049 (42000): Unknown database 'crs'
mysql> create database CRS;
Query OK, 1 row affected (0.00 sec)

mysql> use CRS;
Database changed
mysql> create table Course(Code varchar(10) primary key, CName varchar(200)) eNGINE = InnoDb;
Query OK, 0 rows affected (0.02 sec)

mysql> create table CEnroll(ID int, Code varchar(10), L_Venue varchar(200),
    -> primary key(ID, Code),
    -> foreign key(ID) references student(ID) ON DELETE CASCADE,
    -> foreign key(CODE) references course(CODE) ON DELETE CASCADE)
    -> Engine = InnoDB;
ERROR 1215 (HY000): Cannot add foreign key constraint
mysql> create table Student(ID int primary key, Name varchar(200)) Engine = InnoDB;
Query OK, 0 rows affected (0.03 sec)

mysql> create table CEnroll(ID int, Code varchar(10), L_Venue varchar(200),
    -> primary key(ID, Code),
    -> foreign key(ID) references student(ID) ON DELETE CASCADE,
    -> foreign key(CODE) references course(CODE) ON DELETE CASCADE)
    -> Engine = InnoDB;
Query OK, 0 rows affected (0.04 sec)

mysql> create table testEngine(TName varchar(100));
Query OK, 0 rows affected (0.02 sec)

mysql> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'CRS';
+------------+--------+
| TABLE_NAME | ENGINE |
+------------+--------+
| cenroll    | InnoDB |
| course     | InnoDB |
| student    | InnoDB |
| testengine | MyISAM |
+------------+--------+
4 rows in set (0.00 sec)

mysql> insert into student values(1, 'Abdulmajid'), (2, 'Abdulkadir'),
    -> (3, 'Ranen'), (4, 'Raneem', (5, 'Arthur'), (6, 'Ahmad'), (7, 'Zainab'), (8, 'Nusaiba'), (9, 'Yaseer'), (10, 'Halima');
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 2
mysql> insert into student values(1, 'Abdulmajid'), (2, 'Abdulkadir'),
    -> (3, 'Ranen'), (4, 'Raneem'), (5, 'Arthur'), (6, 'Ahmad'), (7, 'Zainab'), (8, 'Nusaiba'), (9, 'Yaseer'), (10, 'Halima');
Query OK, 10 rows affected (0.00 sec)
Records: 10  Duplicates: 0  Warnings: 0

mysql> insert into course values('COME301', 'DBMS'), ('SE301', 'SVT'), ('MSC987', 'MC-Simulations'), ('COME205', 'DStruct'), ('MENG202', 'Modeling'), ('SE404', 'Agile');
Query OK, 6 rows affected (0.01 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> select * from course;
+---------+----------------+
| Code    | CName          |
+---------+----------------+
| COME205 | DStruct        |
| COME301 | DBMS           |
| MENG202 | Modeling       |
| MSC987  | MC-Simulations |
| SE301   | SVT            |
| SE404   | Agile          |
+---------+----------------+
6 rows in set (0.00 sec)

mysql> insert into Cenroll values(1, 'COME301', 'Nermin Tarhan');
Query OK, 1 row affected (0.00 sec)

mysql> insert into Cenroll values(1, 'COME205', 'Ayhan Songar');
Query OK, 1 row affected (0.01 sec)

mysql> insert into Cenroll values(5, 'COME205', 'Ayhan Songar');
Query OK, 1 row affected (0.01 sec)

mysql> insert into Cenroll values(6, 'COME205', 'Ayhan Songar');
Query OK, 1 row affected (0.00 sec)

mysql> insert into Cenroll values(7, 'COME205', 'Ayhan Songar');
Query OK, 1 row affected (0.01 sec)

mysql> insert into Cenroll values(10, 'COME205', 'Ayhan Songar');
Query OK, 1 row affected (0.01 sec)

mysql>