首页
开发手册
应用中心
工具
用户中心
DBM Data Table Creation
English
中文简体
English
上一篇
下一篇
### DBM Data sheet management Database master provides convenient and fast data table management, you can use database commands to operate, you can also use the graphical interface to operate. #### 1. Create a Database The database statement is: create database FoundPHP This statement represents the creation of a database named FoundPHP. In DBM, it is easier to create a database. ![](data/files/edit/21/05/18/210518_10276526.png) --- #### 2.Create Data Table There are several elements in a data table are necessary: set the primary key, set the primary key auto-increment, set the comment The following example is to create a user table in the FoundPHP database, and the comment content is after COMMENT. ``` CREATE TABLE IF NOT EXISTS `user`( `id` INT UNSIGNED AUTO_INCREMENT COMMENT ‘primary key id’,//auto increment `username` VARCHAR(100) NOT NUL COMMENT ‘username’L, `mobile` VARCHAR(40) NOT NUL COMMENT ‘phone number’L, PRIMARY KEY ( `id` )//set primary key )ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT ‘user table’; ``` Using DBM to Create Data Tables. ![](data/files/edit/21/05/18/210518_10477897.png) --- #### 3.Add Data Field If the array fields of the original added table are insufficient, you can use the following methods to add new fields After entering the data table, click `Structure`, and add a new field in the `Structure` page . ![](data/files/edit/21/06/19/210619_15132708.png) ![](data/files/edit/21/06/19/210619_15139852.png) #### 4.Query Data Select the table you want to query in the data table management, click View to search for data. ![](data/files/edit/21/06/19/210619_15159960.png)