SQL   39

Demo sql

Guest on 10th May 2022 05:15:25 PM

  1. /*
  2. Navicat MySQL Data Transfer
  3.  
  4. Source Server         : localhost
  5. Source Server Version : 50067
  6. Source Host           : localhost:3306
  7. Source Database       : demo
  8.  
  9. Target Server Type    : MYSQL
  10. Target Server Version : 50067
  11. File Encoding         : 65001
  12.  
  13. Date: 2019-04-12 15:48:00
  14. */
  15.  
  16. SET FOREIGN_KEY_CHECKS=0;
  17.  
  18. -- ----------------------------
  19. -- Table structure for `msg`
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `msg`;
  22. CREATE TABLE `msg` (
  23.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  24.   `merchant_id` VARCHAR(100) NOT NULL,
  25.   `product_id` VARCHAR(100) NOT NULL,
  26.   `product_longnum` VARCHAR(100) NOT NULL,
  27.   `content` VARCHAR(200) NOT NULL,
  28.   `addtime` VARCHAR(30) NOT NULL,
  29.   PRIMARY KEY  (`id`)
  30. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  31.  
  32. -- ----------------------------
  33. -- Records of msg
  34. -- ----------------------------
  35. INSERT INTO `msg` VALUES ('1', '50003', '50003007', '125909888030', '您的快递已到,请尽快领取#'到,请尽快领取#', '2019-04-06');
  36. INSERT INTO `msg` VALUES ('2'125909888028'0003004', '125909888028', '行医助手提醒您#', '2019-03-22');
  37. INSERT INTO `msg` VALUES ('3', '50005', '50003009', '12590

Raw Paste


Login or Register to edit or fork this paste. It's free.