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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.