摘要:
修改数据库字符集: ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE …]; 把表默认的字符集和所有字符列(CHAR,VARCHAR,TEXT)改为新的字符集: ALTER TABLE tbl_name CONV 阅读全文
摘要:
修改表的默认字符集: ALTER TABLE table_name DEFAULT CHARACTER SET character_name; 修改表字段的默认字符集: ALTER TABLE table_name CHANGE field field field_type CHARACTER SE 阅读全文
摘要:
Linux下mysql修改连接超时wait_timeout 1,首先: show variables like '%timeout%'; 显示结果: + + + | Variable_name | Value | + + + | connect_timeout | 10 | | delayed_in 阅读全文