Insert values question

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 cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---