hd_delete_all.pl - delete all records which table names and IDs are written in a file.
This documentation refers to hd_delete_all.pl version 0.0.5
$ hd_delete_all.pl --infile inserted.yml -d mydb -u myuser -p mypasswd
-i | --in | --infile
(Required) a file name of YAML in which tables and IDs to be deleted are written like the followings:
--- customer: - 50 - 51 item: - 101 - 102 purchase: - 501 - 502 - 503
-d | --dbname
(Required) A name of database
-h | --host
(Optional) Hostname of database
--port
(Optional) Port no.
-u | --user
(Required) User name to connect mysql
-p | --password
(Required) Password to connect mysql
-v | --verbose
(Optional) Display verbose messages.
This scripts deletes all records specified by YAML file, which is generated by hd_insert_bulk.pl (included in this package). Of course manually created YAML file can also be used.
There are no known bugs in this module. Please report problems to Takashi Egawa (egawa.takashi at gmail com) Patches are welcome.
egawa.takashi at gmail com
Data::HandyGen::mysql hd_insert_bulk.pl
Takashi Egawa (egawa.takashi at gmail com)
Copyright (c)2013 Takashi Egawa (egawa.takashi at gmail com). All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
To install Data::HandyGen::mysql, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Data::HandyGen::mysql
CPAN shell
perl -MCPAN -e shell install Data::HandyGen::mysql
For more information on module installation, please visit the detailed CPAN module installation guide.