Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re^4: MySQL insert via DBI

by AlexTape (Monk)
on Sep 20, 2011 at 09:18 UTC ( #926873=note: print w/replies, xml ) Need Help??

in reply to Re^3: MySQL insert via DBI
in thread MySQL insert via DBI

im not using fork e.g.
there is no code excluded. because its not necessary to implement not working code ;-)
CREATE TABLE `table_1` (<br> `ID` int(11) NOT NULL AUTO_INCREMENT,<br> `version` varchar(200) NOT NULL,<br> `filename` varchar(200) NOT NULL,<br> `size` int(11) DEFAULT NULL,<br> `MD5_checksum` varchar(200) DEFAULT NULL,<br> `release_notes` varchar(200) NOT NULL,<br> `remark` varchar(2000) DEFAULT NULL,<br> `rec_level` int(11) NOT NULL,<br> `date_rec_green` date DEFAULT NULL,<br> `date_rec_yellow` date DEFAULT NULL,<br> `date_rec_red` date DEFAULT NULL,<br> `date_compl_green` date DEFAULT NULL,<br> `date_comp_yellow` date DEFAULT NULL,<br> `date_compl_red` date DEFAULT NULL,<br> `os_type` int(11) DEFAULT NULL,<br> `feature_set` int(11) DEFAULT NULL,<br> PRIMARY KEY (`ID`),<br> UNIQUE KEY `ID_UNIQUE` (`ID`),<br> KEY `fk_firmware_rec_level` (`rec_level`),<br> KEY `fk_firmware_os_type` (`os_type`),<br> KEY `fk_firmware_feature_set` (`feature_set`),<br> CONSTRAINT `fk_firmware_feature_set` FOREIGN KEY (`feature_set`) REF +ERENCES <br>`nl_firmware_feature_set` (`ID`) ON DELETE NO ACTION ON U +PDATE NO ACTION,<br> CONSTRAINT `fk_firmware_os_type` FOREIGN KEY (`os_type`) REFERENCES +<br>`nl_firmware_os_type` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACT +ION,<br> CONSTRAINT `fk_firmware_rec_level` FOREIGN KEY (`rec_level`) REFEREN +CES <br>`nl_firmware_rec_level` (`ID`) ON DELETE NO ACTION ON UPDATE +NO ACTION<br> ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8$$<br>

im completly new to this topic for this i hope that this is the scheme that helps a lil...
$perlig =~ s/pec/cep/g if 'errors expected';

Replies are listed 'Best First'.
Re^5: MySQL insert via DBI
by moritz (Cardinal) on Sep 20, 2011 at 09:21 UTC

    This is not the schema you are using.

    If you want us to help you, you should make it easy for us to help you, by providing enough and precise data. Why are you making it deliberatly hard for us?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://926873]
[holli]: exactly, moritz
[moritz]: with a big table of redirects to support the old links
[LanX]: do it
[holli]: well if you put some cleverness into the migration you can auto convert most of the links as well
[LanX]: Let's Make PerlMonks Great Again!
[holli]: but you know what? i don't think i'd fancy that. I like PM as it is.
[holli]: Alone the chatterbox and everybody writes his own cb client tradition
[LanX]: there was a guy who tried to steal the concept and build an own monastery ...
[LanX]: yeah PM is very emacsy ;-)
[LanX]: I think tobyink was on a good track with his redesign, pitty the pmdevs/gods didn't try to continue the approach of a modern responsive design

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (9)
As of 2017-11-20 19:37 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (292 votes). Check out past polls.