# mxxlibrary

**Repository Path**: cyyffc/mxxlibrary

## Basic Information

- **Project Name**: mxxlibrary
- **Description**: No description available
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-12-21
- **Last Updated**: 2023-12-21

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README



```SQL

CREATE USER 'mxx'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON mxxlibrary.* TO 'mxx'@'%';
FLUSH PRIVILEGES;
      
      -- 插入100条数据
INSERT INTO `books` (`name`, `author`, `publisher_id`, `type_id`)
SELECT
    CONCAT('Book ', id) AS name,
    CONCAT('Author ', id) AS author,
    FLOOR(RAND() * 20) AS publisher_id,
    FLOOR(RAND() * 30) AS type_id
FROM
    (SELECT @id := @id + 1 AS id
     FROM information_schema.tables
         JOIN (SELECT @id := 0) r
         LIMIT 100) ids;


```