Database Design

1, Database design

##CREATE TABLE `global_region` (

`region_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',

`region_name` varchar(120 ) NOT NULL DEFAULT '',

## `region_type` tinyint(1) NOT NULL DEFAULT '2',

PRIMARY KEY (`region_id `),

KEY `parent_id` (`parent_id`),

KEY `region_type` (`region_type`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

The data table is as follows:

微信图片_20180310123806.png

Insert data:

Link: https://pan.baidu.com/s/10P2ueF8JpJ5v2W4HsJtfWQ Password: 5q7i

Download and execute Just

Continuing Learning

new file

<?php echo "数据库设计";

submit Reset Code

Automatic operation

Previous section Next Section

Tutorial List

get help

Course Recommendations
Courseware download

The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~

Students who have watched this course are also learning

Database Design

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]