Re: Insert copy auto_increment to another column

[Zeya B]

Ver: 4.1.10nt

When I run this using SQLYog it works but from my application it throws that error. I would suspect there is something other than constraint.

Your help is greatly appreciated.

Here is the schema.

CREATE TABLE `myfilms` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`m_ID` bigint(20) NOT NULL default '0',
`User_ID` bigint(20) NOT NULL default '0',
`Title` varchar(255) NOT NULL default '',
`catalog` text NOT NULL,
`Clipping` text,
`Comments` text,
`Folder_Id` int(10) unsigned default '0',
`IsActive` tinyint(1) default '1',
`IsPublic` tinyint(1) default '0',
`Created_By` varchar(75) default NULL,
`Created_Date` datetime default NULL,
`Modified_By` varchar(75) default NULL,
`Modified_Date` datetime default NULL,
PRIMARY KEY(`ID`,`m_ID`),
FULLTEXT KEY `ClippingsFulltext` (`Title`,`catalog`,`Clipping`,`Comments`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED


Fulltext key I added later.