Re:THIS has become URGENT NOW. Insert copy auto_increment to another column
Posted by:
Zeya B
Date: May 10, 2005 12:05PM
Anyone who can help?
It will be greatly appreciated.
Zeya B wrote:
> 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.