Hướng dẫn mysql relation view - chế độ xem quan hệ mysql

Question

DIỄN ĐÀN SINH VIÊN CNTT QUẢNG NINH!

Giả sử bạn có tạo 1 cơ sở dữ liệu gồm 2 bảng. Bảng 1. Đơn hàng. Bảng 2. Khách hàng.
Bảng 1. Đơn hàng.
Bảng 2. Khách hàng.
Mỗi khách hàng thì có thể có nhiều đơn hàng. Vậy làm sao để liên kết quan hệ khách hàng với đơn hàng. Ta phải nhập thông tin khách hàng trước sau đó mới nhập đơn hàng.
Bên bảng đơn hàng có trường mã khách hàng.đơn hàng có trường mã khách hàng.

Bên bảng khách hàng có trường mã khách hàng là khóa chính.hách hàng có trường mã khách hàng là khóa chính.

Tại bảng hoa_don: trường ma_khach_hang chọn indexhoa_don: trường ma_khach_hang chọn index

Sau đó chọn OK

Tiếp tục chọn Relation viewRelation view

Ở Column Ma_khach_hang: 1. khach_hang 2. ma_khach_hang 3. Tên quan hệ 4. Delete không thể xóa khi có dữ liệu. 5. Update dữ liệu. 6. Save lại.
1. khach_hang
2. ma_khach_hang
3. Tên quan hệ
4. Delete không thể xóa khi có dữ liệu.
5. Update dữ liệu.
6. Save lại.

Sau đó bạn thêm dữ liệu vào bảng khách hàng trước.khách hàng trước.

Tiếp theo khi nhập CSDL bảng hóa đơn bạn chỉ cần chọn mã khách hàng là đc.

Chúc các bạn thành công!

Bình Luận Bằng Facebook
data-href="https://cnttqn.com/threads/huong-dan-ket-noi-quan-he-2-bang-csdl-trong-phpmyadmin.5182.html"

When working in XAMPP with phpmyadmin, after creating a table I have the option to click "relation view" after clicking on the structure tab. See below:

However anytime when I create a table with my host phpmyadmin, I dont have the option to select "relation view" See below:

Is there anyway of enabling this? Currently I have to set up relationships in xampp and export to my host phpmyadmin for it to work.

Ariful Islam

7,5357 gold badges34 silver badges54 bronze badges7 gold badges34 silver badges54 bronze badges

asked Dec 7, 2011 at 18:00Dec 7, 2011 at 18:00

Change your storage engine to InnoDB by going to Operation

answered Sep 11, 2012 at 14:42Sep 11, 2012 at 14:42

HarleyHarleyHarley

1,3661 gold badge10 silver badges3 bronze badges1 gold badge10 silver badges3 bronze badges

1

If it's too late at night and your table is already innoDB and you still don't see the link, maybe is due to the fact that now it's placed above the structure of the table, like in the picture is shown

answered Apr 7, 2015 at 18:13Apr 7, 2015 at 18:13

2

first select the table you you would like to make the relation with >> then go to operation , for each table there is difference operation setting, >> inside operation "storage engine" choose innoDB option

innoDB will allow you to view the "relation view" which will help you make the foreign key

Mureinik

283k51 gold badges290 silver badges327 bronze badges51 gold badges290 silver badges327 bronze badges

answered Apr 16, 2014 at 15:06Apr 16, 2014 at 15:06

aishaaishaaisha

2513 silver badges2 bronze badges3 silver badges2 bronze badges

1

Enabling Relation View in phpMyAdmin / MAMP

If you’re using MAMP for your database driven projects you’ll probably be using phpMyAdmin to administer your MySQL database if you’ve decided to go down that route. If you’re creating a database you might be wondering how to create relationships and foriegn keys for your tables.

Firstly you need to check that you have access to the Relation view. To do this open phpMyAdmin and select a database. You need to make sure your tables’ storage engine is set to use InnoDB. Click on a table within your database and choose the Operations tab. Make sure that the storage engine is set to use InnoDB and save your changes.

Now, go back to your table view and click the Structure tab. Depending on your version of phpMyAdmin you should see a link titled Relation view below the table structure. If you can see it you’re good to go. If you can’t you’ll need to follow the steps below to set phpMyAdmin to enable Relations view.

Find /Applications/MAMP/bin/phpMyAdmin/scripts/create_tables.sql
I left this file default but you can change the table name to anything you want. I left mine phpMyAdmin
Open phpMyAdmin and go to the Import tab. Import tab.
Click the browse button and find the create_tables.sql file and then click Go. Go.
The tables required for Relation view will be added to the database you specified.
Open /Applications/MAMP/bin/phpMyAdmin/config.inc.php

Find the Server(s) configuration code block and replace/uncomment the following code and fill in the values. If you left everything default in the create_tables.sql file then you should just cut and paste the lines below.

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';

Save the file and restart MAMP and refresh your phpMyAdmin console.restart MAMP and refresh your phpMyAdmin console.
Go to your database and view one of your tables in Structure mode. You should now see the Relation view link.

Source: http://newvibes.com/blog/enabling-relation-view-in-phpmyadmin-mamp/

answered Aug 14, 2015 at 5:26Aug 14, 2015 at 5:26

Meetai.comMeetai.comMeetai.com

6,3563 gold badges30 silver badges37 bronze badges3 gold badges30 silver badges37 bronze badges

1

first ensure that your table storage engine type should be innoDB (you can set it using Table operations Tab) storage engine type should be innoDB (you can set it using Table operations Tab)

if you are using new phpmyadmin then use new "Relation view" tab to make foreign key relationnew phpmyadmin then use new "Relation view" tab to make foreign key relation

if you are using old version of phpmyadmin then the "relation view" button will show on the bottom of the table columnsold version of phpmyadmin then the "relation view" button will show on the bottom of the table columns

answered Dec 11, 2020 at 19:34Dec 11, 2020 at 19:34

Hassan SaeedHassan SaeedHassan Saeed

5,3071 gold badge30 silver badges34 bronze badges1 gold badge30 silver badges34 bronze badges

1 - Change Your tables search engine from 'My ISAM' to 'Inno DB' by Operations tab 2 - you must do this for all tables that you want make relationship between 3 - localhost/phpmyadmin/tbl_relation.php?db=your_database_name&table=your_table_name then replace this url in browser, then you will be able to see the relationship pagelocalhost/phpmyadmin/tbl_relation.php?db=your_database_name&table=your_table_name then replace this url in browser, then you will be able to see the relationship page

Đã trả lời ngày 14 tháng 6 năm 2019 lúc 15:11Jun 14, 2019 at 15:11

programming mysql Procedure trong MySQL Trigger trong MySQL

Hướng dẫn mysql relation view - chế độ xem quan hệ mysql

Bình Luận Bằng Facebook

Bài Viết Liên Quan

Quảng Cáo

Có thể bạn quan tâm

Toplist được quan tâm

Quảng cáo

Xem Nhiều

Quảng cáo

Chúng tôi

Điều khoản

Trợ giúp

Mạng xã hội