X hits on this document

164 views

0 shares

0 downloads

0 comments

43 / 70

Fast Import: One INSERT

animals = [ Animal.new(:name => 'dolly dolphin',

                      :password => 'dolly'),

           Animal.new(:name => 'big birdie',

                      :password => 'birdie')]

Animal.import animals

INSERT INTO `animals`

(`id`,`name`,`email`,`fav_beer`,`created_at`,`updated_at`,`password`)

VALUES

(NULL,'dolly dolphin',NULL,'Pabst',

'2009-03-20 00:17:15','2009-03-20 00:17:15','dolly'),

(NULL,'big birdie',NULL,'Pabst',

'2009-03-20 00:17:15','2009-03-20 00:17:15','birdie')

ON DUPLICATE KEY UPDATE `animals`.`updated_at`=VALUES(`updated_at`)

Document info
Document views164
Page views164
Page last viewedWed Dec 07 10:46:23 UTC 2016
Pages70
Paragraphs654
Words2352

Comments