如何用mysql开发_MySQL开发技巧（一）

相关的数据表

/*

SQLyog Ultimate v13.1.1 (64 bit)

MySQL - 5.7.26 : Database - test_mysql

*********************************************************************

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`test_mysql` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `test_mysql`;

/*Table structure for table `user_kills` */

DROP TABLE IF EXISTS `user_kills`;

CREATE TABLE `user_kills` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user_id` int(11) NOT NULL,

`kills` int(2) NOT NULL,

`timestr` datetime NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `user_kills` */

insert  into `user_kills`(`id`,`user_id`,`kills`,`timestr`) values

(1,2,15,'2013-01-10 00:00:00'),

(2,2,2,'2013-01-02 00:00:00'),

(3,2,12,'2013-02-05 00:00:00'),

(4,4,3,'2013-01-10 00:00:00'),

(5,4,5,'2020-11-12 02:54:05'),

(6,2,1,'2020-11-05 02:54:24'),

(7,3,20,'2020-11-11 02:54:37'),

(8,2,10,'2020-11-11 02:54:54'),

(9,3,17,'2020-11-10 02:55:06'),

(10,3,22,'2020-11-13 04:32:30');

/*Table structure for table `user1` */

DROP TABLE IF EXISTS `user1`;

CREATE TABLE `user1` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user_name` char(10) COLLATE utf8_unicode_ci NOT NULL,

`over` char(10) COLLATE utf8_unicode_ci NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `user1` */

insert  into `user1`(`id`,`user_name`,`over`) values

(1,'唐曾','功德佛'),

(2,'猪八戒','净坛使者'),

(3,'孙悟空','齐天大圣'),

(4,'沙增','金身罗汉');

/*Table structure for table `user2` */

DROP TABLE IF EXISTS `user2`;

CREATE TABLE `user2` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user_name` char(10) COLLATE utf8_unicode_ci NOT NULL,

`over` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `user2` */

insert  into `user2`(`id`,`user_name`,`over`) values

(1,'孙悟空','成佛'),

(2,'牛魔王',NULL),

(3,'蛟魔王',NULL),

(4,'鹏魔王',NULL),

(5,'狮魔王',NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;