首页
开发手册
应用中心
工具
用户中心
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.  --- #### 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.  --- #### 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 .   #### 4.Query Data Select the table you want to query in the data table management, click View to search for data. 