disappeared record of a mysql table

Question

disappeared record of a mysql table

Navigation

#1 by (4 votes)

1

In an inscription table to attend an event, the "7" record has "disappeared". It does not appear on the screen when you dump the table with

$query="SELECT * FROM aligxager"; 

$results = mysql_query($query,$link) or die('Error en la petición SQL.');
$cont = 0;
while ($row = mysql_fetch_array($results)) {
    $cont ++;
    //Nom
    echo '<tr>';
    foreach($row as $field) {
    echo '<td>' . htmlspecialchars($field) . '</td>';
}
echo '</tr>';
}   
mysql_free_result($results);
mysql_close();

There is some way to find out what is in the registry and how its "disappearance" occurred

mysql

asked by Joan Inglada Roig 31.03.2017 в 09:57

source

1 answer

Problem when creating MySQL tables with PhpMyadmin Limit maxlength in vue.js

score 4 · Accepted Answer

If the record does not exist it is difficult to find out what was in that record without a backup copy.

The most probable reason is that the operation was not completed, if it was in a transaction, for example and there was an error, that record is not recorded but the identification of the operation is not recovered for another operation, therefore, the next record would have a jump. But this behavior is normal, you do not have to worry.