Hi everyone.

I need import in the table _int all values of the table _temp.

I don't modify the table _temp...

I use query insert in mysql:

Code:
insert into _int
(select * from _temp)
But I have this problem:

1) [Err] 1136 - Column count doesn't match value count at row 1, because in the table _temp I don't have id field...
2) [Err] 1292 - Incorrect datetime value: '15/05/2010 12.22' for column 'myDATE' at row 1

Code:
DROP TABLE IF EXISTS `_temp`; 
CREATE TABLE `_temp` (   
   `SEZ2` varchar(255) default NULL,   
   `myDATE` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

DROP TABLE IF EXISTS `_int`; 
CREATE TABLE `_temp` (  
   `ID` int(10) NOT NULL auto_increment, 
   `SEZ2` varchar(255) default NULL,   
   `myDATE` datetime default NULL,
    PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Can you help me?