- or download this
#!/usr/bin/perl
...
}
} );
} );
- or download this
swilson@swilson-mbp-vdebian:~/perl/test$ ./test.pl
DBIx::Class::ResultSet::find_or_create(): DBI Exception: DBD::mysql::s
+t execute failed: You have an error in your SQL syntax; check the man
+ual that corresponds to your MySQL server version for the right synta
+x to use near 'MORE_DAT 'more blah' AND me.data SOME_DAT 'blah' ) AND
+ me.pk IS NULL ) )' at line 1 [for Statement "SELECT me.pk, me.data_f
+k FROM main me WHERE ( ( ( me.data MORE_DAT ? AND me.data SOME_DAT ?
+) AND me.pk IS NULL ) )" with ParamValues: 0='more blah', 1='blah'] a
+t ./test.pl line 16
- or download this
mysql> show create table main;
...
+-------+-------------------------------------------------------------
+---------------------------------------------------------------------
+---------------------------------------------------------------------
+---------------+
1 row in set (0.00 sec)
- or download this
mysql> show create table info1;
...
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-------------------------------------------------------------
+---------------------------------------------------------------------
+---------------------------------------------------------------------
+---------------------------------------------------------------------
+---------------+
1 row in set (0.00 sec)