- 论坛徽章:
- 0
|
SQLNamedQuery update-quota-tally FREEFORM \
"UPDATE ftpquotatallies SET bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'"
SQLNamedQuery insert-quota-tally FREEFORM \
"INSERT INTO ftpquotatallies VALUES ('%{0}','%{1}','%{2}','%{3}','%{4}','%{5}','%{6}','%{7}')"
去掉\,把每个语句都变成一行 |
|