my table is not null autoincrement
in heidisql what if i do the query to
load my table.. can i right click and add a row
and edit it. i did that but it ends up ass null
if this kind of editing can be done how do i
make the new row autoincrement not null like
the rest of the table
autoincrement
All table row additions done "manually" are treated the same way as with a queried INSERT as the resulting MySQL syntax is the same.
A field declared AUTO_INCREMENT and NOT_NULL therefore automatically receives the next increment and does not stay 'NULL'. Your changes (manual or not) do not influence the way your ID is defined or handled.
A field declared AUTO_INCREMENT and NOT_NULL therefore automatically receives the next increment and does not stay 'NULL'. Your changes (manual or not) do not influence the way your ID is defined or handled.
Please login to leave a reply, or register at first.