创建数据库表,学习怎删改查。但是增删改查,看着视频会。不看视频什么思路都没有,估计是代码标签的不熟悉。但是还是能慢慢掌握的,为自己加油!!
/*
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', '女');