Re: Can't Write To Table
North Antara <[email protected]>
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Message-ID | <[email protected]> |
That makes three actually... Andy Choens wrote: >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! >> >> > > > -- MySQL GUI Tools Mailing List For list archives: http://lists.mysql.com/gui-tools To unsubscribe: http://lists.mysql.com/[email protected]