in reply to Re^9: Relational table with perl DBI
in thread Relational table with perl DBI

What does your event-table look like? It seems there is no column named event (even though your original post showed there should be).
Once again, the insert query fails, $inserted_records becomes undef which doesn't quite compare to a number.

Replies are listed 'Best First'.
Re^11: Relational table with perl DBI
by M15U (Acolyte) on Mar 14, 2013 at 10:38 UTC

    Well it looks like this :

    $create_query = qq{
        create table event(
            id_event int(10) auto_increment NOT NULL,
            event MEDIUMTEXT COLLATE utf8_general_ci,
            primary key (id_event)
        )
    };
    $dbh->do($create_query);

    [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom