- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我有一个查询,在使用 Sequel Pro 输入时可以完美运行,但在我尝试使用 node-mysql
库导入它时会抛出语法错误。我不认为这是 node-mysql
的问题,但对于我来说,我无法弄清楚语法错误在哪里。
错误如下:
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `units` VALUES
('N', '30', '0.00146', '22108.05', '1460.00'),
('N'' at line 10
这是查询:
CREATE TABLE IF NOT EXISTS `units`
(
`section` VARCHAR(255) NOT NULL,
`unit_number` INT(11) unsigned NOT NULL,
`percentage_value` FLOAT(7,5) NOT NULL,
`1963_value` DECIMAL(19,2) NOT NULL,
`share_per_million` DECIMAL(19,2) NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `units` VALUES
('N', '30', '0.00146', '22108.05', '1460.00'),
('N', '31', '0.00144', '21805.20', '1440.00'),
('N', '32', '0.00144', '21805.20', '1440.00'),
('N', '33', '0.00175', '26499.38', '1750.00'),
('N', '101', '0.00298', '45124.65', '2980.00'),
('N', '102', '0.00298', '45124.65', '2980.00'),
('N', '103', '0.00169', '25590.83', '1690.00'),
('N', '104', '0.00256', '38764.80', '2560.00'),
('N', '105', '0.00256', '38764.80', '2560.00'),
('N', '106', '0.00144', '21805.20', '1440.00'),
('N', '107', '0.00144', '21805.20', '1440.00'),
('N', '108', '0.00188', '28467.90', '1880.00'),
('N', '109', '0.00165', '24985.13', '1650.00'),
('N', '110', '0.00173', '26196.53', '1730.00'),
('N', '111', '0.00188', '28467.90', '1880.00'),
('N', '112', '0.00203', '30739.28', '2030.00'),
('N', '113', '0.00188', '28467.90', '1880.00'),
('N', '114', '0.00154', '23319.45', '1540.00'),
('N', '115', '0.0019', '28770.75', '1900.00'),
('N', '116', '0.00125', '18928.13', '1250.00'),
('N', '117', '0.00264', '39976.20', '2640.00'),
('N', '118', '0.00156', '23622.30', '1560.00'),
('N', '119', '0.00156', '23622.30', '1560.00'),
('N', '120', '0.00156', '23622.30', '1560.00'),
('N', '121', '0.00156', '23622.30', '1560.00'),
('N', '123', '0.00159', '24076.58', '1590.00'),
('N', '130', '0.00127', '19230.98', '1270.00'),
('N', '131', '0.00131', '19836.68', '1310.00'),
('N', '132', '0.00131', '19836.68', '1310.00'),
('N', '133', '0.00133', '20139.53', '1330.00'),
('N', '134', '0.00144', '21805.20', '1440.00'),
('N', '201', '0.00298', '45124.65', '2980.00'),
('N', '202', '0.00298', '45124.65', '2980.00'),
('N', '203', '0.00169', '25590.83', '1690.00'),
('N', '204', '0.00256', '38764.80', '2560.00'),
('N', '205', '0.00256', '38764.80', '2560.00'),
('N', '206', '0.00144', '21805.20', '1440.00'),
('N', '207', '0.00144', '21805.20', '1440.00'),
('N', '208', '0.00188', '28467.90', '1880.00'),
('N', '209', '0.00165', '24985.13', '1650.00'),
('N', '210', '0.00173', '26196.53', '1730.00'),
('N', '211', '0.00188', '28467.90', '1880.00'),
('N', '212', '0.00203', '30739.28', '2030.00'),
('N', '213', '0.00188', '28467.90', '1880.00'),
('N', '214', '0.00154', '23319.45', '1540.00'),
('N', '215', '0.0019', '28770.75', '1900.00'),
('N', '216', '0.00127', '19230.98', '1270.00'),
('N', '217', '0.00249', '37704.83', '2490.00'),
('N', '218', '0.00144', '21805.20', '1440.00'),
('N', '219', '0.00144', '21805.20', '1440.00'),
('N', '220', '0.00144', '21805.20', '1440.00'),
('N', '221', '0.00144', '21805.20', '1440.00'),
('N', '222', '0.00165', '24985.13', '1650.00'),
('N', '223', '0.0014', '21199.50', '1400.00'),
('N', '224', '0.00177', '26802.23', '1770.00'),
('N', '225', '0.0015', '22713.75', '1500.00'),
('N', '226', '0.0019', '28770.75', '1900.00'),
('N', '227', '0.00289', '43761.83', '2890.00'),
('N', '228', '0.00158', '23925.15', '1580.00'),
('N', '229', '0.00158', '23925.15', '1580.00'),
('N', '230', '0.00131', '19836.68', '1310.00'),
('N', '231', '0.00131', '19836.68', '1310.00'),
('N', '232', '0.00131', '19836.68', '1310.00'),
('N', '233', '0.00133', '20139.53', '1330.00'),
('N', '234', '0.00131', '19836.68', '1310.00'),
('N', '301', '0.00301', '45578.93', '3010.00'),
('N', '302', '0.00301', '45578.93', '3010.00'),
('N', '303', '0.00173', '26196.53', '1730.00'),
('N', '304', '0.0026', '39370.50', '2600.00'),
('N', '305', '0.0026', '39370.50', '2600.00'),
('N', '306', '0.00148', '22410.90', '1480.00'),
('N', '307', '0.00148', '22410.90', '1480.00'),
('N', '308', '0.00192', '29073.60', '1920.00'),
('N', '309', '0.00169', '25590.83', '1690.00'),
('N', '310', '0.00177', '26802.23', '1770.00'),
('N', '311', '0.00192', '29073.60', '1920.00'),
('N', '312', '0.00207', '31344.98', '2070.00'),
('N', '313', '0.00192', '29073.60', '1920.00'),
('N', '314', '0.00158', '23925.15', '1580.00'),
('N', '315', '0.00196', '29679.30', '1960.00'),
('N', '316', '0.00129', '19533.83', '1290.00'),
('N', '317', '0.00249', '37704.83', '2490.00'),
('N', '318', '0.00144', '21805.20', '1440.00'),
('N', '319', '0.00144', '21805.20', '1440.00'),
('N', '320', '0.00144', '21805.20', '1440.00'),
('N', '321', '0.00144', '21805.20', '1440.00'),
('N', '322', '0.00165', '24985.13', '1650.00'),
('N', '323', '0.0014', '21199.50', '1400.00'),
('N', '324', '0.0018', '27256.50', '1800.00'),
('N', '325', '0.0015', '22713.75', '1500.00'),
('N', '326', '0.00194', '29376.45', '1940.00'),
('N', '327', '0.00292', '44216.10', '2920.00'),
('N', '328', '0.00161', '24379.43', '1610.00'),
('N', '329', '0.00158', '23925.15', '1580.00'),
('N', '330', '0.00131', '19836.68', '1310.00'),
('N', '331', '0.00131', '19836.68', '1310.00'),
('N', '332', '0.00131', '19836.68', '1310.00'),
('N', '333', '0.00133', '20139.53', '1330.00'),
('N', '334', '0.00131', '19836.68', '1310.00'),
('N', '401', '0.00301', '45578.93', '3010.00'),
('N', '402', '0.00301', '45578.93', '3010.00'),
('N', '403', '0.00173', '26196.53', '1730.00'),
('N', '404', '0.0026', '39370.50', '2600.00'),
('N', '405', '0.0026', '39370.50', '2600.00'),
('N', '406', '0.00148', '22410.90', '1480.00'),
('N', '407', '0.00148', '22410.90', '1480.00'),
('N', '408', '0.00192', '29073.60', '1920.00'),
('N', '409', '0.00169', '25590.83', '1690.00'),
('N', '410', '0.00177', '26802.23', '1770.00'),
('N', '411', '0.00192', '29073.60', '1920.00'),
('N', '412', '0.00207', '31344.98', '2070.00'),
('N', '413', '0.00192', '29073.60', '1920.00'),
('N', '414', '0.00158', '23925.15', '1580.00'),
('N', '415', '0.00196', '29679.30', '1960.00'),
('N', '416', '0.00131', '19836.68', '1310.00'),
('N', '417', '0.00249', '37704.83', '2490.00'),
('N', '418', '0.00144', '21805.20', '1440.00'),
('N', '419', '0.00144', '21805.20', '1440.00'),
('N', '420', '0.00144', '21805.20', '1440.00'),
('N', '421', '0.00144', '21805.20', '1440.00'),
('N', '422', '0.00165', '24985.13', '1650.00'),
('N', '423', '0.0014', '21199.50', '1400.00'),
('N', '424', '0.0018', '27256.50', '1800.00'),
('N', '425', '0.0015', '22713.75', '1500.00'),
('N', '426', '0.00194', '29376.45', '1940.00'),
('N', '427', '0.00292', '44216.10', '2920.00'),
('N', '428', '0.00161', '24379.43', '1610.00'),
('N', '429', '0.00158', '23925.15', '1580.00'),
('N', '430', '0.00125', '18928.13', '1250.00'),
('N', '431', '0.00131', '19836.68', '1310.00'),
('N', '432', '0.00131', '19836.68', '1310.00'),
('N', '433', '0.00127', '19230.98', '1270.00'),
('N', '434', '0.00135', '20442.38', '1350.00'),
('N', '501', '0.00301', '45578.93', '3010.00'),
('N', '502', '0.00301', '45578.93', '3010.00'),
('N', '503', '0.00173', '26196.53', '1730.00'),
('N', '504', '0.0026', '39370.50', '2600.00'),
('N', '505', '0.0026', '39370.50', '2600.00'),
('N', '506', '0.00148', '22410.90', '1480.00'),
('N', '507', '0.00148', '22410.90', '1480.00'),
('N', '508', '0.00192', '29073.60', '1920.00'),
('N', '509', '0.00169', '25590.83', '1690.00'),
('N', '510', '0.00177', '26802.23', '1770.00'),
('N', '511', '0.00192', '29073.60', '1920.00'),
('N', '512', '0.00207', '31344.98', '2070.00'),
('N', '513', '0.00192', '29073.60', '1920.00'),
('N', '514', '0.00158', '23925.15', '1580.00'),
('N', '515', '0.00199', '30133.58', '1990.00'),
('N', '516', '0.00131', '19836.68', '1310.00'),
('N', '517', '0.00275', '41641.88', '2750.00'),
('N', '518', '0.00167', '25287.98', '1670.00'),
('N', '519', '0.00167', '25287.98', '1670.00'),
('N', '520', '0.00167', '25287.98', '1670.00'),
('N', '521', '0.00167', '25287.98', '1670.00'),
('N', '522', '0.00188', '28467.90', '1880.00'),
('N', '523', '0.00215', '32556.38', '2150.00'),
('N', '524', '0.0018', '27256.50', '1800.00'),
('N', '525', '0.00152', '23016.60', '1520.00'),
('N', '526', '0.00194', '29376.45', '1940.00'),
('N', '527', '0.00292', '44216.10', '2920.00'),
('N', '528', '0.00161', '24379.43', '1610.00'),
('N', '601', '0.00306', '46336.05', '3060.00'),
('N', '602', '0.00306', '46336.05', '3060.00'),
('N', '603', '0.00177', '26802.23', '1770.00'),
('N', '604', '0.00264', '39976.20', '2640.00'),
('N', '605', '0.00264', '39976.20', '2640.00'),
('N', '606', '0.00152', '23016.60', '1520.00'),
('N', '607', '0.00152', '23016.60', '1520.00'),
('N', '608', '0.00196', '29679.30', '1960.00'),
('N', '609', '0.00173', '26196.53', '1730.00'),
('N', '610', '0.0018', '27256.50', '1800.00'),
('N', '611', '0.00196', '29679.30', '1960.00'),
('N', '612', '0.00211', '31950.68', '2110.00'),
('N', '613', '0.00196', '29679.30', '1960.00'),
('N', '614', '0.00158', '23925.15', '1580.00'),
('N', '615', '0.00207', '31344.98', '2070.00'),
('N', '616', '0.00196', '29679.30', '1960.00'),
('N', '622', '0.00192', '29073.60', '1920.00'),
('N', '623', '0.00203', '30739.28', '2030.00'),
('N', '624', '0.00152', '23016.60', '1520.00'),
('N', '625', '0.0015', '22713.75', '1500.00'),
('N', '626', '0.00152', '23016.60', '1520.00'),
('N', '627', '0.00289', '43761.83', '2890.00'),
('N', '628', '0.00165', '24985.13', '1650.00'),
('N', '701', '0.00306', '46336.05', '3060.00'),
('N', '702', '0.00306', '46336.05', '3060.00'),
('N', '703', '0.00177', '26802.23', '1770.00'),
('N', '704', '0.00264', '39976.20', '2640.00'),
('N', '705', '0.00264', '39976.20', '2640.00'),
('N', '706', '0.00152', '23016.60', '1520.00'),
('N', '707', '0.00152', '23016.60', '1520.00'),
('N', '708', '0.00196', '29679.30', '1960.00'),
('N', '709', '0.00173', '26196.53', '1730.00'),
('N', '710', '0.0018', '27256.50', '1800.00'),
('N', '711', '0.00196', '29679.30', '1960.00'),
('N', '712', '0.00211', '31950.68', '2110.00'),
('N', '713', '0.00196', '29679.30', '1960.00'),
('N', '714', '0.00163', '24682.28', '1630.00'),
('N', '715', '0.00211', '31950.68', '2110.00'),
('N', '716', '0.00207', '31344.98', '2070.00'),
('N', '801', '0.00309', '46790.33', '3090.00'),
('N', '802', '0.00309', '46790.33', '3090.00'),
('N', '803', '0.00184', '27862.20', '1840.00'),
('N', '804', '0.00224', '33919.20', '2240.00'),
('N', '809', '0.00177', '26802.23', '1770.00'),
('N', '812', '0.00203', '30739.28', '2030.00'),
('N', '813', '0.00196', '29679.30', '1960.00'),
('N', '814', '0.00165', '24985.13', '1650.00'),
('N', '815', '0.00215', '32556.38', '2150.00'),
('N', '816', '0.00211', '31950.68', '2110.00'),
('N', '901', '0.0034', '51484.50', '3400.00'),
('N', '902', '0.0034', '51484.50', '3400.00'),
('N', '903', '0.00184', '27862.20', '1840.00'),
('N', '904', '0.00224', '33919.20', '2240.00'),
('N', '909', '0.00177', '26802.23', '1770.00'),
('N', '912', '0.00203', '30739.28', '2030.00'),
('N', '913', '0.00199', '30133.58', '1990.00'),
('N', '914', '0.00165', '24985.13', '1650.00'),
('N', '915', '0.00237', '35887.73', '2370.00'),
('N', '916', '0.00234', '35433.45', '2340.00'),
('N', '8901', '0.00241', '36493.43', '2410.00'),
('N', '8902', '0.00241', '36493.43', '2410.00'),
('N', '8903', '0.00241', '36493.43', '2410.00'),
('N', '8904', '0.00241', '36493.43', '2410.00'),
('N', '8905', '0.00241', '36493.43', '2410.00'),
('N', '8906', '0.00241', '36493.43', '2410.00'),
('N', '8907', '0.00241', '36493.43', '2410.00'),
('N', '8908', '0.00241', '36493.43', '2410.00'),
('N', '8909', '0.00241', '36493.43', '2410.00'),
('N', '8910', '0.00241', '36493.43', '2410.00'),
('N', '8911', '0.00241', '36493.43', '2410.00'),
('N', '8912', '0.00241', '36493.43', '2410.00'),
('S', '25', '0.0014', '21199.50', '1400.00'),
('S', '26', '0.0014', '21199.50', '1400.00'),
('S', '27', '0.0014', '21199.50', '1400.00'),
('S', '28', '0.0014', '21199.50', '1400.00'),
('S', '29', '0.0014', '21199.50', '1400.00'),
('S', '30', '0.0014', '21199.50', '1400.00'),
('S', '101', '0.00541', '81920.93', '5410.00'),
('S', '102', '0.00458', '69352.65', '4580.00'),
('S', '103', '0.00374', '56632.95', '3740.00'),
('S', '104', '0.00374', '56632.95', '3740.00'),
('S', '105', '0.00359', '54361.58', '3590.00'),
('S', '106', '0.00199', '30133.58', '1990.00'),
('S', '107', '0.00245', '37099.13', '2450.00'),
('S', '108', '0.00165', '24985.13', '1650.00'),
('S', '109', '0.0026', '39370.50', '2600.00'),
('S', '110', '0.00127', '19230.98', '1270.00'),
('S', '111', '0.0026', '39370.50', '2600.00'),
('S', '112', '0.00152', '23016.60', '1520.00'),
('S', '113', '0.00152', '23016.60', '1520.00'),
('S', '114', '0.00152', '23016.60', '1520.00'),
('S', '115', '0.00152', '23016.60', '1520.00'),
('S', '117', '0.00159', '24076.58', '1590.00'),
('S', '123', '0.00169', '25590.83', '1690.00'),
('S', '124', '0.00129', '19533.83', '1290.00'),
('S', '125', '0.00253', '38310.53', '2530.00'),
('S', '126', '0.00131', '19836.68', '1310.00'),
('S', '127', '0.00131', '19836.68', '1310.00'),
('S', '128', '0.00131', '19836.68', '1310.00'),
('S', '129', '0.00154', '23319.45', '1540.00'),
('S', '130', '0.00154', '23319.45', '1540.00'),
('S', '131', '0.00247', '37401.98', '2470.00'),
('S', '201', '0.00541', '81920.93', '5410.00'),
('S', '202', '0.00458', '69352.65', '4580.00'),
('S', '203', '0.00374', '56632.95', '3740.00'),
('S', '204', '0.00374', '56632.95', '3740.00'),
('S', '205', '0.00359', '54361.58', '3590.00'),
('S', '206', '0.00199', '30133.58', '1990.00'),
('S', '207', '0.00245', '37099.13', '2450.00'),
('S', '208', '0.00165', '24985.13', '1650.00'),
('S', '209', '0.00269', '40733.33', '2690.00'),
('S', '210', '0.00129', '19533.83', '1290.00'),
('S', '211', '0.00245', '37099.13', '2450.00'),
('S', '212', '0.0014', '21199.50', '1400.00'),
('S', '213', '0.0014', '21199.50', '1400.00'),
('S', '214', '0.0014', '21199.50', '1400.00'),
('S', '215', '0.0014', '21199.50', '1400.00'),
('S', '216', '0.00161', '24379.43', '1610.00'),
('S', '217', '0.0014', '21199.50', '1400.00'),
('S', '218', '0.00177', '26802.23', '1770.00'),
('S', '219', '0.0015', '22713.75', '1500.00'),
('S', '220', '0.0019', '28770.75', '1900.00'),
('S', '221', '0.00289', '43761.83', '2890.00'),
('S', '222', '0.00158', '23925.15', '1580.00'),
('S', '223', '0.00158', '23925.15', '1580.00'),
('S', '224', '0.00131', '19836.68', '1310.00'),
('S', '225', '0.0026', '39370.50', '2600.00'),
('S', '226', '0.00135', '20442.38', '1350.00'),
('S', '227', '0.00135', '20442.38', '1350.00'),
('S', '228', '0.00135', '20442.38', '1350.00'),
('S', '229', '0.00161', '24379.43', '1610.00'),
('S', '230', '0.00161', '24379.43', '1610.00'),
('S', '231', '0.00254', '38461.95', '2540.00'),
('S', '232', '0.0015', '22713.75', '1500.00'),
('S', '301', '0.00556', '84192.30', '5560.00'),
('S', '302', '0.00473', '71624.03', '4730.00'),
('S', '303', '0.00389', '58904.33', '3890.00'),
('S', '304', '0.00389', '58904.33', '3890.00'),
('S', '305', '0.00374', '56632.95', '3740.00'),
('S', '306', '0.00203', '30739.28', '2030.00'),
('S', '307', '0.00249', '37704.83', '2490.00'),
('S', '308', '0.00169', '25590.83', '1690.00'),
('S', '309', '0.00264', '39976.20', '2640.00'),
('S', '310', '0.00129', '19533.83', '1290.00'),
('S', '311', '0.00245', '37099.13', '2450.00'),
('S', '312', '0.0014', '21199.50', '1400.00'),
('S', '313', '0.0014', '21199.50', '1400.00'),
('S', '314', '0.0014', '21199.50', '1400.00'),
('S', '315', '0.0014', '21199.50', '1400.00'),
('S', '316', '0.00161', '24379.43', '1610.00'),
('S', '317', '0.0014', '21199.50', '1400.00'),
('S', '318', '0.0018', '27256.50', '1800.00'),
('S', '319', '0.0015', '22713.75', '1500.00'),
('S', '320', '0.00194', '29376.45', '1940.00'),
('S', '321', '0.00292', '44216.10', '2920.00'),
('S', '322', '0.00161', '24379.43', '1610.00'),
('S', '323', '0.00158', '23925.15', '1580.00'),
('S', '324', '0.00133', '20139.53', '1330.00'),
('S', '325', '0.00264', '39976.20', '2640.00'),
('S', '326', '0.00135', '20442.38', '1350.00'),
('S', '327', '0.00135', '20442.38', '1350.00'),
('S', '328', '0.00135', '20442.38', '1350.00'),
('S', '329', '0.00161', '24379.43', '1610.00'),
('S', '330', '0.00161', '24379.43', '1610.00'),
('S', '331', '0.00258', '39067.65', '2580.00'),
('S', '332', '0.00152', '23016.60', '1520.00'),
('S', '401', '0.00556', '84192.30', '5560.00'),
('S', '402', '0.00473', '71624.03', '4730.00'),
('S', '403', '0.00389', '58904.33', '3890.00'),
('S', '404', '0.00389', '58904.33', '3890.00'),
('S', '405', '0.00374', '56632.95', '3740.00'),
('S', '406', '0.00203', '30739.28', '2030.00'),
('S', '407', '0.00249', '37704.83', '2490.00'),
('S', '408', '0.00169', '25590.83', '1690.00'),
('S', '409', '0.00266', '40279.05', '2660.00'),
('S', '410', '0.00131', '19836.68', '1310.00'),
('S', '411', '0.00245', '37099.13', '2450.00'),
('S', '412', '0.0014', '21199.50', '1400.00'),
('S', '413', '0.0014', '21199.50', '1400.00'),
('S', '414', '0.0014', '21199.50', '1400.00'),
('S', '415', '0.0014', '21199.50', '1400.00'),
('S', '416', '0.00161', '24379.43', '1610.00'),
('S', '417', '0.0014', '21199.50', '1400.00'),
('S', '418', '0.0018', '27256.50', '1800.00'),
('S', '419', '0.0015', '22713.75', '1500.00'),
('S', '420', '0.00194', '29376.45', '1940.00'),
('S', '421', '0.00292', '44216.10', '2920.00'),
('S', '422', '0.00161', '24379.43', '1610.00'),
('S', '423', '0.00158', '23925.15', '1580.00'),
('S', '424', '0.00135', '20442.38', '1350.00'),
('S', '425', '0.00264', '39976.20', '2640.00'),
('S', '426', '0.00135', '20442.38', '1350.00'),
('S', '427', '0.00135', '20442.38', '1350.00'),
('S', '428', '0.00135', '20442.38', '1350.00'),
('S', '429', '0.00158', '23925.15', '1580.00'),
('S', '430', '0.00177', '26802.23', '1770.00'),
('S', '432', '0.00167', '25287.98', '1670.00'),
('S', '501', '0.00556', '84192.30', '5560.00'),
('S', '502', '0.00473', '71624.03', '4730.00'),
('S', '503', '0.00389', '58904.33', '3890.00'),
('S', '504', '0.00389', '58904.33', '3890.00'),
('S', '505', '0.00374', '56632.95', '3740.00'),
('S', '506', '0.00203', '30739.28', '2030.00'),
('S', '507', '0.00249', '37704.83', '2490.00'),
('S', '508', '0.00169', '25590.83', '1690.00'),
('S', '509', '0.00268', '40581.90', '2680.00'),
('S', '510', '0.0014', '21199.50', '1400.00'),
('S', '511', '0.00271', '41036.18', '2710.00'),
('S', '512', '0.00163', '24682.28', '1630.00'),
('S', '513', '0.00163', '24682.28', '1630.00'),
('S', '514', '0.00163', '24682.28', '1630.00'),
('S', '515', '0.00163', '24682.28', '1630.00'),
('S', '516', '0.00184', '27862.20', '1840.00'),
('S', '517', '0.00215', '32556.38', '2150.00'),
('S', '518', '0.0018', '27256.50', '1800.00'),
('S', '519', '0.00152', '23016.60', '1520.00'),
('S', '520', '0.00194', '29376.45', '1940.00'),
('S', '521', '0.00292', '44216.10', '2920.00'),
('S', '522', '0.0016', '24228.00', '1600.00'),
('S', '601', '0.00572', '86615.10', '5720.00'),
('S', '602', '0.00488', '73895.40', '4880.00'),
('S', '603', '0.00404', '61175.70', '4040.00'),
('S', '604', '0.00404', '61175.70', '4040.00'),
('S', '605', '0.00389', '58904.33', '3890.00'),
('S', '606', '0.00207', '31344.98', '2070.00'),
('S', '607', '0.00253', '38310.53', '2530.00'),
('S', '608', '0.00169', '25590.83', '1690.00'),
('S', '609', '0.00271', '41036.18', '2710.00'),
('S', '610', '0.00196', '29679.30', '1960.00'),
('S', '616', '0.00192', '29073.60', '1920.00'),
('S', '617', '0.00203', '30739.28', '2030.00'),
('S', '618', '0.00152', '23016.60', '1520.00'),
('S', '619', '0.0015', '22713.75', '1500.00'),
('S', '620', '0.00152', '23016.60', '1520.00'),
('S', '621', '0.00289', '43761.83', '2890.00'),
('S', '622', '0.00165', '24985.13', '1650.00'),
('S', '701', '0.00572', '86615.10', '5720.00'),
('S', '702', '0.00488', '73895.40', '4880.00'),
('S', '703', '0.00404', '61175.70', '4040.00'),
('S', '704', '0.00404', '61175.70', '4040.00'),
('S', '705', '0.00389', '58904.33', '3890.00'),
('S', '706', '0.00207', '31344.98', '2070.00'),
('S', '707', '0.00253', '38310.53', '2530.00'),
('S', '708', '0.00175', '26499.38', '1750.00'),
('S', '709', '0.00271', '41036.18', '2710.00'),
('S', '801', '0.00587', '88886.48', '5870.00'),
('S', '802', '0.00503', '76166.78', '5030.00'),
('S', '803', '0.0042', '63598.50', '4200.00'),
('S', '804', '0.0042', '63598.50', '4200.00'),
('S', '805', '0.00404', '61175.70', '4040.00'),
('S', '806', '0.00211', '31950.68', '2110.00'),
('S', '807', '0.00256', '38764.80', '2560.00'),
('S', '808', '0.00175', '26499.38', '1750.00'),
('S', '809', '0.00275', '41641.88', '2750.00'),
('S', '901', '0.00708', '107208.90', '7080.00'),
('S', '902', '0.00458', '69352.65', '4580.00'),
('S', '903', '0.00458', '69352.65', '4580.00'),
('S', '904', '0.00458', '69352.65', '4580.00'),
('S', '905', '0.00442', '66929.85', '4420.00'),
('S', '906', '0.00234', '35433.45', '2340.00'),
('S', '907', '0.00284', '43004.70', '2840.00'),
('S', '908', '0.00188', '28467.90', '1880.00'),
('S', '909', '0.00298', '45124.65', '2980.00'),
('TH', '1', '0.00307', '46487.48', '3070.00'),
('TH', '2', '0.00307', '46487.48', '3070.00'),
('TH', '3', '0.00307', '46487.48', '3070.00'),
('TH', '4', '0.0057', '86312.25', '5700.00'),
('TH', '5', '0.0057', '86312.25', '5700.00'),
('TH', '6', '0.0057', '86312.25', '5700.00'),
('TH', '7', '0.0057', '86312.25', '5700.00'),
('TH', '8', '0.00454', '68746.95', '4540.00'),
('TH', '9', '0.00368', '55724.40', '3680.00'),
('TH', '10', '0.00368', '55724.40', '3680.00'),
('TH', '11', '0.00368', '55724.40', '3680.00'),
('TH', '12', '0.00478', '72381.15', '4780.00'),
('TH', '13', '0.00368', '55724.40', '3680.00'),
('TH', '14', '0.00721', '109177.43', '7210.00'),
('TH', '15', '0.00307', '46487.48', '3070.00'),
('TH', '16', '0.003', '45427.50', '3000.00'),
('TH', '17', '0.00315', '47698.88', '3150.00');
最佳答案
这是 node-mysql
的问题。 echo_Me,您在尝试分离查询并单独运行它们方面走在了正确的轨道上。
来自 node-mysql
文档:
Support for multiple statements is disabled for security reasons (it allows for SQL injection attacks if values are not properly escaped). To use this feature you have to enable it for your connection:
var connection = mysql.createConnection({multipleStatements: true});
Once enabled, you can execute multiple statement queries like any other query.
谢谢大家的建议!
关于mysql - node-mysql中报SQL语法错误,查询在Sequel Pro中运行正常,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/18923998/
我有三张 table 。表 A 有选项名称(即颜色、尺寸)。表 B 有选项值名称(即蓝色、红色、黑色等)。表C通过将选项名称id和选项名称值id放在一起来建立关系。 我的查询需要显示值和选项的名称,而
在mysql中,如何计算一行中的非空单元格?我只想计算某些列之间的单元格,比如第 3-10 列之间的单元格。不是所有的列...同样,仅在该行中。 最佳答案 如果你想这样做,只能在 sql 中使用名称而
关闭。这个问题需要多问focused 。目前不接受答案。 想要改进此问题吗?更新问题,使其仅关注一个问题 editing this post . 已关闭 7 年前。 Improve this ques
我正在为版本7.6进行Elasticsearch查询 我的查询是这样的: { "query": { "bool": { "should": [ {
关闭。这个问题需要多问focused 。目前不接受答案。 想要改进此问题吗?更新问题,使其仅关注一个问题 editing this post . 已关闭 7 年前。 Improve this ques
是否可以编写一个查询来检查任一子查询(而不是一个子查询)是否正确? SELECT * FROM employees e WHERE NOT EXISTS (
我找到了很多关于我的问题的答案,但问题没有解决 我有表格,有数据,例如: Data 1 Data 2 Data 3
以下查询返回错误: 查询: SELECT Id, FirstName, LastName, OwnerId, PersonEmail FROM Account WHERE lower(PersonEm
以下查询返回错误: 查询: SELECT Id, FirstName, LastName, OwnerId, PersonEmail FROM Account WHERE lower(PersonEm
我从 EditText 中获取了 String 值。以及提交查询的按钮。 String sql=editQuery.getText().toString();// SELECT * FROM empl
我有一个或多或少有效的查询(关于结果),但处理大约需要 45 秒。这对于在 GUI 中呈现数据来说肯定太长了。 所以我的需求是找到一个更快/更高效的查询(几毫秒左右会很好)我的数据表大约有 3000
这是我第一次使用 Stack Overflow,所以我希望我以正确的方式提出这个问题。 我有 2 个 SQL 查询,我正在尝试比较和识别缺失值,尽管我无法将 NULL 字段添加到第二个查询中以识别缺失
什么是动态 SQL 查询?何时需要使用动态 SQL 查询?我使用的是 SQL Server 2005。 最佳答案 这里有几篇文章: Introduction to Dynamic SQL Dynami
include "mysql.php"; $query= "SELECT ID,name,displayname,established,summary,searchlink,im
我有一个查询要“转换”为 mysql。这是查询: select top 5 * from (select id, firstName, lastName, sum(fileSize) as To
通过我的研究,我发现至少从 EF 4.1 开始,EF 查询上的 .ToString() 方法将返回要运行的 SQL。事实上,这对我来说非常有用,使用 Entity Framework 5 和 6。 但
我在构造查询来执行以下操作时遇到问题: 按activity_type_id过滤联系人,仅显示最近事件具有所需activity_type_id或为NULL(无事件)的联系人 表格结构如下: 一个联系人可
如何让我输入数据库的信息在输入数据 5 分钟后自行更新? 假设我有一张 table : +--+--+-----+ |id|ip|count| +--+--+-----+ |
我正在尝试搜索正好是 4 位数字的 ID,我知道我需要使用 LENGTH() 字符串函数,但找不到如何使用它的示例。我正在尝试以下(和其他变体)但它们不起作用。 SELECT max(car_id)
我有一个在 mysql 上运行良好的 sql 查询(查询 + 连接): select sum(pa.price) from user u , purchase pu , pack pa where (
我是一名优秀的程序员,十分优秀!