sqlupdate读取MySQL的表定义SQL文件,然后与现有数据库中进行比较,然后生成更新数据库结构的SQL语句。
sqlupdatev1.6.5-Copyright(C)JoelYliluoma(https://iki.fi/bisqwit/)Usage:sqlupdate[options]>changes.sql(Createsanupdatescript)Options:-ttablefileDescribesthefilecontainingthenewsqllayout.Default:tables.sql-ddatabaseDefault:winnie3-hhostDefault:localhost-uuserDefault:root-iUseCREATEINDEXinsteadofALTER..ADDKEY-mAddcommentsexplainingthedifferences-cIgnorecharactersetdifferences-ppass-rReverseoperation.(new->old)Example:./sqlupdate-tetimgr.sql-detimgr|mysql-urootThisprogramdoesnotupdateadatabase.Itonlyproducesupdatescripts(whichshowthedifferences).点击空白处退出提示
评论