select id, menu_id, role_id from blade_role_menu where role_id = '1810952476179927041,1810952551387' 为什么自动取逗号之前的
在SQL语句中，使用逗号分隔多个条件时，只能用逗号分隔在IN操作符中的多个值。如果将多个条件放在一个字符串中并用逗号分隔，数据库会将该字符串作为一个整体进行匹配，而不会按照逗号拆分字符串。在这种情况下，数据库会将整个字符串作为一个条件进行匹配，而不是根据逗号分隔进行匹配。查询结果只会返回满足整个字符串条件的记录，而不会返回满足逗号分隔条件的记录。 [2024-07-11 10:29:54 | AI写代码神器 | 240点数解答]
相关提问
- select id, menu_id, role_id from blade_role_menu where role_id = '1810952476179927041,1810952551387' role_id 是long 类型，查询的时候，为什么自动取逗号之前的，没有按字符串查找（264点数解答 | 2024-07-11 10:30:59）193
- select id, menu_id, role_id from blade_role_menu where role_id = '1810952476179927041,1810952551387' 为什么自动取逗号之前的（240点数解答 | 2024-07-11 10:29:54）136
- [{id:1,src:'/1.jpg'},{id:2,src:'null'},{id:3,src:'/2.jpg'},{id:4,src:'null'},{id:5,src:'/3.jpg'},{id:6,src:'null'}] js转换[{id:1,src:'/1.jpg'},{id:2,src:'/2.jpg'},{id:3,src:'/3.jpg'},{id:4,src:'null'},{id:5,src:'{id:4,src:'null'},'},{id:6,src:'null'}]（680点数解答 | 2025-08-04 17:09:03）62
- 帮我优化一下这个sql, 得到的结果是一样的 select to_char(sysdate, 'yyyymmdd') from dual union select to_char(sysdate-1, 'yyyymmdd') from dual union select to_char(sysdate-2, 'yyyymmdd') from dual union select to_char(sysdate-3, 'yyyymmdd') from dual union select to_char(sysdate-5, 'yyyymmdd') from dual（357点数解答 | 2024-08-14 20:08:27）318
- 我想得到最近30天内的日期, 比如这样的sql, 但太冗余了, 有没有简化的办法, oracle库里执行: select to_char(sysdate, 'yyyymmdd') from dual union select to_char(sysdate-1, 'yyyymmdd') from dual union select to_char(sysdate-2, 'yyyymmdd') from dual union select to_char(sysdate-3, 'yyyymmdd') from dual union select to_char(sysdate-5, 'yyyymmdd') from dual（320点数解答 | 2024-08-14 20:11:26）189
- 用c语言实现一个64位地址— select [0] = (6^11^16^…^51) — select [1] = (7^12^17^…^47) — select [2] = (8^13^18^…^48) — select [3] = (9^14^19^…^49) — select [4] = (10^15^20^…^50)（312点数解答 | 2024-11-19 15:34:19）134
- <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>2048 Game</title> <link rel="stylesheet" href="style.css"> </head> <body> <header> <h1>2048</h1> <button id="newGameButton">New Game</button> <p>Score: <span id="score">0</span></p> </header> <div id="grid-container"> <div class="grid-cell" id="grid-cell-0-0"></div> <div class="grid-cell" id="grid-cell-0-1"></div> <div class="grid-cell" id="grid-cell-0-2">（138点数解答 | 2025-03-05 15:45:36）243
- <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>2048 Game</title> <link rel="stylesheet" href="style.css"> </head> <body> <header> <h1>2048</h1> <button id="newGameButton">New Game</button> <p>Score: <span id="score">0</span></p> </header> <div id="grid-container"> <div class="grid-cell" id="grid-cell-0-0"></div> <div class="grid-cell" id="grid-cell-0-1"></div> <div class="grid-cell" id="grid-cell-0-2">（117点数解答 | 2025-03-11 00:06:25）181
- <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>2048 Game</title> <link rel="stylesheet" href="style.css"> </head> <body> <header> <h1>2048</h1> <button id="newGameButton">New Game</button> <p>Score: <span id="score">0</span></p> </header> <div id="grid-container"> <div class="grid-cell" id="grid-cell-0-0"></div> <div class="grid-cell" id="grid-cell-0-1"></div> <div class="grid-cell" id="grid-cell-0-2">（201点数解答 | 2025-04-19 11:50:42）112
- <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>2048 Game</title> <link rel="stylesheet" href="style.css"> </head> <body> <header> <h1>2048</h1> <button id="newGameButton">New Game</button> <p>Score: <span id="score">0</span></p> </header> <div id="grid-container"> <div class="grid-cell" id="grid-cell-0-0"></div> <div class="grid-cell" id="grid-cell-0-1"></div> <div class="grid-cell" id="grid-cell-0-2">（181点数解答 | 2025-04-29 20:58:02）110
- <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>2048 Game</title> <link rel="stylesheet" href="style.css"> </head> <body> <header> <h1>2048</h1> <button id="newGameButton">New Game</button> <p>Score: <span id="score">0</span></p> </header> <div id="grid-container"> <div class="grid-cell" id="grid-cell-0-0"></div> <div class="grid-cell" id="grid-cell-0-1"></div> <div class="grid-cell" id="grid-cell-0-2">（202点数解答 | 2025-05-27 00:27:24）146
- #include <iostream> #include <iomanip> #include <string> using namespace std; struct < n; i++) { char id[30], title[100]; float price book { ; cin >> id >> title >> price; // string id; // 书号 读入书号、书名和价格 addbook(id, title, price); cin.ignore(); // 处理掉 string title; // 书换行符 } // 输入查找次数 cin >> m; //名 float price; // 价格 查找每 book* next; // 指向下一个节点的指次针 }; class booklist { public: booklist() : head指定(nullptr)位置 {} void addbook(const string& id, const string& title, float price) { book* newbook =（2245点数解答 | 2024-12-18 09:06:13）152