代码拉取完成,页面将自动刷新
通过硬编码的方式实现多语句分割并且支持定界符。
微信公众号:上下博客
SHOW DATABASES;
CREATE USER name IDENTIFIED BY 'aaa"=bbb,ccc';
SET PASSWORD FOR name=PASSWORD('fdddfd');
SHOW GRANTS FOR name;
GRANT SELECT ON db_name.* TO name;
SHOW DATABASES;
DELETE FROM tb_name WHERE id=3;
DELIMITER $$
CREATE PROCEDURE pro(
IN num INT,OUT total INT)
BEGIN
SELECT SUM(score) INTO total FROM tb_name WHERE id=num;
END$$
DELIMITER ;
DROP PROCEDURE pro;
[
[ 'SHOW', 4 ], [ 'DATABASES', 14 ], [ ';', 14 ],
[ 'CREATE', 22 ], [ 'USER', 27 ], [ 'name', 32 ],
[ 'IDENTIFIED', 43 ], [ 'BY', 46 ], [ "'", 47 ],
[ 'aaa"=bbb,ccc', 60 ], [ "'", 60 ], [ ';', 61 ],
[ 'SET', 66 ], [ 'PASSWORD', 75 ], [ 'FOR', 79 ],
[ 'name', 84 ], [ '=', 84 ], [ 'PASSWORD', 93 ],
[ '(', 93 ], [ "'", 94 ], [ 'fdddfd', 101 ],
[ "'", 101 ], [ ')', 102 ], [ ';', 103 ],
[ 'SHOW', 109 ], [ 'GRANTS', 116 ], [ 'FOR', 120 ],
[ 'name', 125 ], [ ';', 125 ], [ 'GRANT', 132 ],
[ 'SELECT', 139 ], [ 'ON', 142 ], [ 'db_name.*', 152 ],
[ 'TO', 155 ], [ 'name', 160 ], [ ';', 160 ],
[ 'SHOW', 166 ], [ 'DATABASES', 176 ], [ ';', 176 ],
[ 'DELETE', 184 ], [ 'FROM', 189 ], [ 'tb_name', 197 ],
[ 'WHERE', 203 ], [ 'id', 206 ], [ '=', 206 ],
[ '3', 208 ], [ ';', 208 ], [ 'DELIMITER', 219 ],
[ '$$', 222 ], [ 'CREATE', 229 ], [ 'PROCEDURE', 239 ],
[ 'pro', 243 ], [ '(', 243 ], [ 'IN', 251 ],
[ 'num', 255 ], [ 'INT', 259 ], [ ',', 259 ],
[ 'OUT', 263 ], [ 'total', 269 ], [ 'INT', 273 ],
[ ')', 273 ], [ 'BEGIN', 284 ], [ 'SELECT', 295 ],
[ 'SUM', 299 ], [ '(', 299 ], [ 'score', 305 ],
[ ')', 305 ], [ 'INTO', 311 ], [ 'total', 317 ],
[ 'FROM', 322 ], [ 'tb_name', 330 ], [ 'WHERE', 336 ],
[ 'id', 339 ], [ '=', 339 ], [ 'num', 343 ],
[ ';', 343 ], [ 'END', 351 ], [ '$$', 354 ],
[ 'DELIMITER', 364 ], [ ';', 365 ], [ 'DROP', 371 ],
[ 'PROCEDURE', 381 ], [ 'pro', 385 ], [ ';', 385 ]
]
SHOW DATABASES;
0 15
-----------------------
CREATE USER name IDENTIFIED BY 'aaa"=bbb,ccc';
15 62
-----------------------
SET PASSWORD FOR name=PASSWORD('fdddfd');
62 104
-----------------------
SHOW GRANTS FOR name;
104 126
-----------------------
GRANT SELECT ON db_name.* TO name;
126 161
-----------------------
SHOW DATABASES;
161 177
-----------------------
DELETE FROM tb_name WHERE id=3;
177 209
-----------------------
DELIMITER $$
209 223
-----------------------
CREATE PROCEDURE pro(
IN num INT,OUT total INT)
BEGIN
SELECT SUM(score) INTO total FROM tb_name WHERE id=num;
END$$
223 355
-----------------------
DELIMITER ;
355 366
-----------------------
DROP PROCEDURE pro;
366 386
-----------------------
[Done] exited with code=0 in 0.444 seconds
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
1. 开源生态
2. 协作、人、软件
3. 评估模型