随笔分类 -  mysql

摘要：-- 创建一个名为 users 的数据表CREATE TABLE users ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, age INT NOT NULL, createtime TIMESTAM 阅读全文

摘要：今天在MYSQL 5.7的数据库上导出数据库时，碰到一个错误信息：Cannot proceed because system tables used by Event Scheduler were found damaged at server start；最近对数据库进行了升级，可能是因为数据库版 阅读全文

摘要：select * from information_schema.`TABLES` where TABLE_SCHEMA = 'indepcloud' and TABLE_COLLATION!='utf8_general_ci' limit 100; 阅读全文