MySQL 使用学习

 

思维导图，很全面

https://www.processon.com/view/5e65f949e4b04949eaeec7a7?fromnew=1#map

 

教学视频

编程不良人 80 分钟教学  最最最最最最最最最最最最最最最最最最最最最最   简单的安装 及配置 使用 ，

https://www.bilibili.com/video/BV1gE411L7hg?p=3

 

 

命令行操作MySQL

 

 

 

 

基本操作  
1. 登录  mysql -u root -p 回车 输入密码
2. 查询库  show databases;
   选择库  use 库名
   删除库  drop database  库名
   创建库  create database 库名
3. 查看表  show tables ;
   创建表  create  tables (语法同oracle)
   删除表  drop table 表名;
4. 操作表  CRUD     (语法同oracle)
5. 分页查询  select * from 表名 limit (当前页-1)*每页记录数,每页记录数

附赠建表语句

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info`  (
  `ui_id` int(16) NOT NULL,
  `ui_is_login` int(1) NULL DEFAULT 0,
  `ui_is_admin` int(1) NULL DEFAULT 0,
  `uti_id` int(16) NULL DEFAULT NULL,
  `ori_id` int(16) NULL DEFAULT NULL,
  `ui_login_name` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_password` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_image_url` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_name` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_sex` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '1',
  `ui_job` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_code` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_mobile` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_email` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_phone` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_fax` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_address` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_memo` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_last_login_time` date NULL DEFAULT NULL,
  `ui_last_login_ip` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_login_num` int(8) NULL DEFAULT 0,
  `ui_is_deleted` int(1) NULL DEFAULT 0,
  `ui_insert_time` date NULL DEFAULT NULL,
  `ui_update_time` date NULL DEFAULT NULL,
  `ui_delete_time` date NULL DEFAULT NULL,
  `ui_insert_id` int(16) NULL DEFAULT NULL,
  `ui_update_id` int(16) NULL DEFAULT NULL,
  `ui_delete_id` int(16) NULL DEFAULT NULL,
  `ori_code` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_sap_code` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ui_last_login_type` int(1) NULL DEFAULT NULL,
  `ui_charge_type` int(1) NULL DEFAULT NULL,
  `ui_is_bind_info` int(1) NULL DEFAULT NULL,
  `ui_sms_code` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ui_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (294, NULL, NULL, NULL, 22, NULL, NULL, NULL, 'liLei', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (4884, NULL, NULL, NULL, 22, NULL, NULL, NULL, 'liLei', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (9145, NULL, NULL, NULL, 22, NULL, NULL, NULL, 'liLei', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

 

java 链接程序配置

 

           <!--添加mysql连接的依赖包-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

driverClassName:  com.mysql.jdbc.Driver
url:              jdbc:mysql://localhost:3306/ems?characterEncoding=UTF-8
username:         root
password:         root

 

 

演示代码地址

待更新

https://github.com/wei198621/allTypes_persistence