Community Learn Tools Library Leisure
search
English

Database Design

This tutorial shows one is a classification table and the other is a news table

1, the creation of the classification table

Table name: type

create table type(

id int(11) not null primary key auto_increment,

typename varchar(255) ,

orderid int(11) ,

fid int(11))

##CHARSET=utf8;

微信图片_20180306184322.png


2, Creation of news table

Table name: news

create table news(

##id int(11) not null primary key auto_increment,

typeid int(11) not null ,

title varchar(255),

source varchar(255),

picurl varchar(255),

##content text ,

##posttime int(11))

CHARSET=utf8;

Continuing Learning
||
<?php echo "数据库的设计";
submitReset Code
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

The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)  492409 plays