INSERT INTO photos(id, image_thumb,                            image_thumb_tag,                                              image_thumb_width,image_thumb_height,image_small,                                       image_small_width,image_small_height,image_small_tag,                                              image_medium,                                      image_medium_width,image_medium_height,image_large,                                       image_large_width,image_large_height,category,      album_name,              links,                                                scan_quality,title,                         camera,               film,                          date_taken,location,                                                                                                      photographer,   notes)
VALUES(           159, 'andorra_cristina_t.jpg',               'Mountain Walk',                                              100,              65,                'andorra_cristina_s.jpg',                          300,              196,               'Mountain Walk',                                              'andorra_cristina_mn.jpg',                         '780',             '510',              'andorra_cristina_ln.jpg',                         '1024',           '670',             'Outdoors',    'Living Overseas',       '',                                                   'average',   'Mountain Walk',               'Olympus OM10',       'Fuji Superia (100 ASA)',      1026122400,'Andorra',                                                                                                     'Steve Enders', 'We had a nice long walk through fields of flowers, and up to see a lake in the mountains.');
VALUES(           160, 'spain_girona_me_t.jpg',                'Sightseeing Girona',                                         100,              65,                'spain_girona_me_s.jpg',                           300,              196,               'Sightseeing Girona',                                         'spain_girona_me_mn.jpg',                          '780',             '509',              'spain_girona_me_ln.jpg',                          '1024',           '668',             'Outdoors',    'Living Overseas',       '',                                                   'average',   'Sightseeing Girona',          'Olympus OM10',       'Fuji Superia (100 ASA)',      1030978800,'Girona, Catalonia, Spain',                                                                                    'Steve Enders', 'Spent the afternoon walking around Girona with Cristina. We had a nice lunch and then crepes. Yummm.');
VALUES(           161, 'spain_plane_t.jpg',                    'Low Landing!',                                               100,              65,                'spain_plane_s.jpg',                               300,              198,               'Low Landing!',                                               'spain_plane_mn.jpg',                              '780',             '515',              'spain_plane_ln.jpg',                              '1024',           '676',             'Outdoors',    'Living Overseas',       '',                                                   'average',   'Low Landing!',                'Olympus OM10',       'Fuji Superia (100 ASA)',      1032958800,'Empuriabrava, Catalonia, Spain',                                                                              'Steve Enders', 'The planes returning from dropping off skydivers approach the runway nearly touching the rooves of the cars. This driver is slowing down to have a look and get out of the way!.');


foliage


Select id,title from photos

UPDATE photos SET image_additional = '/multimedia/images_misc/maps/australia/australia_green_21.gif' WHERE id = 21;
UPDATE photos SET image_additional = concat(image_additional,'.gif') WHERE id = 21;

delete from photos where id = 29;