myql
qq_41672744
这个作者很懒,什么都没留下…
展开
-
mysql 删除数据库 显示大小
清空数据库mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "truncate table $table" DATABASE_NAME; done显示大小SELECT table_schema "DB Name", ROUND(SUM(data_length + index...原创 2020-03-20 20:19:03 · 248 阅读 · 0 评论 -
如何关闭mysql的strict mode
I need do it this, and work correctly:To disable strict SQL mode, SSH in to your server as root Create this file:/etc/mysql/conf.d/disable_strict_mode.cnf Open the file and enter these two line...原创 2020-03-02 10:30:42 · 793 阅读 · 0 评论