随笔分类 - MySQL
摘要：-- -- Table structure for bs002h -- DROP TABLE IF EXISTS `bs002h`; CREATE TABLE `bs002h` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `cr_time` datetime
阅读全文
摘要：CREATE EVENT IF NOT EXISTS check_timeout_eventON SCHEDULE EVERY 30 MINUTEDOBEGIN UPDATE safetyApp_inspectionprogress SET timeout = 1 WHERE status = 'u
阅读全文
摘要：mysql 删除数据表报错 表删除时 Cannot delete or update a parent row: a foreign key constraint fails 异常处理 MySQL报错 "Cannot delete or update a parent row: a foreign
阅读全文
摘要：SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAMEFROM INFORMATION_SCHEMA.KEY_COLUMN_USAGEWHERE REFERENCED
阅读全文
摘要：import MySQLdb as Database ModuleNotFoundError: No module named ‘MySQLdb‘ import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb' [r
阅读全文
摘要：utf8_unicode_ci和utf8_general_ci对中、英文来说没有实质的差别。utf8_general_ci校对速度快，但准确度稍差。utf8_unicode_ci准确度高，但校对速度稍慢。
阅读全文
摘要：mysql报错Unknown collation: utf8mb4_0900_ai_ci 解决方案： 将文件内的所有 utf8mb4_0900_ai_ci 换成 utf8_general_ci utf8mb4 换成 utf8
阅读全文
