Skip to content

Instantly share code, notes, and snippets.

@xx19941215

xx19941215/sql

Created June 14, 2019 07:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save xx19941215/56e32637bd67c3d0113d81b5bb21b5a9 to your computer and use it in GitHub Desktop.
Save xx19941215/56e32637bd67c3d0113d81b5bb21b5a9 to your computer and use it in GitHub Desktop.
Download ZIP
mysql预查询例子
Raw
sql
PREPARE prod FROM "select count(*) as aggregate from `t_letter_dep` where `id` = ? and (`site_id` = ?)";
set @p = '1; truncate table log_access;';
set @q = '3';
execute prod using @p,@q;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment