I'm using the XAMPP v3.1.0 Windows edition.
I found that the last record inserted after inserting a record in PHP is not the last one in phpMyAdmin, then I click the ID in the header of the result, and then the query result is incremented by ID, and the query statement becomes this:
SELECT *
From table
ORDER by table. ' ID ' ASC
LIMIT 0, 30
Changes can only modify the SELECT * from table this part, the following can not be modified.
and click on the primary key to sort the dropdown list after the jobless is not responding, you cannot remove the ORDER BY clause.
The strange thing is that I deleted the table after it was exported, and then there was an ORDER BY clause in the import.
I have three questions, the first is how to get rid of the ORDER BY clause, the second is the last record inserted in PHP in phpMyAdmin, why not the last one, and the third is the order of the results without order is the physical order of the database.
--------------------------------------------------
I just recovered that thing myself, and that thing was saved in the Pma_table_uiprefs table in the phpMyAdmin database, and after the deletion of the tables corresponding to the interface error, the restart service resumed. That table blob file I looked, it seems that some phpMyAdmin interface configuration, do not know whether the deletion will be a problem? After removing the ORDER BY clause, the sequence is messy.
--------------------------------------------------
There's something I didn't say:
The primary key of the table is set to self-increment key. I imported some data before inserting it in PHP, like this:
1 xx
2 SS
3 RR
Then insert it in PHP. After multiple insertions, this is the case:
1 xx
2 SS
3 RR
4 WW
1 xx
2 SS
3 RR
5 EE
4 WW
1 xx
2 SS
3 RR
6 TT
5 EE
4 WW
But I just import the structure of the table and insert it with PHP is normal. However, when inserting the ID is not starting from 0, but rather a larger number, should be the last ID to use the next, such as:
+ GG
+-II
How do you make it start from 0? (Or is it 1?) ）
Really do not want to waste points, my problem is more, points or save a bit of it. If there is a satisfactory answer I will add points, if it can be fully resolved I will add 80 points, including the direct deletion of the phpMyAdmin database in the table records will not be a problem.
Reply to discussion (solution)
Run SQL:
ALTER TABLE ' Your table name ' Auto_increment=1
The precondition is that the current table data is empty;
The first one is how to get rid of the ORDER BY clause
One more time.
The second is when the last record inserted in PHP is viewed in phpmyadmin. Why not the last one ?
See if it's the last, depending on the value and sort of the primary key
The third is whether the order of the results of an order by is the physical order in the database
Default sort primary Key ascending
Can be understood as physical order
Execute before inserting data
SET sql_mode= "No_auto_value_on_zero";
Can disable "self-increment", but you need to ensure that the primary key is unique
Command
TRUNCATE Table Name
The table can be emptied and the "self-increment" reset
The first one is how to get rid of the ORDER BY clause
One more time.
The second is when the last record inserted in PHP is viewed in phpmyadmin. Why not the last one?
See if it's the last, depending on the value and sort of the primary key
The third is whether the order of the results of an order by is the physical order in the database
Default sort primary Key ascending
Can be understood as physical order
Execute before inserting data
SET sql_mode= "No_ ...
Added 30 points.
