PHPackages                             mysqlsyn/mysqlsyn - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. mysqlsyn/mysqlsyn

ActiveProject[Database & ORM](/categories/database)

mysqlsyn/mysqlsyn
=================

一种规范, 维护sql的shell脚步.

1.0(8y ago)2280Shell

Since Aug 23Pushed 8y ago1 watchersCompare

[ Source](https://github.com/iamloso/mysqlsyn)[ Packagist](https://packagist.org/packages/mysqlsyn/mysqlsyn)[ RSS](/packages/mysqlsyn-mysqlsyn/feed)WikiDiscussions master Synced 2d ago

READMEChangelogDependenciesVersions (2)Used By (0)

mysqlsyn.sh 是一个维护sql语句的shell脚本.
-------------------------------

[](#mysqlsynsh-是一个维护sql语句的shell脚本)

### 文件说明:

[](#文件说明)

```
* update.sql 保存新增sql语句的文件, 执行mysqlsyn.sh后该文件中sql将被执行, 执行后其sql语句被写入到cyc_update.sql文件中, 同时清空update.sql.

* cyc_update.sql 在一次开发迭代周期中, 增量保存update.sql文件中sql语句. 并在本期开发迭代完毕, 需要同步该文件中sql语句到生产数据库. 同步后执行mysqlsyn.sh allin 使上线sql写入project.sql中及清空cys_update.sql文件.

* project.sql 项目sql文件, 该文件保存项目完整sql语句. allin 后记录最终sql版本.

```

### 工作流程

[](#工作流程)

```
1 修改mysqlsyn.sh文件中数据库用户与密码配置

2 新增sql语句, 写入到update.sql文件

3 执行./mysqlsyn.sh 脚本, 执行update.sql文件中sql. 原则上讲sql语句执行不可逆, 如需回退, 请在增加sql.

4 完整功能开发完毕, 需要all in到project.sql文件, 执行 ./mysqlsyn.sh allin

```

###  Health Score

29

—

LowBetter than 57% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community4

Small or concentrated contributor base

Maturity63

Established project with proven stability

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

3234d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/079ee8fb804e07cc54ab10acd55cea1e0476f68ff5fe52ef226ae4b4f7d5a57f?d=identicon)[iamloso](/maintainers/iamloso)

### Embed Badge

![Health badge](/badges/mysqlsyn-mysqlsyn/health.svg)

```
[![Health](https://phpackages.com/badges/mysqlsyn-mysqlsyn/health.svg)](https://phpackages.com/packages/mysqlsyn-mysqlsyn)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k117.2M117](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)