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

  • 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 Jan 17 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 Jan 17 at 18:15
  • Those rows are sorted as strings, not numbers. What process generated them? – Rick James Jan 20 at 5:14
-1

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

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

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