Mastering phpMyAdmin 2.8 for Effective MySQL Management 3rd phần 7

Vô hiệu hóa kiểm tra chính nước ngoài: Trong tập tin xuất khẩu, chúng tôi có thể thêm câu lệnh DROP TABLE. Howeve, một bảng không thể được Thông thường nếu nó được giảm xuống tham chiếu trong một hạn chế chính nước ngoài. Tùy chọn này sẽ ghi đè xác minh bởi Thêm FOREIGN_KEY_CHECKS SET = 0 vào file xuất khẩu. SQL xuất khẩu khả năng tương thích: Điều này cho phép chúng ta chọn | Relational System yj Server localhost 1 Database dbbook k ỊỈĨĨỊ Table books Browse structure sffiSQL - Search Reinsert Export Import Operations - Links to------------------------------------------------------------------------------------- InnoDB Isbn Ly rail ON DELETE 1 - ON UPDATE 1 - J title 1 J ON DELETE 1 - T ON UPDATE p J pagecount No index defined authorld 1 J ON DELETE 1 - T ON UPDATE p J language No index defined description No index defined coverphoto No index defined genre No index defined date_published No index defined stamp No index defined Benefits of the Defined Relations In this section we will look at the benefits that we can currently test other benefits will be described in Chapter 13 The Multi-Table Query Generator and Chapter 15 System Documentation . Some other benefits of the linked-tables infrastructure will appear in Chapter 14 Bookmarks and Chapter 16 MIME-Based Transformations . These benefits are available for both internal and InnoDB relations. Foreign Key Information Let s browse the books table. We see that the related key author_id is now a link. Moving the mouse pointer over any author_id value reveals the author s name as defined by the display field of the authors table 174 Chapter 11 -T- isbn title pagecount authorid r J X 1-234567-22-0 Future souvenirs 200 2 r s X 1-234567-89-0 A hundred years of cinema volume 1 600 1 r J X 1-234567-90-0 A hundred years of cinema volume 2j 600 John Smith Clicking on the author_id brings us to the relevant table authors for this specific author -T- author id authorname phone r J X 1 John Smith 01 445-789-1234 The Drop-Down List of Foreign Keys Going back to the books table in Insert mode or in Edit mode we now see a drop-down list of the possible keys for each field that has a relation defined. The list contains the keys and the description display field in both orders key to display field and display field to key. This enables us to use the keyboard and type the first letter of either the key .