reportingsjr Posted April 8, 2006 Share Posted April 8, 2006 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 More sharing options...
aspnetguy Posted April 8, 2006 Share Posted April 8, 2006 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now