Hi, I'm a newcomer on the list so please forgive me I hit an old bug ;-). I've a couple of hashes of arrays of arrays I need to insert to my sql tables. I pass them from subs to the main in order to do sql. Data in the tables are already sorted and are checked. When I do the insert I see something strange: Fields are filled unordered just like my "auto_increment" column was not in sync with my "for" loop.
I give some code and a table description in an attachment. I work with mysql 3.23.39, DBI 1.15, and DBD::mysql 2.0419. I did some sql before but never meat this. What's wrong ? Can anybody explain it to me ? -- Michal Kurowski <[EMAIL PROTECTED]>
+-------------+------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default
|| Extra |
+-------------+------------------------------------------------+------+-----+---------+----------------+
| internal_id | int(6) unsigned | | PRI | NULL
|| auto_increment |
| job_id | int(6) | | | 0
|| |
| gods | enum('1','2','3','4','5','6','7','8','9','10') | | | 1
|| |
| pdb | varchar(8) | | |
|| |
| score | varchar(12) | | |
|| |
| start | int(5) | | | 0
|| |
| seq | text | | |
|| |
| ss | text | | |
|| |
+-------------+------------------------------------------------+------+-----+---------+----------------+
code.pl
Description: Perl program
