0

I am using MySQL 5.6.44 within phpMyAdmin on Go Daddy shared hosting and experimenting with some duplicate table data.

I am trying to figure out, when I export my table from phpMyAdmin the exported sql file structure when opened does not match the schema seen in the admin panel. By that I mean the row sequence in the sql file are jumbled up.

I don't have any foreign key constraints set up or any other operations on the table.

Any steering and knowledge as to why this might be the case would be appreciated.

enter image description here

Improve this question
3
  • If you want an order on your data, you need to use an order by clause. An SQL database makes no guarantees about the order the data is stored or returned.
    – Colin 't Hart
    Commented Jan 17, 2020 at 12:02
  • appreciate the notes but what resolved the issue as mentioned was changing the engine as I mentioned from MyISAM to InnoDB.
    – stack rookie
    Commented Jan 17, 2020 at 18:15
  • Those rows are sorted as strings, not numbers. What process generated them?
    – Rick James
    Commented Jan 20, 2020 at 5:14

1 Answer 1

Reset to default
-1

The issue disappeared when I changed the engine from MyISAM to InnoDB. I understand that InnoDB has row locking.

Improve this answer
4
  • What does the row order have to do with locking?
    – mustaccio
    Commented Jan 17, 2020 at 19:19
  • My solution works, appreciate the down vote.
    – stack rookie
    Commented Jan 17, 2020 at 20:11
  • You might find this Q&A useful.
    – mustaccio
    Commented Jan 17, 2020 at 20:18
  • I suspect it was coincidence that led to it "working".
    – Rick James
    Commented Jan 20, 2020 at 5:14

Not the answer you're looking for? Browse other questions tagged or ask your own question.