mysql> create database ouda;
Query OK, 1 row affected (0,18 sec)
mysql> use ouda;
Database changed
mysql> create table student(
-> student_id INT AUTO_INCREMENT PRIMARY KEY,
-> name VARCHAR(255) NOT NULL,
-> mail_address VARCHAR(255) NOT NULL,
-> gender ENUM('M','F')
-> );
Query OK, 0 rows affected (0,04 sec)
mysql> CREATE TABLE languages_level(
-> student_id INT,
-> language_name VARCHAR(50),
-> level ENUM('basic', 'intermediate', 'advanced', 'native'));
Query OK, 0 rows affected (0,03 sec)
mysql> INSERT INTO student (name, mail_address, gender) VALUES ('ouda', '[email protected]', 'M');
Query OK, 1 row affected (0,03 sec)
mysql> select * from student where name='ouda';
+------------+------+---------------+--------+
| student_id | name | mail_address | gender |
+------------+------+---------------+--------+
| 1 | ouda | [email protected] | M |
+------------+------+---------------+--------+
1 row in set (0,01 sec)
mysql> INSERT INTO languages_level values (1, 'english', 'advanced');
Query OK, 1 row affected (0,00 sec)
mysql> INSERT INTO languages_level values (1, 'arabic', 'native');
Query OK, 1 row affected (0,00 sec)
mysql> SELECT student.name, languages_level.language_name , languages_level.level from languages_level RIGHT JOIN student on languages_level.student_id = student.student_id;
+------+---------------+----------+
| name | language_name | level |
+------+---------------+----------+
| ouda | arabic | native |
| ouda | english | advanced |
+------+---------------+----------+
2 rows in set (0,01 sec)
Comments
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|0 👍
/0 👎
0 B
|👍
/👎