Originally I had my ID's set as INT(11) but am going to try using the UUID CHAR(36) for the ID value So I have my old sql INSERT INTO `countries` (`id`, `iso`, `name`, `region`, `flag`) VALUES (1, 'AD', 'Andorra', 'Europe', 'ad'), (2, 'AE', 'United Arab Emirates', 'Middle East', 'flags/ae.gif'), (3, 'AF', 'Afghanistan', 'Asia', ''), (4, 'AG', 'Antigua and Barbuda', 'Central America and the Caribbean', ''), (5, 'AI', 'Anguilla', 'Central America and the Caribbean', ''), (6, 'AL', 'Albania', 'Europe', ''), .......so on So does anyone know how to insert this into the database now where I will delete 1,2,3,manually but how to have mySQL generate the UUID? Dave
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
