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]