Skip to content

[Help]Sql 5.5 syntax

Featured Replies

Yeap i will admit it im new to mysql and im try to learn so can someone help me with this? :)

 

INSERT INTO `spawnlist`  VALUES ('31124','83449','147905','-3405','0','60','0');
('31124','146740,'25864','-2005','0','60','0');
('31124','-80683','149811','-3047','0','60','0');
('31124','-12782','122820','-3109','0','60','0');
('31124','15582','142888','-2709','0','60','0');
('31124','111339','219425','-3538','0','60','0');
('31124','82992','53105','-1488','0','60','0');
('31124','147916','-55215','-2726','0','60','0');
('31124','87148','-143452','-1285','0','60','0');
('31124','43785','-47669','-790','0','60','0');
('31124','84070','244587','-3722','0','60','0');
('31124','46895','51478','-2969','0','60','0');
('31124','9633','15569','-4567','0','60','0');
('31124','115073','-178217','-878','0','60','0');
('31124','45276','112566','-232','0','60','0');
('31124','117102','76961','-2689','0','60','0');
('31124','17583','170146','-3500','0','60','0');
('30105','82229','148601','-3459','0','60','0');
('30105','147443','27244','-2207','0','60','0');
('30105','-81056','149419','-3036','0','60','0');
('30105','-12313','122641','-3096','0','60','0');
('30105','16742','142799','-2698','0','60','0');
('30105','111646','218873','-3520','0','60','0');
('30105','81962','53859','-1488','0','60','0');
('30105','147517','-56610','-2783','0','60','0');
('30105','87552','-142091','-1333','0','60','0');
('30105','44217','48503','-800','0','60','0');
('30105','-84681','244599','-3732','0','60','0');
('30105','46539','51583','-2988','0','60','0');
('30105','9516','15772','-4554','0','60','0');
('30105','114873','-178097','-824','0','60','0');
('30105','-44812','113440','-191','0','60','0');
('30105','116284','76922','-2731','0','60','0');
('30105','17382','170620','-3493','0','60','0');
('31324','83698','148395','-3408','0','60','0');
('31324','147098','25605','-2005','0','60','0');
('31324','-80840','149468','-3036','0','60','0');
('31324','-12662','122513','-3120','0','60','0');
('31324','16261','14289','-2698','0','60','0');
('31324','111171','218874','-3528','0','60','0');
('31324','82390','53244','-1488','0','60','0');
('31324','147313','-55725','-2742','0','60','0');
('31324','87768','-143007','-1301','0','60','0');
('31324','43566','-47671','-790','0','60','0');
('31324','-84188','244321','-3722','0','60','0');
('31324','46747','50992','-2980','0','60','0');
('31324','9795','15313','-4567','0','60','0');
('31324','114869','-178196','-822','0','60','0');
('31324','-45131','-112850','-232','0','60','0');
('31324','116965','77154','-2689','0','60','0');
('31324','17477','-169789','-3492','0','60','0');

 

i get this error

86882277.png

 

thanks :)

Either you make all lines looking as your first line (with a serious performance hurt in both query process and file weight)

 

INSERT INTO `` VALUES (``);
INSERT INTO `` VALUES (``);
INSERT INTO `` VALUES (``);

 

, either you do like that

 

INSERT INTO `` VALUES
(``),
(``),
(``);

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.