Jump to content
  • 0

[Help]Sql 5.5 syntax


Question

Posted

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 :)

1 answer to this question

Recommended Posts

  • 0
Posted

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
(``),
(``),
(``);

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...