有没有办法让mysql在执行前先解压一条sql语句？
我的用例是我有一个表，我想将其移动到不同的服务器。该表的表定义和数据是 42725 行 SQL 或大约 2.5MB。
这是一个片段:
-- --------------------------------------------------------
-- Host: localhost
-- Server version: 5.6.24 - MySQL Community Server (GPL)
-- Server OS: Win32
-- HeidiSQL Version: 9.3.0.5107
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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' */;
-- Dumping structure for table us_zip_codes
DROP TABLE IF EXISTS `us_zip_codes`;
CREATE TABLE IF NOT EXISTS `us_zip_codes` (
`zZip` varchar(5) NOT NULL DEFAULT '',
`zCity` varchar(50) DEFAULT NULL,
`zState` varchar(2) DEFAULT NULL,
PRIMARY KEY (`zZip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table us_zip_codes: ~42,725 rows (approximately)
/*!40000 ALTER TABLE `us_zip_codes` DISABLE KEYS */;
INSERT INTO `us_zip_codes` (`zZip`, `zCity`, `zState`) VALUES
('00501', 'HOLTSVILLE', 'NY'),
('00544', 'HOLTSVILLE', 'NY'),
('00601', 'ADJUNTAS', 'PR'),
('00602', 'AGUADA', 'PR'),
('00603', 'AGUADILLA', 'PR'),
('00604', 'AGUADILLA', 'PR'),
('00605', 'AGUADILLA', 'PR'),
('00606', 'MARICAO', 'PR'),
('00610', 'ANASCO', 'PR'),
('00611', 'ANGELES', 'PR'),
('00612', 'ARECIBO', 'PR'),
('00613', 'ARECIBO', 'PR'),
('00614', 'ARECIBO', 'PR'),
('00616', 'BAJADERO', 'PR'),
('00617', 'BARCELONETA', 'PR'),
('00622', 'BOQUERON', 'PR'),
('00623', 'CABO ROJO', 'PR'),
('00624', 'PENUELAS', 'PR'),
('00627', 'CAMUY', 'PR'),
('00631', 'CASTANER', 'PR'),
('00636', 'ROSARIO', 'PR'),
('00637', 'SABANA GRANDE', 'PR'),
('00638', 'CIALES', 'PR'),
('00641', 'UTUADO', 'PR'),
('00646', 'DORADO', 'PR'),
('00647', 'ENSENADA', 'PR'),
('00650', 'FLORIDA', 'PR'),
('00652', 'GARROCHALES', 'PR'),
('00653', 'GUANICA', 'PR'),
('00656', 'GUAYANILLA', 'PR'),
('00659', 'HATILLO', 'PR'),
('00660', 'HORMIGUEROS', 'PR'),
('00662', 'ISABELA', 'PR'),
('00664', 'JAYUYA', 'PR'),
('00667', 'LAJAS', 'PR'),
('00669', 'LARES', 'PR'),
('00670', 'LAS MARIAS', 'PR'),
('00674', 'MANATI', 'PR'),
('00676', 'MOCA', 'PR'),
('00677', 'RINCON', 'PR'),
('00678', 'QUEBRADILLAS', 'PR'),
('00680', 'MAYAGUEZ', 'PR'),
('00681', 'MAYAGUEZ', 'PR'),
('00682', 'MAYAGUEZ', 'PR'),
('00683', 'SAN GERMAN', 'PR'),
('00685', 'SAN SEBASTIAN', 'PR'),
('00687', 'MOROVIS', 'PR'),
('00688', 'SABANA HOYOS', 'PR'),
('00690', 'SAN ANTONIO', 'PR'),
('00692', 'VEGA ALTA', 'PR'),
('00693', 'VEGA BAJA', 'PR'),
('00694', 'VEGA BAJA', 'PR'),
('00698', 'YAUCO', 'PR'),
('00703', 'AGUAS BUENAS', 'PR'),
('00704', 'AGUIRRE', 'PR'),
('00705', 'AIBONITO', 'PR'),
('00707', 'MAUNABO', 'PR'),
('00714', 'ARROYO', 'PR'),
('00715', 'MERCEDITA', 'PR'),
('00716', 'PONCE', 'PR'),
('00717', 'PONCE', 'PR'),
('00718', 'NAGUABO', 'PR'),
('00719', 'NARANJITO', 'PR'),
('00720', 'OROCOVIS', 'PR'),
('00721', 'PALMER', 'PR'),
('00723', 'PATILLAS', 'PR'),
('00725', 'CAGUAS', 'PR'),
('00726', 'CAGUAS', 'PR'),
('00727', 'CAGUAS', 'PR'),
('00728', 'PONCE', 'PR'),
('00729', 'CANOVANAS', 'PR'),
('00730', 'PONCE', 'PR'),
('00731', 'PONCE', 'PR'),
('00732', 'PONCE', 'PR'),
('00733', 'PONCE', 'PR'),
('00734', 'PONCE', 'PR'),
('00735', 'CEIBA', 'PR'),
('00736', 'CAYEY', 'PR'),
('00737', 'CAYEY', 'PR'),
('00738', 'FAJARDO', 'PR'),
('00739', 'CIDRA', 'PR'),
('00740', 'PUERTO REAL', 'PR'),
('00741', 'PUNTA SANTIAGO', 'PR'),
('00742', 'ROOSEVELT ROADS', 'PR'),
('00744', 'RIO BLANCO', 'PR'),
('00745', 'RIO GRANDE', 'PR'),
('00751', 'SALINAS', 'PR'),
('00754', 'SAN LORENZO', 'PR'),
('00757', 'SANTA ISABEL', 'PR'),
('00765', 'VIEQUES', 'PR'),
('00766', 'VILLALBA', 'PR'),
('00767', 'YABUCOA', 'PR'),
('00769', 'COAMO', 'PR'),
('00771', 'LAS PIEDRAS', 'PR'),
('00772', 'LOIZA', 'PR'),
('00773', 'LUQUILLO', 'PR'),
('00775', 'CULEBRA', 'PR'),
('00777', 'JUNCOS', 'PR'),
('00778', 'GURABO', 'PR'),
('00780', 'COTO LAUREL', 'PR'),
('00782', 'COMERIO', 'PR'),
('00783', 'COROZAL', 'PR'),
('00784', 'GUAYAMA', 'PR'),
('00785', 'GUAYAMA', 'PR'),
('00786', 'LA PLATA', 'PR'),
('00791', 'HUMACAO', 'PR'),
('00792', 'HUMACAO', 'PR'),
('00794', 'BARRANQUITAS', 'PR'),
('00795', 'JUANA DIAZ', 'PR'),
('00801', 'ST THOMAS', 'VI'),
('00802', 'ST THOMAS', 'VI'),
('00803', 'ST THOMAS', 'VI'),
('00804', 'ST THOMAS', 'VI'),
('00805', 'ST THOMAS', 'VI'),
('00820', 'CHRISTIANSTED', 'VI'),
('00821', 'CHRISTIANSTED', 'VI'),
('00822', 'CHRISTIANSTED', 'VI'),
('00823', 'CHRISTIANSTED', 'VI'),
('00824', 'CHRISTIANSTED', 'VI'),
('00830', 'ST JOHN', 'VI'),
('00831', 'ST JOHN', 'VI'),
('00840', 'FREDERIKSTED', 'VI'),
('00841', 'FREDERIKSTED', 'VI'),
('00850', 'KINGSHILL', 'VI'),
('00851', 'KINGSHILL', 'VI'),
('00901', 'SAN JUAN', 'PR'),
('00902', 'SAN JUAN', 'PR'),
('00906', 'SAN JUAN', 'PR'),
('00907', 'SAN JUAN', 'PR'),
('00908', 'SAN JUAN', 'PR'),
('00909', 'SAN JUAN', 'PR'),
('00910', 'SAN JUAN', 'PR'),
('00911', 'SAN JUAN', 'PR'),
('00912', 'SAN JUAN', 'PR'),
('00913', 'SAN JUAN', 'PR'),
('00914', 'SAN JUAN', 'PR'),
('00915', 'SAN JUAN', 'PR'),
('00916', 'SAN JUAN', 'PR'),
('00917', 'SAN JUAN', 'PR'),
('00918', 'SAN JUAN', 'PR'),
('00919', 'SAN JUAN', 'PR'),
('00920', 'SAN JUAN', 'PR'),
('00921', 'SAN JUAN', 'PR'),
('00922', 'SAN JUAN', 'PR'),
('00923', 'SAN JUAN', 'PR'),
('00924', 'SAN JUAN', 'PR'),
('00925', 'SAN JUAN', 'PR'),
('00926', 'SAN JUAN', 'PR'),
('00927', 'SAN JUAN', 'PR'),
('00928', 'SAN JUAN', 'PR'),
('00929', 'SAN JUAN', 'PR'),
('00930', 'SAN JUAN', 'PR'),
('00931', 'SAN JUAN', 'PR'),
('00933', 'SAN JUAN', 'PR'),
('00934', 'FORT BUCHANAN', 'PR'),
('00935', 'SAN JUAN', 'PR'),
('00936', 'SAN JUAN', 'PR'),
('00937', 'SAN JUAN', 'PR'),
('00939', 'SAN JUAN', 'PR'),
('00940', 'SAN JUAN', 'PR'),
('00949', 'TOA BAJA', 'PR'),
('00950', 'TOA BAJA', 'PR'),
('00951', 'TOA BAJA', 'PR'),
('00952', 'SABANA SECA', 'PR'),
('00953', 'TOA ALTA', 'PR'),
('00954', 'TOA ALTA', 'PR'),
('00955', 'SAN JUAN', 'PR'),
('00956', 'BAYAMON', 'PR'),
('00957', 'BAYAMON', 'PR'),
('00958', 'BAYAMON', 'PR'),
('00959', 'BAYAMON', 'PR'),
('00960', 'BAYAMON', 'PR'),
('00961', 'BAYAMON', 'PR'),
('00962', 'CATANO', 'PR'),
('00963', 'CATANO', 'PR'),
('00965', 'GUAYNABO', 'PR'),
('00966', 'GUAYNABO', 'PR'),
('00968', 'GUAYNABO', 'PR'),
('00969', 'GUAYNABO', 'PR'),
('00970', 'GUAYNABO', 'PR'),
('00971', 'GUAYNABO', 'PR'),
('00975', 'SAN JUAN', 'PR'),
('00976', 'TRUJILLO ALTO', 'PR'),
('00977', 'TRUJILLO ALTO', 'PR'),
('00978', 'SAINT JUST', 'PR'),
('00979', 'CAROLINA', 'PR'),
('00981', 'CAROLINA', 'PR'),
('00982', 'CAROLINA', 'PR'),
('00983', 'CAROLINA', 'PR'),
('00984', 'CAROLINA', 'PR'),
('00985', 'CAROLINA', 'PR'),
('00986', 'CAROLINA', 'PR'),
('00987', 'CAROLINA', 'PR'),
('00988', 'CAROLINA', 'PR'),
('01001', 'AGAWAM', 'MA'),
('01002', 'AMHERST', 'MA'),
('01003', 'AMHERST', 'MA'),
('01004', 'AMHERST', 'MA'),
('01005', 'BARRE', 'MA'),
('01007', 'BELCHERTOWN', 'MA'),
('01008', 'BLANDFORD', 'MA'),
('01009', 'BONDSVILLE', 'MA'),
('01010', 'BRIMFIELD', 'MA'),
('01011', 'CHESTER', 'MA'),
('01012', 'CHESTERFIELD', 'MA'),
('01013', 'CHICOPEE', 'MA'),
('01014', 'CHICOPEE', 'MA'),
('01020', 'CHICOPEE', 'MA'),
('01021', 'CHICOPEE', 'MA'),
('01022', 'CHICOPEE', 'MA'),
('01026', 'CUMMINGTON', 'MA'),
('01027', 'EASTHAMPTON', 'MA'),
('01028', 'EAST LONGMEADOW', 'MA'),
('01029', 'EAST OTIS', 'MA'),
('01030', 'FEEDING HILLS', 'MA'),
('01031', 'GILBERTVILLE', 'MA'),
('01032', 'GOSHEN', 'MA'),
('01033', 'GRANBY', 'MA'),
('01034', 'GRANVILLE', 'MA'),
('01035', 'HADLEY', 'MA'),
('01036', 'HAMPDEN', 'MA'),
('01037', 'HARDWICK', 'MA'),
('01038', 'HATFIELD', 'MA'),
('01039', 'HAYDENVILLE', 'MA'),
('01040', 'HOLYOKE', 'MA'),
('01041', 'HOLYOKE', 'MA'),
('01050', 'HUNTINGTON', 'MA'),
('01053', 'LEEDS', 'MA'),
('01054', 'LEVERETT', 'MA'),
('01056', 'LUDLOW', 'MA'),
('01057', 'MONSON', 'MA'),
('01059', 'NORTH AMHERST', 'MA'),
('01060', 'NORTHAMPTON', 'MA'),
('01061', 'NORTHAMPTON', 'MA'),
('01062', 'FLORENCE', 'MA'),
('01063', 'NORTHAMPTON', 'MA'),
('01066', 'NORTH HATFIELD', 'MA'),
('01068', 'OAKHAM', 'MA'),
('01069', 'PALMER', 'MA'),
('01070', 'PLAINFIELD', 'MA'),
('01071', 'RUSSELL', 'MA'),
('01072', 'SHUTESBURY', 'MA'),
('01073', 'SOUTHAMPTON', 'MA'),
('01074', 'SOUTH BARRE', 'MA'),
('01075', 'SOUTH HADLEY', 'MA'),
('01077', 'SOUTHWICK', 'MA'),
('01079', 'THORNDIKE', 'MA'),
('01080', 'THREE RIVERS', 'MA'),
('01081', 'WALES', 'MA'),
('01082', 'WARE', 'MA'),
('01083', 'WARREN', 'MA'),
('01084', 'WEST CHESTERFIELD', 'MA'),
('01085', 'WESTFIELD', 'MA'),
('01086', 'WESTFIELD', 'MA'),
('01088', 'WEST HATFIELD', 'MA'),
('01089', 'WEST SPRINGFIELD', 'MA'),
('01090', 'WEST SPRINGFIELD', 'MA'),
('01092', 'WEST WARREN', 'MA'),
('01093', 'WHATELY', 'MA'),
('01094', 'WHEELWRIGHT', 'MA'),
('01095', 'WILBRAHAM', 'MA'),
('01096', 'WILLIAMSBURG', 'MA'),
('01097', 'WORONOCO', 'MA'),
('01098', 'WORTHINGTON', 'MA'),
('01101', 'SPRINGFIELD', 'MA'),
('01102', 'SPRINGFIELD', 'MA'),
('01103', 'SPRINGFIELD', 'MA'),
('01104', 'SPRINGFIELD', 'MA'),
('01105', 'SPRINGFIELD', 'MA'),
('01106', 'LONGMEADOW', 'MA'),
('01107', 'SPRINGFIELD', 'MA'),
('01108', 'SPRINGFIELD', 'MA'),
('01109', 'SPRINGFIELD', 'MA'),
('01111', 'SPRINGFIELD', 'MA'),
('01115', 'SPRINGFIELD', 'MA'),
('01116', 'LONGMEADOW', 'MA'),
('01118', 'SPRINGFIELD', 'MA'),
('01119', 'SPRINGFIELD', 'MA'),
('01128', 'SPRINGFIELD', 'MA'),
('01129', 'SPRINGFIELD', 'MA'),
('01133', 'SPRINGFIELD', 'MA'),
('01138', 'SPRINGFIELD', 'MA'),
('01139', 'SPRINGFIELD', 'MA'),
('01144', 'SPRINGFIELD', 'MA'),
('01151', 'INDIAN ORCHARD', 'MA'),
('01152', 'SPRINGFIELD', 'MA'),
('01195', 'SPRINGFIELD', 'MA'),
('01199', 'SPRINGFIELD', 'MA'),
('01201', 'PITTSFIELD', 'MA'),
('01202', 'PITTSFIELD', 'MA'),
('01203', 'PITTSFIELD', 'MA'),
('01220', 'ADAMS', 'MA'),
('01222', 'ASHLEY FALLS', 'MA'),
('01223', 'BECKET', 'MA'),
('01224', 'BERKSHIRE', 'MA'),
('01225', 'CHESHIRE', 'MA'),
('01226', 'DALTON', 'MA'),
('01227', 'DALTON', 'MA'),
('01229', 'GLENDALE', 'MA'),
('01230', 'GREAT BARRINGTON', 'MA'),
('01235', 'HINSDALE', 'MA'),
('01236', 'HOUSATONIC', 'MA'),
('01237', 'LANESBORO', 'MA'),
('01238', 'LEE', 'MA'),
('01240', 'LENOX', 'MA'),
('01242', 'LENOX DALE', 'MA'),
('01243', 'MIDDLEFIELD', 'MA'),
('01244', 'MILL RIVER', 'MA'),
('01245', 'MONTEREY', 'MA'),
('01247', 'NORTH ADAMS', 'MA'),
('01252', 'NORTH EGREMONT', 'MA'),
('01253', 'OTIS', 'MA'),
('01254', 'RICHMOND', 'MA'),
('01255', 'SANDISFIELD', 'MA'),
('01256', 'SAVOY', 'MA'),
('01257', 'SHEFFIELD', 'MA'),
('01258', 'SOUTH EGREMONT', 'MA'),
('01259', 'SOUTHFIELD', 'MA'),
('01260', 'SOUTH LEE', 'MA'),
('01262', 'STOCKBRIDGE', 'MA'),
('01263', 'STOCKBRIDGE', 'MA'),
('01264', 'TYRINGHAM', 'MA'),
('01266', 'WEST STOCKBRIDGE', 'MA'),
('01267', 'WILLIAMSTOWN', 'MA'),
('01270', 'WINDSOR', 'MA'),
('01301', 'GREENFIELD', 'MA'),
('01302', 'GREENFIELD', 'MA'),
('01330', 'ASHFIELD', 'MA'),
('01331', 'ATHOL', 'MA'),
('01337', 'BERNARDSTON', 'MA'),
('01338', 'BUCKLAND', 'MA'),
('01339', 'CHARLEMONT', 'MA'),
('01340', 'COLRAIN', 'MA'),
('01341', 'CONWAY', 'MA'),
('01342', 'DEERFIELD', 'MA'),
('01343', 'DRURY', 'MA'),
('01344', 'ERVING', 'MA'),
('01346', 'HEATH', 'MA'),
('01347', 'LAKE PLEASANT', 'MA'),
('01349', 'MILLERS FALLS', 'MA'),
('01350', 'MONROE BRIDGE', 'MA'),
('01351', 'MONTAGUE', 'MA'),
('01354', 'GILL', 'MA'),
('01355', 'NEW SALEM', 'MA'),
('01360', 'NORTHFIELD', 'MA'),
('01364', 'ORANGE', 'MA'),
('01366', 'PETERSHAM', 'MA'),
('01367', 'ROWE', 'MA'),
('01368', 'ROYALSTON', 'MA'),
('01370', 'SHELBURNE FALLS', 'MA'),
('01373', 'SOUTH DEERFIELD', 'MA'),
('01375', 'SUNDERLAND', 'MA'),
('01376', 'TURNERS FALLS', 'MA'),
('01378', 'WARWICK', 'MA'),
('01379', 'WENDELL', 'MA'),
('01380', 'WENDELL DEPOT', 'MA'),
('01420', 'FITCHBURG', 'MA'),
('01430', 'ASHBURNHAM', 'MA'),
('01431', 'ASHBY', 'MA'),
('01432', 'AYER', 'MA'),
('01434', 'DEVENS', 'MA'),
('01436', 'BALDWINVILLE', 'MA'),
('01438', 'EAST TEMPLETON', 'MA'),
('01440', 'GARDNER', 'MA'),
('01441', 'WESTMINSTER', 'MA'),
('01450', 'GROTON', 'MA'),
('01451', 'HARVARD', 'MA'),
('01452', 'HUBBARDSTON', 'MA'),
('01453', 'LEOMINSTER', 'MA'),
('01460', 'LITTLETON', 'MA'),
('01462', 'LUNENBURG', 'MA'),
('01463', 'PEPPERELL', 'MA'),
('01464', 'SHIRLEY', 'MA'),
('01467', 'STILL RIVER', 'MA'),
('01468', 'TEMPLETON', 'MA'),
('01469', 'TOWNSEND', 'MA'),
('01470', 'GROTON', 'MA'),
('01471', 'GROTON', 'MA'),
('01472', 'WEST GROTON', 'MA'),
('01473', 'WESTMINSTER', 'MA'),
('01474', 'WEST TOWNSEND', 'MA'),
('01475', 'WINCHENDON', 'MA'),
('01477', 'WINCHENDON SPRINGS', 'MA'),
('01501', 'AUBURN', 'MA'),
('01503', 'BERLIN', 'MA'),
('01504', 'BLACKSTONE', 'MA'),
('01505', 'BOYLSTON', 'MA'),
('01506', 'BROOKFIELD', 'MA'),
('01507', 'CHARLTON', 'MA'),
('01508', 'CHARLTON CITY', 'MA'),
('01509', 'CHARLTON DEPOT', 'MA'),
('01510', 'CLINTON', 'MA'),
('01515', 'EAST BROOKFIELD', 'MA'),
('01516', 'DOUGLAS', 'MA'),
('01517', 'EAST PRINCETON', 'MA'),
('01518', 'FISKDALE', 'MA'),
('01519', 'GRAFTON', 'MA'),
('01520', 'HOLDEN', 'MA'),
('01521', 'HOLLAND', 'MA'),
('01522', 'JEFFERSON', 'MA'),
('01523', 'LANCASTER', 'MA'),
('01524', 'LEICESTER', 'MA'),
('01525', 'LINWOOD', 'MA'),
('01526', 'MANCHAUG', 'MA'),
('01527', 'MILLBURY', 'MA'),
('01529', 'MILLVILLE', 'MA'),
('01531', 'NEW BRAINTREE', 'MA'),
('01532', 'NORTHBOROUGH', 'MA'),
('01534', 'NORTHBRIDGE', 'MA'),
('01535', 'NORTH BROOKFIELD', 'MA'),
('01536', 'NORTH GRAFTON', 'MA'),
('01537', 'NORTH OXFORD', 'MA'),
('01538', 'NORTH UXBRIDGE', 'MA'),
('01540', 'OXFORD', 'MA'),
('01541', 'PRINCETON', 'MA'),
('01542', 'ROCHDALE', 'MA'),
('01543', 'RUTLAND', 'MA'),
('01545', 'SHREWSBURY', 'MA'),
('01546', 'SHREWSBURY', 'MA'),
('01550', 'SOUTHBRIDGE', 'MA'),
('01560', 'SOUTH GRAFTON', 'MA'),
('01561', 'SOUTH LANCASTER', 'MA'),
('01562', 'SPENCER', 'MA'),
('01564', 'STERLING', 'MA'),
('01566', 'STURBRIDGE', 'MA'),
('01568', 'UPTON', 'MA'),
('01569', 'UXBRIDGE', 'MA'),
('01570', 'WEBSTER', 'MA'),
('01571', 'DUDLEY', 'MA'),
('01580', 'WESTBOROUGH', 'MA'),
('01581', 'WESTBOROUGH', 'MA'),
('01582', 'WESTBOROUGH', 'MA'),
('01583', 'WEST BOYLSTON', 'MA'),
('01585', 'WEST BROOKFIELD', 'MA'),
('01586', 'WEST MILLBURY', 'MA'),
('01588', 'WHITINSVILLE', 'MA'),
('01590', 'SUTTON', 'MA'),
('01601', 'WORCESTER', 'MA'),
('01602', 'WORCESTER', 'MA'),
('01603', 'WORCESTER', 'MA'),
('01604', 'WORCESTER', 'MA'),
('01605', 'WORCESTER', 'MA'),
('01606', 'WORCESTER', 'MA'),
('01607', 'WORCESTER', 'MA'),
('01608', 'WORCESTER', 'MA'),
('01609', 'WORCESTER', 'MA'),
('01610', 'WORCESTER', 'MA'),
('01611', 'CHERRY VALLEY', 'MA'),
('01612', 'PAXTON', 'MA'),
('01613', 'WORCESTER', 'MA'),
('01614', 'WORCESTER', 'MA'),
('01615', 'WORCESTER', 'MA'),
('01653', 'WORCESTER', 'MA'),
('01654', 'WORCESTER', 'MA'),
('01655', 'WORCESTER', 'MA'),
('01701', 'FRAMINGHAM', 'MA'),
('01702', 'FRAMINGHAM', 'MA'),
('01703', 'FRAMINGHAM', 'MA'),
('01704', 'FRAMINGHAM', 'MA'),
('01705', 'FRAMINGHAM', 'MA'),
('01718', 'VILLAGE OF NAGOG WOO', 'MA'),
('01719', 'BOXBOROUGH', 'MA'),
('01720', 'ACTON', 'MA'),
('01721', 'ASHLAND', 'MA'),
('01730', 'BEDFORD', 'MA'),
('01731', 'HANSCOM AFB', 'MA'),
('01740', 'BOLTON', 'MA'),
('01741', 'CARLISLE', 'MA'),
('01742', 'CONCORD', 'MA'),
('01745', 'FAYVILLE', 'MA'),
('01746', 'HOLLISTON', 'MA'),
('01747', 'HOPEDALE', 'MA'),
('01748', 'HOPKINTON', 'MA'),
('01749', 'HUDSON', 'MA'),
('01752', 'MARLBOROUGH', 'MA'),
('01754', 'MAYNARD', 'MA'),
('01756', 'MENDON', 'MA'),
('01757', 'MILFORD', 'MA'),
('01760', 'NATICK', 'MA'),
('01770', 'SHERBORN', 'MA'),
('01772', 'SOUTHBOROUGH', 'MA'),
('01773', 'LINCOLN', 'MA'),
('01775', 'STOW', 'MA'),
('01776', 'SUDBURY', 'MA'),
('01778', 'WAYLAND', 'MA'),
('01784', 'WOODVILLE', 'MA'),
('01801', 'WOBURN', 'MA'),
('01803', 'BURLINGTON', 'MA'),
('01805', 'BURLINGTON', 'MA'),
('01806', 'WOBURN', 'MA'),
('01807', 'WOBURN', 'MA'),
('01808', 'WOBURN', 'MA'),
('01810', 'ANDOVER', 'MA'),
('01812', 'ANDOVER', 'MA'),
('01813', 'WOBURN', 'MA'),
('01815', 'WOBURN', 'MA'),
('01821', 'BILLERICA', 'MA'),
('01822', 'BILLERICA', 'MA'),
('01824', 'CHELMSFORD', 'MA'),
('01826', 'DRACUT', 'MA'),
('01827', 'DUNSTABLE', 'MA'),
('01830', 'HAVERHILL', 'MA'),
('01831', 'HAVERHILL', 'MA'),
('01832', 'HAVERHILL', 'MA'),
('01833', 'GEORGETOWN', 'MA'),
('01834', 'GROVELAND', 'MA'),
('01835', 'HAVERHILL', 'MA'),
('01840', 'LAWRENCE', 'MA'),
('01841', 'LAWRENCE', 'MA'),
('01842', 'LAWRENCE', 'MA'),
('01843', 'LAWRENCE', 'MA'),
('01844', 'METHUEN', 'MA'),
('01845', 'NORTH ANDOVER', 'MA'),
('01850', 'LOWELL', 'MA'),
('01851', 'LOWELL', 'MA'),
('01852', 'LOWELL', 'MA'),
('01853', 'LOWELL', 'MA'),
('01854', 'LOWELL', 'MA'),
('01860', 'MERRIMAC', 'MA'),
('01862', 'NORTH BILLERICA', 'MA'),
('01863', 'NORTH CHELMSFORD', 'MA'),
('01864', 'NORTH READING', 'MA'),
('01865', 'NUTTING LAKE', 'MA'),
('01866', 'PINEHURST', 'MA'),
('01867', 'READING', 'MA'),
('01876', 'TEWKSBURY', 'MA'),
('01879', 'TYNGSBORO', 'MA'),
('01880', 'WAKEFIELD', 'MA'),
('01885', 'WEST BOXFORD', 'MA'),
('01886', 'WESTFORD', 'MA'),
('01887', 'WILMINGTON', 'MA'),
('01888', 'WOBURN', 'MA'),
('01889', 'NORTH READING', 'MA'),
('01890', 'WINCHESTER', 'MA'),
('01899', 'ANDOVER', 'MA'),
('01901', 'LYNN', 'MA'),
('01902', 'LYNN', 'MA'),
('01903', 'LYNN', 'MA'),
('01904', 'LYNN', 'MA'),
('01905', 'LYNN', 'MA'),
('01906', 'SAUGUS', 'MA'),
('01907', 'SWAMPSCOTT', 'MA'),
('01908', 'NAHANT', 'MA'),
('01910', 'LYNN', 'MA'),
('01913', 'AMESBURY', 'MA'),
('01915', 'BEVERLY', 'MA'),
('01921', 'BOXFORD', 'MA'),
('01922', 'BYFIELD', 'MA'),
('01923', 'DANVERS', 'MA'),
('01929', 'ESSEX', 'MA'),
('01930', 'GLOUCESTER', 'MA'),
('01931', 'GLOUCESTER', 'MA'),
('01936', 'HAMILTON', 'MA'),
('01937', 'HATHORNE', 'MA'),
('01938', 'IPSWICH', 'MA'),
('01940', 'LYNNFIELD', 'MA'),
('01944', 'MANCHESTER', 'MA'),
('01945', 'MARBLEHEAD', 'MA'),
('01949', 'MIDDLETON', 'MA'),
('01950', 'NEWBURYPORT', 'MA'),
('01951', 'NEWBURY', 'MA'),
('01952', 'SALISBURY', 'MA'),
('01960', 'PEABODY', 'MA'),
('01961', 'PEABODY', 'MA'),
('01965', 'PRIDES CROSSING', 'MA'),
('01966', 'ROCKPORT', 'MA'),
('01969', 'ROWLEY', 'MA'),
('01970', 'SALEM', 'MA'),
('01971', 'SALEM', 'MA'),
('01982', 'SOUTH HAMILTON', 'MA'),
('01983', 'TOPSFIELD', 'MA'),
('01984', 'WENHAM', 'MA'),
('01985', 'WEST NEWBURY', 'MA'),
('02018', 'ACCORD', 'MA'),
('02019', 'BELLINGHAM', 'MA'),
('02020', 'BRANT ROCK', 'MA'),
('02021', 'CANTON', 'MA'),
('02025', 'COHASSET', 'MA'),
('02026', 'DEDHAM', 'MA'),
('02027', 'DEDHAM', 'MA'),
('02030', 'DOVER', 'MA'),
('02031', 'EAST MANSFIELD', 'MA'),
('02032', 'EAST WALPOLE', 'MA'),
('02035', 'FOXBORO', 'MA'),
('02038', 'FRANKLIN', 'MA'),
('02040', 'GREENBUSH', 'MA'),
('02041', 'GREEN HARBOR', 'MA'),
('02043', 'HINGHAM', 'MA'),
('02044', 'HINGHAM', 'MA'),
('02045', 'HULL', 'MA'),
('02047', 'HUMAROCK', 'MA'),
('02048', 'MANSFIELD', 'MA'),
('02050', 'MARSHFIELD', 'MA'),
('02051', 'MARSHFIELD HILLS', 'MA'),
('02052', 'MEDFIELD', 'MA'),
('02053', 'MEDWAY', 'MA'),
('02054', 'MILLIS', 'MA'),
('02055', 'MINOT', 'MA'),
('02056', 'NORFOLK', 'MA'),
('02059', 'NORTH MARSHFIELD', 'MA'),
('02060', 'NORTH SCITUATE', 'MA'),
('02061', 'NORWELL', 'MA'),
('02062', 'NORWOOD', 'MA'),
('02065', 'OCEAN BLUFF', 'MA'),
('02066', 'SCITUATE', 'MA'),
('02067', 'SHARON', 'MA'),
('02070', 'SHELDONVILLE', 'MA'),
('02071', 'SOUTH WALPOLE', 'MA'),
('02072', 'STOUGHTON', 'MA'),
('02081', 'WALPOLE', 'MA'),
('02090', 'WESTWOOD', 'MA'),
('02093', 'WRENTHAM', 'MA'),
('02108', 'BOSTON', 'MA'),
('02109', 'BOSTON', 'MA'),
('02110', 'BOSTON', 'MA'),
('02111', 'BOSTON', 'MA'),
('02112', 'BOSTON', 'MA');
/*!40000 ALTER TABLE `us_zip_codes` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
压缩此数据会将 2.5mb 的文件变成 273kb。
有没有办法将压缩查询发送到 MySql？
最佳答案
不幸的是，无法将压缩查询发送到mysql服务器，
但是
对于长字符串查询，您可以增加数据包的大小。
要增加 max_allowed_packet，打开
[mysqld] 部分下的 my.ini/my.cnf。
更改完成后，您必须重新启动服务器。
它应该是下面这样的东西。你必须设置 3mb 而不是 2mb
max_allowed_packet=1048576 or 1mb
关于mysql - MySQL 可以执行压缩的 SQL 文件吗？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/38921825/
我有一个Ruby程序，它使用rubyzip压缩XML文件的目录树。gem。我的问题是文件开始变得很重，我想提高压缩级别，因为压缩时间不是问题。我在rubyzipdocumentation中找不到一种为创建的ZIP文件指定压缩级别的方法。有人知道如何更改此设置吗？是否有另一个允许指定压缩级别的Ruby库？ 最佳答案 这是我通过查看rubyzip内部创建的代码。level=Zlib::BEST_COMPRESSIONZip::ZipOutputStream.open(zip_file)do|zip|Dir.glob("**/*")d
类classAprivatedeffooputs:fooendpublicdefbarputs:barendprivatedefzimputs:zimendprotecteddefdibputs:dibendendA的实例a=A.new测试a.foorescueputs:faila.barrescueputs:faila.zimrescueputs:faila.dibrescueputs:faila.gazrescueputs:fail测试输出failbarfailfailfail.发送测试[:foo,:bar,:zim,:dib,:gaz].each{|m|a.send(m)resc
我试图在一个项目中使用rake，如果我把所有东西都放到Rakefile中，它会很大并且很难读取/找到东西，所以我试着将每个命名空间放在lib/rake中它自己的文件中，我添加了这个到我的rake文件的顶部:Dir['#{File.dirname(__FILE__)}/lib/rake/*.rake'].map{|f|requiref}它加载文件没问题，但没有任务。我现在只有一个.rake文件作为测试，名为“servers.rake”，它看起来像这样:namespace:serverdotask:testdoputs"test"endend所以当我运行rakeserver:testid时
我的目标是转换表单输入，例如“100兆字节”或“1GB”，并将其转换为我可以存储在数据库中的文件大小(以千字节为单位)。目前，我有这个:defquota_convert@regex=/([0-9]+)(.*)s/@sizes=%w{kilobytemegabytegigabyte}m=self.quota.match(@regex)if@sizes.include?m[2]eval("self.quota=#{m[1]}.#{m[2]}")endend这有效，但前提是输入是倍数(“gigabytes”，而不是“gigabyte”)并且由于使用了eval看起来疯狂不安全。所以，功能正常，
Rails2.3可以选择随时使用RouteSet#add_configuration_file添加更多路由。是否可以在Rails3项目中做同样的事情？ 最佳答案 在config/application.rb中:config.paths.config.routes在Rails3.2(也可能是Rails3.1)中，使用:config.paths["config/routes"] 关于ruby-on-rails-Rails3中的多个路由文件，我们在StackOverflow上找到一个类似的问题
我在使用omniauth/openid时遇到了一些麻烦。在尝试进行身份验证时，我在日志中发现了这一点:OpenID::FetchingError:Errorfetchinghttps://www.google.com/accounts/o8/.well-known/host-meta?hd=profiles.google.com%2Fmy_username:undefinedmethod`io'fornil:NilClass重要的是undefinedmethodio'fornil:NilClass来自openid/fetchers.rb，在下面的代码片段中:moduleNetclass
对于具有离线功能的智能手机应用程序，我正在为Xml文件创建单向文本同步。我希望我的服务器将增量/差异(例如GNU差异补丁)发送到目标设备。这是计划:Time=0Server:hasversion_1ofXmlfile(~800kiB)Client:hasversion_1ofXmlfile(~800kiB)Time=1Server:hasversion_1andversion_2ofXmlfile(each~800kiB)computesdeltaoftheseversions(=patch)(~10kiB)sendspatchtoClient(~10kiBtransferred)Cl
我正在寻找执行以下操作的正确语法(在Perl、Shell或Ruby中):#variabletoaccessthedatalinesappendedasafileEND_OF_SCRIPT_MARKERrawdatastartshereanditcontinues. 最佳答案 Perl用__DATA__做这个:#!/usr/bin/perlusestrict;usewarnings;while(){print;}__DATA__Texttoprintgoeshere 关于ruby-如何将脚
使用带有Rails插件的vim，您可以创建一个迁移文件，然后一次性打开该文件吗？textmate也可以这样吗？ 最佳答案 你可以使用rails.vim然后做类似的事情::Rgeneratemigratonadd_foo_to_bar插件将打开迁移生成的文件，这正是您想要的。我不能代表textmate。 关于ruby-使用VimRails，您可以创建一个新的迁移文件并一次性打开它吗？，我们在StackOverflow上找到一个类似的问题： https://sta
查看Ruby的CSV库的文档，我非常确定这是可能且简单的。我只需要使用Ruby删除CSV文件的前三列，但我没有成功运行它。 最佳答案 csv_table=CSV.read(file_path_in,:headers=>true)csv_table.delete("header_name")csv_table.to_csv#=>ThenewCSVinstringformat检查CSV::Table文档:http://ruby-doc.org/stdlib-1.9.2/libdoc/csv/rdoc/CSV/Table.html