Cara Membuat Relasi Antar Tabel Database MySQL Dengan Query di CMD

Hello friends, in this tutorial, we will discuss How to Create Relationships between MySQL Database Tables with Queries in CMD. Here I will create a related table using the cmd query in the mysql database. Here I include the query: 1. Create a table of majors (int_document_id_, varchar_name_documentation (30), primary key (id_document)); (Create a major tab) 2. Desc majors; (Showing the Program Table Structure) 3. Create a student table (int id_mhs, int nim, varchar_mhs name (50), int_dignity_id, primary key (id_mhs), foreign key (id_jurusan) references majors (id_degree)); (Creating a table of students related to the majors table) 4. Student desc; (Showing Student Table Structure) 5. Insert into the values ​​department ('1', 'Information System'), ('2', 'Informatics Engineering'); (Add data contents to the majors table) 6. Select * from major; (Display all data in the majors table) 7. Insert into student values ​​('1', '201553011', 'Arsya Yoga', '2'), ('2', '20155785', 'Fitri Rachmawati', '1'); (Adding data contents to student table) 8. Select * from students; (Display all data in the student table) For more details, How to Create Relationships between MySQL Database Tables with Query in CMD, just watch the video until it's finished. If there are still those who don't understand or are confused, please write them in the comments column. Thank you for watching the video, don't forget to like and subscribe. Because it is your subscribe that makes me excited to continue uploading videos on this channel. #Mysql #RelationsTableTable #Cmd #CommandPrompt #QueryMysql #RelationTableMysql #RrelationTableMysql #DatabaseMysql #LadangTutorial