Jump to content

Insert into


reportingsjr
 Share

Recommended Posts

WTF, Im using PHP myadmin which uses mysql 4.1.9 and this wont work!! can someone pleaaassse help me. I dont know why it wont work. When I do just one row at a time it works perfectly, but not when I do two or more.The mysql query is:

INSERT INTO lvls (minexp, maxexp)VALUES ('0', '124')VALUES ('125', '215');

and the table looks like this:Field|Type|otherslevel | int(255) | NOT NULL,auto_increment, primary keyminexp | int(255) | NULLmaxexp | int(255) | NULLThis is supposed to contain all the minimum and maximum level experiences. I already have like 300 of the levels done and this is for a calculator. Can someone please tell me why this wont work?

Link to comment
Share on other sites

I don't think that is hte correct syntax, You could write multiple insert statements in a stored procedure then execute the stored procedure when you want to insert multiple records.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...