Last post Jan 20, 2015 10:40 AM by Glenn Saint
Jan 20, 2015 10:21 AM|MichaelCheong|LINK
how to insert data manually into database , auto-increment added automatically
the way i did is wrong? for the CustID i already set to auto increment, supposedly database will auto detect the id?
Jan 20, 2015 10:40 AM|Glenn Saint|LINK
Hi there, you need to specify the columns, something like these:
insert into customer (CustName, CustPhone, CustEmail) values ('Michael', 1223123, 'gmail.com')
Specify the columns excluding the field that is auto_increment.
Hope that helps.