need a little help with MySQL and PHP

igowerf

Diamond Member
Jun 27, 2000
7,697
1
76
Forgive me but I'm new to MySQL stuff. How do I change/edit a value in a field?
Also, I created a table where one of the columns is an auto incrementing index (at least that's what I think I did). If I delete a row, will the index automatically adjust itself? Thanks.
 

kt

Diamond Member
Apr 1, 2000
6,031
1,346
136
Welcome to the world of SQL. To change/edit a value in a field, you need to send an update SQL statement to the MySQL server. As for the auto incrementing, all that mean is when you insert a row into the table, the field that is set for auto incrementing will be incremented to the next higher number. And when you delete a row, it will not adjust itself.