Do a "SHOW WARNINGS" at the command line.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 13 June 2007 16:11
To: mysql@lists.mysql.com
Subject: Create Table Warning
This is a create table statement output from mysqldump from a 4.0.24
installation.
Restoring on 5.0.22 gives a warning.
Can anyone enlighten me?
I guess I'm a little behind on my reading...
David
mysql> CREATE TABLE `container` (
-> `carrier` varchar(128) NOT NULL default '',
-> `lock1` varchar(7) NOT NULL default '',
-> `lock2` varchar(7) NOT NULL default '',
-> `lock3` varchar(7) NOT NULL default '',
-> `lock4` varchar(7) NOT NULL default '',
-> `lock5` varchar(7) NOT NULL default '',
-> `lock6` varchar(7) NOT NULL default '',
-> `lock7` varchar(7) NOT NULL default '',
-> `lock8` varchar(7) NOT NULL default '',
-> `lock9` varchar(7) NOT NULL default '',
-> `lock10` varchar(7) NOT NULL default '',
-> `lock11` varchar(7) NOT NULL default '',
-> `lock12` varchar(7) NOT NULL default '',
-> `lock13` varchar(7) NOT NULL default '',
-> `lock14` varchar(7) NOT NULL default '',
-> `lock15` varchar(7) NOT NULL default '',
-> `lock16` varchar(7) NOT NULL default '',
-> `lock17` varchar(7) NOT NULL default '',
-> `lock18` varchar(7) NOT NULL default '',
-> `lock19` varchar(7) NOT NULL default '',
-> `lock20` varchar(7) NOT NULL default '',
-> `lock21` varchar(7) NOT NULL default '',
-> `lock22` varchar(7) NOT NULL default '',
-> `lock23` varchar(7) NOT NULL default '',
-> `lock24` varchar(7) NOT NULL default '',
-> PRIMARY KEY (`carrier`)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.00 sec)
This email is confidential and may also be privileged. If you are not the
intended recipient please notify us immediately by telephoning +44 (0)20 7452
5300 or email [EMAIL PROTECTED] You should not copy it or use it for any
purpose nor disclose its contents to any other person. Touch Local cannot
accept liability for statements made which are clearly the sender's own and are
not made on behalf of the firm.
Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
