Can't Write To Table

Andy Choens <[email protected]>
Newsgroups gmane.comp.db.mysql.mycc
Message-ID <[email protected]>
I'm having table issues.

I restored a table using the Administrator, and now I can't edit it!  
Actually, I restored several tables in one schema, and the others are working 
perfectly, but this one ain't!

I attached most of the generated SQL below, in case it might help anyone.  I 
sure am confused.
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, 
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;


CREATE DATABASE /*!32312 IF NOT EXISTS*/ `tlp`;
USE `tlp`;
CREATE TABLE `adults` (
  `parent_number` int(11) NOT NULL auto_increment,
  `camper_number` int(3) NOT NULL default '0',
  `camper_number_2` int(3) default '0',
  `primary_contact` char(3) NOT NULL default '1',
  `mail` char(3) NOT NULL default '0',
  `role` varchar(11) default '',
  `first_name` varchar(50) default NULL,
  `middle_name` varchar(20) default NULL,
  `last_name` varchar(20) NOT NULL default '',
  `cellphone` varchar(20) default '',
  `homephone` varchar(20) NOT NULL default '',
  `workphone` varchar(20) default '',
  `address_1` varchar(50) NOT NULL default '',
  `address_2` varchar(20) default '',
  `city` varchar(20) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zip` varchar(11) NOT NULL default '',
  `email` varchar(100) default '',
  `notes` longtext,
  `email?` int(11) NOT NULL default '0',
  PRIMARY KEY  (`parent_number`)
) TYPE=MyISAM;
INSERT INTO `adults` VALUES  

I can't include the rest of it because the information is sensitive.  But, 
hopefully this will tell someone something.  I really need to be able to edit 
this table.

I can Query the table, and it is there, but if ANY program tries to edit the 
contents of the table, it gets an error.

--andy

-- 
Alex Lowe's 3 Rules for Climbing:
	1 - Come Back Alive!
	2 - Come Back Still Friends With Your Partners!
	3 - Get To The Top!

-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.