Is it possible to update a column in a mysql database and how? I.E, changing prices of products.
also another small question with mysql, after deleteing a record, the index or id doesn't reflect the change. for example if i had three records, and i decided for some reason i didn't need or want the second one anymore and delete it, the next record would be #4 not #3. is there a way to make the database recount?
well obviously drop the table and start over but thats a pain if u have a few hundred entries
also another small question with mysql, after deleteing a record, the index or id doesn't reflect the change. for example if i had three records, and i decided for some reason i didn't need or want the second one anymore and delete it, the next record would be #4 not #3. is there a way to make the database recount?
well obviously drop the table and start over but thats a pain if u have a few hundred entries