1005- can't create table '#sql-10f4_2'(error:150)

最新推荐文章于 2023-12-21 14:36:52 发布
原创 最新推荐文章于 2023-12-21 14:36:52 发布 · 779 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍了在使用Navicat创建带有外键的表时遇到的1005错误（can't create table）及解决方法。错误主要由表引擎不一致引起，需检查并统一主表和从表的引擎类型。若问题仍存，可能是主键与外键值不匹配，需调整数据一致性。

今天在navicat建表外键时报 1005- can't create table '#sql-10f4_2'(error:150)  查了资料，发现是表引擎不一致导致。

查找表的引擎

 修改表的引擎

如果还出现这个 cannot add or update a child row:a foreign key constraints fails（），那就是主键和外键的值不匹配，要修改好才能建外键。 

什么是In-Memory计算？ Mastering In Memory Computing:A Comprehensive Guide
AI天才研究院
07-20 3394
作者：禅与计算机程序设计艺术 什么是In-Memory计算？ In-memory computing refers to the process of executing computational tasks by storing input and output data i
2023-10-17 mysql-从库从binlog回放事件-分析
悟世之路
10-17 353
2023-10-17 mysql-从库从binlog回放事件-分析。
mysql 1005 - can't create table_MySQL Error Number 1005 Can’t create table（Errno：150）
weixin_42524004的博客
01-21 303
MySQL Error Number 1005Can’t create table ‘.\mydb\#sql-328_45.frm’ (errno: 150)If you get this error while trying to create a foreign key, it can be pretty frustrating. The error about not being able ...
MySQL建立外键出现Can't create table‘..’ （errno:150）问题（简单易懂版）
jilinmly的博客
08-31 4042
今天创建表时出现了Can't create table‘..’ （errno:150），经过排查发现是关联的B表中有一条测试数据，其中的值不在A表所关联字段的范围 会造成error：150的原因大概有三点： 1. B表的外键字段 从 类型 是否为空等是否和A表所要关联的字段相同 2. B表的外键字段中有A表所要关联的字段中没有的数据，比如A表的id为1,2 B表关联A表的id为外键，但...
Can't create table './store/#sql-b2c_1a.frm' (errno: 150)解决方法
weixin_34068198的博客
12-06 274
错误原因有四： 1、外键的引用类型不一样，主键是int外键是char 2、找不到主表中 引用的列 3、主键和外键的字符编码不一致 4.还有要建立外键的话，要先建立索引。没有建立索引也会出错。 我的错误原因是1，将外键所在的表的字段有char改回int就好了。 本文转自xwdreamer博客园博客，原文链接：http://www.cnblog...
MySQL中：Can't create table‘xxx’ （errno:150）解决方案
qsw2lw的博客
01-26 4618
create table class( id int unsigned auto_increment, className varchar(50), classDesc varchar(50), primary key(id) ); create table student( id int unsigned auto_increment, stuName varchar(50), ...
MySQL错误：Can't create table‘..’ （errno:150）解决方案
热门推荐
浅然的专栏
05-17 5万+
场景 含有学生表s(sno,sname,sage)、课程表c(cno,cname) 选课表(sc)创建时，设置(sno，cno)为主键、sno和cno为外键 drop table if exists sc1; create table sc1( sno varchar(10), cno varchar(10), grade numeric, primary k...
android.database.sqlite.SQLiteException: near "1": syntax error (code 1 SQLITE_ERROR): , while compiling: INSERT INTO m_rs_shibu_name_info ( shibu_cd , honbu_cd , naibu_shibu_cd , shibu_name , yubin_no , address , tel_no , fax_no , dsp_order , update_date )VALUES (96399 , 1 , 001 , 東京QQ , 1000001 , 東京都千代田区千代田 1-1-1 東京ビル 10F , 0332111111 , 0332111112 , 1 , 20240101)
10-26
CREATE TABLE m_rs_shibu_name_info ( naibu_shibu_cd TEXT, -- 而不是 INTEGER ... ); ``` ### 2. 时间格式建议 如果 `update_date` 是日期字段，建议使用标准格式： ```kotlin "2024-01-01 12:00:00" ``` 或者...
[SQL] Query smartmiao start [ERR] 1046 - No database selected [ERR] /* Navicat Premium Data Transfer Source Server : 腾讯云轻量服务器 Source Server Type : MySQL Source Server Version : 80026 (8.0.26) Source Host : 81.70.194.45:3306 Source Schema : smartmiao Target Server Type : MySQL Target Server Version : 80026 (8.0.26) File Encoding : 65001 Date: 14/12/2022 21:02:35 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for account_book -- ---------------------------- DROP TABLE IF EXISTS `account_book`; CREATE TABLE `account_book` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `name` varchar(255) DEFAULT NULL COMMENT '名称', `balance` decimal(19,2) DEFAULT '0.00' COMMENT '余额', `remark` text COMMENT '备注', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `deleted_at` datetime DEFAULT NULL, `is_default` tinyint(1) DEFAULT '0' COMMENT '是否是默认', `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户Id', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='账本表'; -- ---------------------------- -- Records of account_book -- ---------------------------- BEGIN; INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('120bd3b3-6aa5-4912-898f-8638f96a3b57', '我的账本', 6657.00, '', '2022-11-11 11:38:54', '2022-12-01 13:41:59', NULL, 1, '1'); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('24e83124-c851-49f5-9c98-350bd38d6355', '老婆的账本', 8281.00, '', '2022-03-21 21:05:30', '2022-09-26 16:29:33', NULL, 0, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('43e6e3fd-cbaa-410b-9621-14eae4132a07', '8888', 62878.00, '', '2022-05-17 16:26:36', '2022-06-22 08:12:49', '2022-06-22 08:12:49', 0, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('555548a1-8767-4637-b9ac-d333d1d399ce', 'asdf', 0.00, '', '2022-08-19 15:44:39', '2022-08-19 15:44:39', NULL, 1, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('556ae0c6-ea02-4886-939d-6f3dd47f0d64', 'aaaa', 123163.00, '', '2022-06-22 08:12:56', '2022-07-11 10:37:13', '2022-07-11 10:37:13', 1, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('5d15ebe2-202e-495c-95ab-31ac5359e016', '赵云的账本', 100.00, '', '2022-05-11 14:01:41', '2022-08-12 16:39:45', NULL, 0, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('769a2d0e-5289-4310-a1d4-a9b38bb18fcd', '麦琪的账本', 0.00, '', '2022-03-21 21:05:37', '2022-08-09 22:19:01', NULL, 0, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('77e0c925-5b00-4d05-a309-bb88e4f7f32c', '张三的账本', 1000.00, '', '2022-03-24 10:15:12', '2022-06-04 20:49:17', NULL, 0, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('7aeb230b-5af6-438d-8678-c7350ece5265', '我的账本', 15978.98, 'asdsads', '2022-03-21 21:05:22', '2022-08-12 16:39:44', NULL, 0, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('8cb3d4e9-542f-4f5b-85a3-efae65718fc4', '1', 0.00, '1', '2022-07-11 13:02:42', '2022-07-11 13:02:51', '2022-07-11 13:02:51', 1, ''); INSERT INTO `account_book` (`id`, `name`, `balance`, `remark`, `created_at`, `updated_at`, `deleted_at`, `is_default`, `user_id`) VALUES ('a08074cf-4c68-43c6-9d44-c212ed139e8c', '我的账本', 0.00, '', '2022-11-11 11:30:36', ' [ERR] 1046 - No database selected [ERR] INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0aabb7ae-1e5e-4193-8a65-cd1b8cfd2f74', 'admin', '::1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-04-28 16:33:08', '2022-04-28 16:33:08', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0b10d4e4-4cec-4a6a-a892-6f7985a911be', 'admin', '192.168.0.117', 'Mozilla/5.0 (Linux; Android 11; Redmi K30 Pro Build/RKQ1.200826.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/90.0.4430.210 Mobile Safari/537.36 uni-app Html5Plus/1.0 (Immersed/34.909092)', '2022-08-22 14:39:48', '2022-08-22 14:39:48', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0b20f785-7659-42ae-ade3-985993b1609c', 'admin', '113.93.236.251', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-06-04 21:36:20', '2022-06-04 21:36:20', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0d443429-9059-4a1c-a75c-f318ff27fbe6', 'admin', '104.225.154.97', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-17 11:11:25', '2022-05-17 11:11:25', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0e017486-03c2-480e-b1e4-6a57f2a23cd1', 'admin', '113.25.116.24', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36', '2022-08-13 20:38:13', '2022-08-13 20:38:13', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0ef72364-5b63-4d8e-9e74-b23ace2f76d6', 'admin', '218.107.215.114', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0', '2022-08-10 13:11:21', '2022-08-10 13:11:21', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0ef7dbee-703a-4951-a999-7207c21223de', 'admin', '119.86.105.243', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36 Edg/101.0.1210.47', '2022-05-15 11:08:58', '2022-05-15 11:08:58', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0f003f38-fb7e-4709-b676-c25abb3e6883', 'admin', '::1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', '2022-05-13 15:20:04', '2022-05-13 15:20:04', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0f00bd06-7839-4b95-a107-50279f037b45', 'admin', '123.117.119.22', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-05-14 14:26:52', '2022-05-14 14:26:52', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0f5c8383-b0e9-4e17-b278-10a2bb6da88c', 'admin', '183.192.10.206', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36 Edg/100.0.1185.29', '2022-04-06 14:25:32', '2022-04-06 14:25:32', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('10fa3ab5-1d5d-4040-99e5-f571cd0a923c', 'admin', '218.107.215.114', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0', '2022-08-10 12:50:26', '2022-08-10 12:50:26', NULL); INSERT INTO `system_login_log` [ERR] 1046 - No database selected [ERR] INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7c540c94-b620-4da0-897d-5ff9ccc77dba', 'admin', '27.192.243.91', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-04-28 15:20:27', '2022-04-28 15:20:27', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7c79dc16-d7e5-46ba-b1da-c7e52c237a75', 'admin', '113.93.236.251', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-06-04 20:50:59', '2022-06-04 20:50:59', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7d1fb489-6d7e-486b-a18f-bcc02b08b9e8', 'admin', '113.93.236.251', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-06-04 21:48:50', '2022-06-04 21:48:50', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7d9961ec-0ed0-4686-a715-79e8ccaf6544', 'admin', '27.192.243.91', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36', '2022-07-15 16:02:30', '2022-07-15 16:02:30', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e0d6ac1-d29c-4d44-9585-bf4a868a133b', 'admin', '223.90.190.139', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-06-12 21:35:55', '2022-06-12 21:35:55', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e178c71-2917-414d-a729-d780485b9961', 'admin', '27.192.243.91', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36', '2022-07-27 15:00:36', '2022-07-27 15:00:36', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e692b0d-90be-4a2f-a203-bae05af7a22e', 'admin', '::1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36', '2022-05-19 15:56:21', '2022-05-19 15:56:21', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e6a42b2-1ac4-49da-84c7-eaf7d39d9ca3', 'admin', '123.116.118.143', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-07-13 18:35:19', '2022-07-13 18:35:19', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e7d9c4f-dbef-4df6-85ed-3705dce9ee17', 'admin', '::1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', '2022-05-13 15:51:30', '2022-05-13 15:51:30', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e8d3b8b-e095-41d4-8972-a64eef4c312d', 'admin', '120.230.95.3', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36', '2022-08-21 21:15:19', '2022-08-21 21:15:19', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7f467e12-2e24-4b9e-b070-f5fcde12a377', 'admin', '171.43.154.37', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', '2022-06-15 10:58:33', '2022-06-15 10:58:33', NUL [ERR] 1046 - No database selected [ERR] INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dfdda37d-0ff8-446d-9a3f-28cd499602b0', 'admin', '114.249.59.167', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', '2022-05-25 17:37:31', '2022-05-25 17:37:31', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dffecc8c-fd69-47ec-8bde-ee676ec2e0dd', 'admin', '27.192.243.91', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.61 Safari/537.36', '2022-06-09 09:40:36', '2022-06-09 09:40:36', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e0034024-11af-4d70-8289-d79d61d90c54', 'admin', '115.52.147.184', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.124 Safari/537.36 Edg/102.0.1245.44', '2022-06-22 15:20:27', '2022-06-22 15:20:27', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e0117d93-af7d-4905-a8c3-759f86153a40', 'admin', '112.19.161.118', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-05-13 16:52:45', '2022-05-13 16:52:45', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e04808a7-e11f-4854-a695-eaa8d2b34ace', 'admin', '183.202.60.56', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-05-22 16:47:40', '2022-05-22 16:47:40', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e0bf1d11-7118-478d-a294-478eec21bb43', 'admin', '120.219.35.209', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Safari/537.36 Edg/103.0.1264.49', '2022-07-11 10:20:53', '2022-07-11 10:20:53', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e42f73b3-9e2d-46ae-9243-f4dde670e7fa', 'admin', '112.19.161.118', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-05-13 16:49:09', '2022-05-13 16:49:09', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e459576d-c8ac-4108-ac6c-b7760d2d7838', 'admin', '115.216.34.150', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36', '2022-03-31 19:10:28', '2022-03-31 19:10:28', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e63d4b79-5f80-4681-b7e0-0728b8521fc0', 'admin', '58.210.190.62', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) LanMiaoDesktopOnline/1.0.0 Chrome/100.0.4896.75 Electron/18.0.3 Safari/537.36', '2022-06-22 17:51:16', '2022-06-22 17:51:16', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e71648a0-dea6-4161-bca9-b221d5f50b4b', 'admin', '36.20.2.34', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36', '2022-07-10 21:16:38', '2022-07-10 21:16:38', NULL); INSERT INTO `system_login_log` (`id`, `username`, `ip`, `ua`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e757638b-21d8-4edf-bdfa-cd4de1b8e6f4', 'zhangsan', '123.232.218.101', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36', '2022-03-24 10:20:21', '2022-03-24 10:20:21', NULL); INSERT [ERR] 1046 - No database selected [ERR] INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3630b5db-1b30-469a-a75f-2eb5ae623dc2', '1', '2eec2887-f281-4634-9784-a4acff8c2264', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-11-28 13:23:03', '2022-11-28 13:23:03', '2022-11-29 16:40:41'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('37bd9d76-673f-40ef-b8cf-179c3ad0059d', '1', '46b5dce2-6ea1-4c5e-8a76-e622b01b33e4', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-08-22 14:39:48', '2022-08-22 14:39:48', '2022-08-22 14:40:34'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('38b71497-e852-40f5-8c46-b532c60d3264', '1', '93f95a5f-b642-4fd9-8614-f4f9c17c1239', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-08-16 10:44:57', '2022-08-16 10:44:57', '2022-08-16 22:32:51'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('38e28c55-b89f-49a3-99c8-2d602aa25ac5', '1', '6d79da00-2a8f-4cb2-b59f-6bbf545e6d05', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-05-30 14:56:46', '2022-05-30 14:56:46', '2022-05-31 08:26:43'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('392844c6-7295-4fa0-893a-cb14d11f78b9', '1', '0ac845c8-182b-428c-bbbe-471cc5730b75', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-06-04 20:50:59', '2022-06-04 21:36:12', '2022-06-04 21:36:12'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('395b3e7b-8188-4282-b147-154ce4e29a8b', '1', '1aa7c93f-d06e-445a-860b-334eff9a1ac9', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-06-22 11:56:46', '2022-06-22 11:56:46', '2022-06-22 15:20:27'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3a79be19-04fa-465f-9152-72f590e1a09f', '1', 'f1d43cfb-c43f-40e8-a686-fefb573f636b', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-05-25 14:01:05', '2022-05-25 14:01:05', '2022-05-25 15:03:19'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3b2fa303-68bc-4bc7-8110-9d303125d5c7', '1', 'fe39e65d-7ff1-44e7-b64d-bd33038ecdd9', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-08-22 11:53:54', '2022-08-22 11:53:54', '2022-08-22 12:03:54'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3bac61da-9f58-4978-8667-07961e4ad525', '1', '542920da-d556-4544-86e7-014c0233a4b4', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-05-11 14:36:26', '2022-05-11 14:36:26', '2022-05-11 14:40:23'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3bd85714-a8f2-4414-a587-96d809df2bb6', '1', '92deab33-2b86-4661-a281-10f98aa3359c', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-08-03 16:09:58', '2022-08-03 16:09:58', '2022-08-04 10:55:28'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3bfe5887-6a62-428a-9d8c-2ab80d3bd7ec', '1', 'c742d219-ce9e-47f0-9a94-33a81f99c8fc', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-06-11 23:46:53', '2022-06-11 23:46:53', '2022-06-12 11:31:43'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3c82c1d1-c620-4443-ae42-8bd115eb4bd2', '1', '186ab3d6-a458-41ce-8442-0d37f2ef2179', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-08-22 14:40:57', '2022-08-22 14:40:57', '2022-08-22 14:41:13'); INSERT IN [ERR] 1046 - No database selected [ERR] INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b00ffdba-d17b-40a8-87aa-3c97e0acad6c', '1', '93e992f3-e5f4-44a4-945c-0bdc3935bede', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-09-26 16:26:52', '2022-09-26 16:26:52', '2022-09-27 09:18:43'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b06a7a2a-3ac6-402e-9e07-228a3f1afcc9', '1', '80c69a61-eaec-4ada-81da-3393b188d6c9', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-06-09 09:40:36', '2022-06-09 09:40:36', '2022-06-09 11:40:54'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b20370b9-ef2c-4645-8913-f87d4543c25d', '1', 'b278e088-516c-4771-92fe-a9d75941a743', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-05-11 15:18:10', '2022-05-11 15:18:10', '2022-05-11 15:22:49'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b23dfb6e-6738-49f7-b442-b05727fdfc1a', '1', '42ced733-93cb-4301-accb-acc7debbde85', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-05-31 14:48:25', '2022-05-31 16:54:12', '2022-05-31 16:54:12'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b31fbe7b-02ec-43df-a6bb-ca9567eb5670', '1', 'a0653450-05e2-4589-bc26-8f6c8aaa3c50', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-12-02 20:38:03', '2022-12-02 20:38:03', '2022-12-02 21:00:27'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b3255f3d-985b-42ca-8d1e-0a221b66be9d', '1', 'cbac6172-cbba-4ebc-9f01-a4f3f1bd8387', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-05-09 17:06:24', '2022-05-09 17:06:24', '2022-05-10 09:36:25'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b3f4c45a-76a6-4bcb-873f-c4067f28fa25', '1', 'ad7e932e-7730-41da-9f0f-596ea043712b', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-08-20 10:57:55', '2022-08-20 10:57:55', '2022-08-20 15:59:12'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b462a9e4-e989-4779-a38b-a5a3ddad3fde', '1', 'a0803ab5-b88e-4c4a-b727-501a3ad45ae0', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-07-12 09:33:27', '2022-07-12 09:33:27', '2022-07-12 09:56:35'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b67e7253-b421-4fc6-9acf-b65e65804c29', '1', 'b0e25f21-6169-412f-9dbd-8f55a497e014', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-05-05 08:32:57', '2022-05-05 08:32:57', '2022-05-05 08:35:58'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b6fe69cb-9b17-479a-a764-9bea161fead3', '1', 'dae2b347-50b1-4427-b2fa-6be75a211f84', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-07-17 18:09:56', '2022-07-17 18:09:56', '2022-07-18 08:43:29'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b77830b7-307c-4639-93a0-d2022b4c9a87', '1', '951fb869-8391-4aa7-9095-5406a9df7f16', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-06-24 15:53:44', '2022-06-24 15:53:44', '2022-06-25 18:24:41'); INSERT INTO `system_session` (`id`, `user_id`, `key`, `password_hash`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b77c7496-8148-42b7-acc5-cf407de3fc08', '1', '60babef9-dd0b-461c-9c7b-ebdec144eb97', '$2a$10$fEfkf66Q91Jyef27VFMBYeYJkX.6aJFcXig7SQtsoixvsdoS0aIOu', '2022-05-22 15:02:54', '2022-05-22 15:02:54', '2022-05-22 16:47:41'); INSERT IN [SQL] Finished with error
最新发布
11-10
CREATE TABLE your_database.users ( -- 创建表时指定所属数据库 id INT PRIMARY KEY, name VARCHAR(50) ); ``` #### ✅ 方法3：连接时指定数据库（编程场景） 在程序连接字符串中直接指定数据库（以JDBC为例）：...
InnoDB: broken FIL_PAGE_NEXT or FIL_PAGE_PREV links 异常处理
Lixora's DB Home
12-01 1357
##问题描述 研发兄弟反馈说，他们的数据库中有一些表不能正常查询。 开发同学在线cats 操作复制测试表，导致linux 服务器目录空间满，然后他们自己强制重启了mysql。。。。。。 mysql-lixora > select * from test_part; ERROR 2013 (HY000): Lost connection to MySQL server during query ##故障日志： 2021-12-01T01:28:14.280281Z 8 [E...
MySQL ERROR 1005: Can't create table (errno: 150)解决办法
xx13202405349的博客
03-16 582
原因之一：设置关联的字段类型不匹配，比如bigint 和 int     解决：外键的相关字段修改成同一类型就可以解决这个问题   原因之二：  解决：1. mysql支持外键约束，数据库类型必须是InnoDB  2.两个都要是InnoDB
MySQL创建外键时报Can‘t create table xxx(errno: 150)错误解决办法
杨的博客
08-03 2264
Can't create table xxx （errno: 150）错误解决办法 第一种情况，很简单，就是列的类型不匹配另外一种情况，虽然数据类型一致了，但是字符编码不一致最后一种情况则是，找不到外键引用的列。 总的来说，这个问题的原因就是创建的外键和关联的表的主键类型不匹配。下面用个简单的例子来说明。 两张很简单的表，学生表和教师表： CREATE TABLE `t_teacher` ( `id` varchar(1
Navicat 创建数据库和表之使用命令创建
alee123456789的博客
02-26 2943
上篇介绍了使用 Navicat 图形化界面创建数据库和表，现在介绍一下使用命令创建数据库和表的方法。 首先，依然是需要一台已经配置好MySQL数据库和安装了Navicat客户端的电脑。 使用命令创建数据库和表的具体步骤如下： 1、使用前一篇的方法连接上MySQL 2、连接上MySQL之后，在连接列表里找到我们的连接，右键单击，选择【命令列界面】，打开命令列界面 ...
navicat创建表格，以及与MySQL命令创建表格的比对
2303_78533660的博客
09-23 1973
根据我这里来，一步一步走，找到一个MySQL数据库，我这里是hehong数据库，鼠标右键点击表，在表旁边新建一个表。然后根据自己的要求，创建一个表，这里我们示范一个分数表，添加下一行点击左上角添加字段。注意：没有建数据库的可以返回上一级，同样操作，鼠标右键点击测试2，建一个数据库。连接名随便弄一个即可，根据个人喜好，然后输入我们的MySQL的密码，打开后会进入到这样一个界面，然后点击左上角连接，我们连接一个数据库。下面是我随便添加的，在一行添加完后，点击下面加号➕，添加下一行。然后我们进入到这样一个界面。
Navicat里MySQL表的创建（详细）
2301_76297780的博客
12-21 6842
我以Navicat连接MySQL为例，演示表的创建方法。
MySQL使用Navicat来创建数据库，创建表，和书写SQL语句
m0_64896985的博客
12-22 1万+
MySQL是一个关系型数据库管理系统 ，由瑞典MySQL AB 公司开发，属于 Oracle 旗下产品。. MySQL 是最流行的 关系型数据库管理系统 之一，在 WEB 应用方面，MySQL是最好的 RDBMS (Relational Database Management System，关系数据库管理系统) 应用软件之一。. MySQL是一种关系型数据库管理系统，关系数据库将数据保存在不同的表中，而不是将所有数据放在一个大仓库内，这样就增加了速度并提高了灵活性。. MySQL所使用的 SQL 语言是..
navicat 创建数据库表步骤
bingmo_的博客
09-13 1万+
create table t_student( uid int(10) not null auto_increment, uname varchar(100) not null, pwd varchar(100) not null, sex char(2) not null, age int(3), birth date, primary key(uid) ) insert into t_student values(default,'张三','123...
创建MySQL数据库和创建表的详细步骤（navicat）
快乐学习
08-12 4万+
一、介绍在创建数据库的时候通常会使用一些可视化的工具来创建数据库和表这些比较方便，使用SQL语句创建的就比较慢。这里要使用的是可视化工具navicat。二、操作步骤这里是Navicat的下载和MySQL的下载步骤，没有安装这两个的可以看看（一）新建连接打开navicat连接MySQL输入连接名和用户名密码这些，输入完成后点击确定就好了连接名：自定义就好了用户名和密码就是自己的MySQL的账号和密码右上角右键刚刚新建的连接，然后点击打开连接（完成后会看到之前其他的数据库，不用管它）
在navicat中创建表格
qq_62392972的博客
01-01 3万+
1、首先登陆Navicat，然后顺利连接数据库，如下图所示。
Microsoft.Graph.ServiceException:“Code: Authorization_RequestDenied Message: Insufficient privileges to complete the operation. Inner error: AdditionalData: date: 2025-07-07T01:52:34 request-id: ab611e0a-4f41-4f6a-b577-46a10f6c8db0 client-request-id: ab611e0a-4f41-4f6a-b577-46a10f6c8db0 ClientRequestId: ab611e0a-4f41-4f6a-b577-46a10f6c8db0 ”
07-08
在调用 Microsoft Graph API 时，遇到 `Authorization_RequestDenied` 错误通常表明请求的应用程序或用户没有足够的权限来访问目标资源。以下是常见的原因及解决方法： ### 检查应用程序的权限配置 确保 Azure AD 应用程序已正确授予所需的 Microsoft Graph 权限。这些权限可以是委派权限（Delegated permissions）或应用程序权限（Application permissions），具体取决于使用场景。例如，如果需要读取所有用户的邮箱设置，应授予 `MailboxSettings.Read` 的应用程序权限[^1]。 ### 确认管理员同意 对于某些高权限范围（如涉及敏感数据的操作），必须由租户管理员进行同意。可以通过导航到 Azure 门户中的应用注册页面，选择“API 权限”，然后点击“为 {租户名称} 授予管理员同意”按钮来完成此操作[^2]。 ### 验证令牌的作用域 检查获取的访问令牌是否包含正确的作用域。可以在解码 JWT 令牌后查看其 `scp` 或 `roles` 声明字段，确认是否包含了预期的权限。若缺少必要的作用域，则需更新应用的权限请求并重新获取令牌[^3]。 ### 使用具有足够权限的用户账户 如果是使用委派权限的情况，请确保用于登录的用户账户拥有执行该操作所需的权限。例如，在尝试修改其他用户的信息时，当前用户可能需要属于全局管理员角色[^4]。 ### 示例：获取和验证访问令牌 以下是一个简单的 Python 脚本示例，演示如何使用 MSAL 库从 Azure AD 获取访问令牌，并打印出解码后的令牌信息以检查其作用域： ```python import msal # 配置参数 client_id = 'YOUR_CLIENT_ID' authority = 'https://login.microsoftonline.com/YOUR_TENANT_ID' client_secret = 'YOUR_CLIENT_SECRET' # 创建客户端应用实例 app = msal.ConfidentialClientApplication( client_id, authority=authority, client_credential=client_secret ) # 请求访问令牌 result = app.acquire_token_for_client(scopes=["https://graph.microsoft.com/.default"]) if "access_token" in result: # 解析 JWT 令牌 import jwt decoded_token = jwt.decode(result['access_token'], options={"verify_signature": False}) print(decoded_token) else: print(result.get("error")) print(result.get("error_description")) ``` ### 相关问题 1. 如何在 Azure AD 中为应用注册添加 Microsoft Graph API 权限？ 2. 怎样通过编程方式检查 Microsoft Graph 访问令牌的有效性和作用域？ 3. 如果非管理员用户试图执行需要更高权限的操作会怎样？ 以上步骤可以帮助诊断并修复由于权限不足而导致的 `Authorization_RequestDenied` 错误。如果问题依旧存在，建议查阅详细的错误消息以及日志记录进一步排查。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

烟火里的尘埃.

有问题可以留言

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值