Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- call portableshell.bat
- perl C:UsersuserDesktopperl 32 bitstest3.pl
- use DBI;
- use Sys::Hostname ();
- $hostname = Sys::Hostname::hostname();
- $hostname_cstep_table = $hostname . '_cstep_table';
- # Connect to the database.
- my $dbh = DBI->connect("DBI:mysql:database=db;host=ip",
- "", '',
- {'RaiseError' => 1});
- #on peut utiliser insert mais il y aura des doublons et ici on est dans une table unique
- my $sth = $dbh->prepare("SHOW TABLES LIKE '$hostname_cstep_table';")
- or die "prepare statement failed: $dbh->errstr()";
- $sth->execute() or die "execution failed: $dbh->errstr()";
- #affiche 0 ou 1, selon la table qui est trouvé
- $row = $sth->rows;
- if ($row eq 1) {
- print $hostname_cstep_table . " has created";
- }
Add Comment
Please, Sign In to add comment