• pycharm的mysql增加数据:


     增加数据:

    -- ----------------------------
    -- Records of app01_author
    -- ----------------------------
    INSERT INTO `app01_author` VALUES ('1', '金老板', '18', '15512351234');
    INSERT INTO `app01_author` VALUES ('2', '小哪吒', '20', '15312341234');
    INSERT INTO `app01_author` VALUES ('3', 'Alex', '73', '15512341234');

    -- ----------------------------
    -- Records of app01_publisher
    -- ----------------------------
    INSERT INTO `app01_publisher` VALUES ('1', '沙河出版社', '北京');
    INSERT INTO `app01_publisher` VALUES ('2', '西二旗出版社', '北京');
    INSERT INTO `app01_publisher` VALUES ('3', '张江出版社', '上海');
    INSERT INTO `app01_publisher` VALUES ('4', '沙河出版社', '上海');

    -- ----------------------------
    -- Records of app01_book
    -- ----------------------------
    INSERT INTO `app01_book` VALUES ('1', '跟金老板学开车', '2018-08-03', '12.90', null, '1');
    INSERT INTO `app01_book` VALUES ('2', '跟金老板学开潜艇', '2017-08-10', '9.99', null, '1');
    INSERT INTO `app01_book` VALUES ('3', '跟老男孩学思想', '2018-09-03', '39.99', null, '2');
    INSERT INTO `app01_book` VALUES ('4', '跟egon学喊麦', '2018-06-12', '0.99', null, '4');

    -- ----------------------------
    -- Records of app01_book_author
    -- ----------------------------
    INSERT INTO `app01_book_author` VALUES ('3', '1', '1');
    INSERT INTO `app01_book_author` VALUES ('4', '1', '2');
    INSERT INTO `app01_book_author` VALUES ('5', '2', '1');
    INSERT INTO `app01_book_author` VALUES ('2', '2', '2');
    INSERT INTO `app01_book_author` VALUES ('6', '3', '3');
    INSERT INTO `app01_book_author` VALUES ('7', '4', '3');
  • 相关阅读:
    Qt 布局之二:水平、垂直布局的使用详解
    Qt 布局之一:布局初探
    [数据库] SQL 语法之进阶篇
    [数据库] SQL 语法之基础篇
    看图深入理解单链表的反转
    [数据结构
    (原)tslib的交叉编译
    (转) s-video vs. composite video vs. component video 几种视频格式详细说明和比较
    (转)BT1120接口及协议
    (转)Ubuntu12.04上NFS Server安装使用过程
  • 原文地址:https://www.cnblogs.com/zhang-da/p/12107099.html
Copyright © 2020-2023  润新知