| 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
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe: http://lists.mysql.com/[email protected]