随笔分类 -  mysql

• mysql修改联合主键
  摘要：参考 https://blog.csdn.net/BockSong/article/details/80933477 alter table TABNAME drop primary key; alter table TABNAME add primary key(another_col,...); 阅读全文
  posted @ 2019-03-01 11:27 white knight 阅读(2281) 评论(0) 推荐(0)
• mysql允许某ip访问
  摘要：grant all on *.* to databaseName@'ipAddress' identified by 'somePassword'; flush privileges; 阅读全文
  posted @ 2018-03-26 11:09 white knight 阅读(100) 评论(0) 推荐(0)