Re: Can't Write To Table

Sorry, didn't mean to post twice!

On Monday 28 March 2005 4:47 pm, Andy Choens wrote:
> 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!

-- 
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]