Public feed #376398

Unnamed

public text v1 · immutable
Raw Edit
·published 2007-03-01 00:18 UTC
rendered paste body
SQL error:

Query:
-- drop table `meta_data`; -- create table if not exists `meta_data` (`ID` INT(11) not null auto_increment primary key, `name` varchar(80), `description` varchar(512), `ord` int(10) unsigned, `class` varchar(16), `mendatory` varchar(3) ); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('ID', 'ID', 0, 'numint', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('Name', 'Name', 1, 'default', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('object_type', 'Object type', 2, 'default', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('RAH', 'RA (h)', 3, 'numint', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('RAm', 'RA (m)', 4, 'numint', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('RAs', 'RA (s)', 5, 'numreal', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('DECd', 'DEC °', 6, 'numint', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('DECm', 'DEC (m)', 7, 'numint', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('DECs', 'DEC (s)', 8, 'numreal', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('other_names', 'Known names', 9, 'default', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('reference', 'Reference', 10, 'default', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('observed', 'Observed with', 11, 'default', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('longitude', 'Longitude (l)', 12, 'numreal', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('latitude', 'Latitude (b)', 13, 'numreal', 'yes'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('Galactic_height', 'Galactic height < z >', 14, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('morph_type', 'Morph. type', 15, 'default', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('statist_dist', 'Statistical distance', 16, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('agestat', 'Age(stat.dist.)', 17, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('size1', 'size(axis 1)', 18, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('size2', 'size(axis 2)', 19, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('expvel1', 'expansion velocity 1', 20, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('expvel2', 'expansion velocity 2', 21, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('LSR_vel', 'LSR velocity', 22, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('image', 'Image', 23, 'image', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('spectral_type', 'numreal', 24, 'default', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('n_e', 'ne electronic density', 25, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('dust_temp', 'Dust temperature', 26, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('Luminosity', 'Luminosity d2S(2cm)', 27, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('population', 'Population', 28, 'default', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('envelope_presence', 'Envelope presence', 29, 'default', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('central_star', 'Central star', 30, 'default', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('Teff', 'Teff', 31, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('stellar_magU', 'Stellar magnitude U', 32, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('stellar_magB', 'Stellar magnitude B', 33, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('stellar_magV', 'Stellar magnitude V', 34, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('HeH', 'He&#8260;H', 35, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('N_O', 'N&#8260;O', 36, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('logT', 'log (T)', 37, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('logLLsun', 'log(L/Lsun)', 38, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('temp1225', 'Temperature [12]-[25]', 39, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('temp2560', 'Temperature [25]-[60]', 40, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('h_beta', 'H&#946; surface brightness', 41, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('h_betaextinc', 'H&#946; surface brightness with extinction', 42, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('IRAS12micro', 'IRAS 12 microns', 43, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('IRAS25micro', 'IRAS 25 microns', 44, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('IRAS60micro', 'IRAS 60 microns', 45, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('IRAS100microns', 'IRAS 100 microns', 46, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('log1225', 'log([12]-[25]) -2.5log(iras12/iras25)', 47, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('log2560', 'log([25]-[60]) -2.5log(iras25/iras60)', 48, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('c_opt', 'copt H&#946; dereddend constant', 49, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('fluxHeIIlambda4686H_beta', 'flux [HeII]&#955;4686&#8260;H&#946;', 50, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('OIIIlambda4363H_beta', '[OIII]&#955;4363&#8260;H&#946;', 51, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('OIIIlambda5007withH_beta100', '[OIII]&#955;5007 with H&#946; =100', 52, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('HeIlambda5876H_beta', 'HeI]&#955;5876&#8260;H&#946;', 53, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('H_alphaH_beta', 'H&#945;&#8260;H&#946;', 54, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('NIIlambda6584H_beta', '[NII]&#955;6584&#8260;H&#946;', 55, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('SIIambda6717H_beta', '[SII]&#955;6717&#8260;H&#946;', 56, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('SIIlambda6731H_beta', '[SII]&#955;6731&#8260;H&#946;', 57, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('flux2cm', 'flux (2cm) mJy', 58, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('H_betaobserv', 'H&#946;observed', 59, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('superfic_bright6cm', 'Superficial brightness (6cm)', 60, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('SIIlambda6717SIIlambda6731', '[SII]&#955;6717&#8260;[SII]&#955;6731', 61, 'numreal', 'no'); INSERT INTO `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) VALUES ('NIIh_alpha', '[NII]&#8260;H&#945;', 62, 'numreal', 'no');

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 `meta_data` (`name`, `description`, `ord`, `class`, `mendatory`) V' at line 3