sandy1028 Posted July 24, 2009 Share Posted July 24, 2009 Hi, I have created a table which has 3 fields and one field named 'id' is auto increment filed. How to write the insert statement. Quote Link to comment https://forums.phpfreaks.com/topic/167252-insert-statement/ Share on other sites More sharing options...
kickstart Posted July 24, 2009 Share Posted July 24, 2009 Hi I normally specify the auto increment field as NULL:- INSERT INTO SomeTable (Id, Field1, Field2, Field3) VALUES (NULL, 'Field 1 value', 'Field 2 Value', 'Field 3 Value') All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/167252-insert-statement/#findComment-881855 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.