Blogger Information
Blog 9
fans 0
comment 1
visits 9107
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
创建数据库表
坚持奋斗的博客
Original
1176 people have browsed it

创建数据库表,学习怎删改查。但是增删改查,看着视频会。不看视频什么思路都没有,估计是代码标签的不熟悉。但是还是能慢慢掌握的,为自己加油!!

/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : yanjun

Target Server Type    : MYSQL
Target Server Version : 50553
File Encoding         : 65001

Date: 2019-03-21 10:40:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for xx_users
-- ----------------------------
DROP TABLE IF EXISTS `xx_users`;
CREATE TABLE `xx_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '姓名',
  `age` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '年龄',
  `qq` varchar(12) NOT NULL COMMENT 'QQ号',
  `py` varchar(50) NOT NULL COMMENT '拼音',
  `tle` varchar(12) NOT NULL COMMENT '电话',
  `ip` varchar(20) NOT NULL COMMENT 'IP地址',
  `img` varchar(200) NOT NULL COMMENT '图片',
  `sendtime` varchar(30) NOT NULL DEFAULT '' COMMENT '时间',
  `sex` varchar(5) NOT NULL COMMENT '男女',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xx_users
-- ----------------------------
INSERT INTO `xx_users` VALUES ('1', '杨军', '34', '81429856', 'yangjun', '17393786812', '124.64.121.213', '', '2018-10-29 10:21', '男');
INSERT INTO `xx_users` VALUES ('2', '李老师', '56', '16777215', 'lilaoshi', '45584445454', '124.64.121.213', '', '2018-10-29 10:21', '女');
INSERT INTO `xx_users` VALUES ('3', '边老师', '12', '255454', 'bianlaoshi', '', '124.64.121.213', '', '2018-10-29 10:21', '女');

Correction status:qualified

Teacher's comments:
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post