mysql> show create procedure truncate_all_data;
| Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation |
+-------------------+----------+------------------------------------------------------+----------------------+----------------------+--------------------+
| truncate_all_data | | CREATE DEFINER=`amp_db_user`@`localhost` PROCEDURE `truncate_all_data`()
BEGIN
truncate table file_capture_events;
truncate table capture_files;
call sp_audit('truncate_all_data','Call truncate_all_data store procedure');
END | latin1 | latin1_swedish_ci | latin1_swedish_ci |
+-------------------+----------+------------------------------------------------------+----------------------+----------------------+--------------------+
1 row in set (0.00 sec)
Subscribe to:
Post Comments (Atom)
-
Step 1, New a project rails new demo Step 2, Update Gemfile add paperclip, mysql2 gem, enable JavaScript runtime gem 'mysql2' ...
-
I used 7z to zip this file under Windows, try to unzip it under linux [ang@walker temp]$ gunzip 2011.sdf.zip gunzip: 2011.sdf.zip: unkno...
-
When trying to access transmission from web-browswer i got the message : 403: Forbidden Unauthorized IP Address. Either disable the IP ad...
No comments:
Post a Comment