Hi all 

Am I on the write track, else assist.


boris this is where I'm at currently:


Could you assist

#!/usr/local/bin/perl

use DBI;
my $dbname     = 'Bruce';
my $dbhostname = 'localhost';
my $user       = 'root';
my $password   = '' ;

CREATE TABLE employee_Info ( 
primary_key INT AUTO_INCREMENT NOT NULL, 
name    CHAR(20), 
surname CHAR(20),
employee_no CHAR(10),
shoe_colour CHAR (10),
PRIMARY KEY (primary_key)
);

my $db = dbi->connect ("dbi:mysql:dbname ; host = $dbhostname;$user;$passwd");

$db->do ("SAVE INTO Employee_Info (primarykey, name, surname, shoecolour, employee_no) 
value(1,'Ambraal','Bruce','White', '9536826')");

$db-> do(" SAVE INTO Employee_Info (primarykey, name, shoecolour, employee _no) 
value(2, 'September', 'John', 'Pink','9536456')");
$db->do("DELETE FROM Employee_Info (

$db->do("UPDATE FROM Employee_Info (

$db->disconnect();
;


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to