rgb192
asked on
Error Code: 1136. Column count doesn't match value count at row 1
CREATE TABLE `a_messages2` (
`a_messages_id` int(11) NOT NULL auto_increment,
`conversation_id` bigint(20) default NULL,
`profile_id` varchar(20) default NULL,
`sender` varchar(20) default NULL,
`message_id` bigint(20) default NULL,
`message_text` varchar(1000) default NULL,
`dateAgo` varchar(20) default NULL,
`message_read` tinyint(4) default NULL,
`this_user` varchar(20) default NULL,
PRIMARY KEY (`a_messages_id`),
UNIQUE KEY `unique_message_id` (`message_id`)
)
CREATE TABLE `a_messages3` (
`a_messages_id` INT (11) auto_increment
, `profile_id` VARCHAR(20)
, `sender` VARCHAR(20)
, `message_id` BIGINT (20)
, `this_user` VARCHAR(20)
, PRIMARY KEY (a_messages_id)
, INDEX profile_id (profile_id)
, INDEX profile_id_and_message_id (profile_id,message_id)
);
insert into a_messages3 select profile_id,sender,message_ id,this_us er from a_messages2
Error Code: 1136. Column count doesn't match value count at row 1
`a_messages_id` int(11) NOT NULL auto_increment,
`conversation_id` bigint(20) default NULL,
`profile_id` varchar(20) default NULL,
`sender` varchar(20) default NULL,
`message_id` bigint(20) default NULL,
`message_text` varchar(1000) default NULL,
`dateAgo` varchar(20) default NULL,
`message_read` tinyint(4) default NULL,
`this_user` varchar(20) default NULL,
PRIMARY KEY (`a_messages_id`),
UNIQUE KEY `unique_message_id` (`message_id`)
)
CREATE TABLE `a_messages3` (
`a_messages_id` INT (11) auto_increment
, `profile_id` VARCHAR(20)
, `sender` VARCHAR(20)
, `message_id` BIGINT (20)
, `this_user` VARCHAR(20)
, PRIMARY KEY (a_messages_id)
, INDEX profile_id (profile_id)
, INDEX profile_id_and_message_id (profile_id,message_id)
);
insert into a_messages3 select profile_id,sender,message_
Error Code: 1136. Column count doesn't match value count at row 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
SELECT profile_id,sender,message_
works because of insert
thanks