Guest User

Untitled

a guest
Nov 14th, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. call portableshell.bat
  2. perl C:UsersuserDesktopperl 32 bitstest3.pl
  3.  
  4. use DBI;
  5. use Sys::Hostname ();
  6.  
  7. $hostname = Sys::Hostname::hostname();
  8. $hostname_cstep_table = $hostname . '_cstep_table';
  9.  
  10. # Connect to the database.
  11. my $dbh = DBI->connect("DBI:mysql:database=db;host=ip",
  12. "", '',
  13. {'RaiseError' => 1});
  14.  
  15. #on peut utiliser insert mais il y aura des doublons et ici on est dans une table unique
  16. my $sth = $dbh->prepare("SHOW TABLES LIKE '$hostname_cstep_table';")
  17.  
  18. or die "prepare statement failed: $dbh->errstr()";
  19. $sth->execute() or die "execution failed: $dbh->errstr()";
  20.  
  21. #affiche 0 ou 1, selon la table qui est trouvé
  22. $row = $sth->rows;
  23.  
  24. if ($row eq 1) {
  25.  
  26. print $hostname_cstep_table . " has created";
  27.  
  28. }
Add Comment
Please, Sign In to add comment