- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Marc Delisle
- 140字
- 2021-08-20 15:55:26
Creating an additional table
In our (simple) design, we know that we need another table—the author table. The author table will contain:
- Author identification
- Full name
- Phone number
To create this table, we go back to the Database
view for marc_book and request the creation of another table with three columns as indicated in the following screenshot:

Using the same techniques used when creating the first table, we type this in:

As we have three columns or less, the display is now in vertical mode (refer to the Vertical mode section in Chapter 5 for more details).
The column name id, which is our primary key in this new table, relates to the author_id
column from the book
table. After saving the table structure, we enter some data for authors 1 and 2. Use your imagination for this!
推薦閱讀
- Raspberry Pi for Python Programmers Cookbook(Second Edition)
- 國際大學生程序設計競賽中山大學內部選拔真題解(二)
- Visual Studio 2012 Cookbook
- PyTorch自動駕駛視覺感知算法實戰
- 無代碼編程:用云表搭建企業數字化管理平臺
- DevOps Automation Cookbook
- Xamarin.Forms Projects
- Java設計模式及實踐
- PLC應用技術(三菱FX2N系列)
- Learning R for Geospatial Analysis
- 深入剖析Java虛擬機:源碼剖析與實例詳解(基礎卷)
- Python 快速入門(第3版)
- Modular Programming with JavaScript
- Java程序設計教程
- Dart:Scalable Application Development