aeroswat Posted February 3, 2010 Share Posted February 3, 2010 CREATE TABLE `tblOrders` ( `OrderNumber` int( 11 ) NOT NULL AUTO_INCREMENT , `StudentNumber` int( 11 ) default '0', `AuthorizingName` varchar( 75 ) NOT NULL , `AuthorizingPhone` varchar( 10 ) NOT NULL , `AuthorizingEmail` varchar( 75 ) NOT NULL , `SchoolSystem` varchar( 75 ) NOT NULL , `StudentGrade` varchar( 3 ) NOT NULL , `SupplyName` varchar( 75 ) NOT NULL , `SupplyAPH` varchar( 15 ) NOT NULL , `SupplyAmt` int( 5 ) NOT NULL , `BookTitle` varchar( 75 ) NOT NULL , `BookSubject` varchar( 20 ) NOT NULL , `Copyright` varchar( 50 ) NOT NULL , `ISBNten` varchar( 50 ) NOT NULL , `Publisher` varchar( 50 ) NOT NULL , `FormatNeeded` varchar( 50 ) NOT NULL , `Compatible` tinyint( 2 ) NOT NULL default '0', `YearNeeded` int( 4 ) NOT NULL , `OrderComment` varchar( 500 ) NOT NULL , `Filled` tinyint( 4 ) default '0', `ShipAttention` varchar( 50 ) NOT NULL , `ShipAddress` varchar( 100 ) NOT NULL , `ShipName` varchar( 50 ) NOT NULL , `ShipCity` varchar( 50 ) NOT NULL , `ShipState` varchar( 2 ) default 'AL', `ShipZip` int( 5 ) NOT NULL , `DateOrdered` date NOT NULL , `ShipDate` date NOT NULL , `Cost` decimal( 10, 2 ) NOT NULL default '0.00', `Code` varchar( 3 ) NOT NULL default '03', `Line` tinyint( 2 ) NOT NULL , `oldnum` bigint( 5 ) NOT NULL , `stuName` varchar( 100 ) NOT NULL , `OrderYearNum` varchar( 5 ) NOT NULL , `AIRCBNum` varchar( 50 ) NOT NULL , `ItemNum` varchar( 50 ) NOT NULL , PRIMARY KEY ( `OrderNumber` ) , KEY `StudentNumber` ( `StudentNumber` ) ) ENGINE = MYISAM AUTO_INCREMENT =1353 DEFAULT CHARSET = utf8; #2006 - MySQL server has gone away Anyone have any ideas why this is happening? Link to comment https://forums.phpfreaks.com/topic/190809-mysql-server-has-gone-away/ Share on other sites More sharing options...
Hybride Posted February 4, 2010 Share Posted February 4, 2010 This page may be of some help: MySQL server has gone away. You may have to cut up your query in half and try to run them like that. Link to comment https://forums.phpfreaks.com/topic/190809-mysql-server-has-gone-away/#findComment-1006900 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.