I want to insert a field into a table and then I want to change the order of the field I inserted and another field. Technically all I want to do is reorder just two fields, because the field at the end of the table is just a primary key or identifier for each record; all the other fields are important and the order does matter. Therefore, I want the fields I add to be inserted before the last field or column in each table. I've looked over several postings related to this issue and I've found that most of the postings mentioned that this isn't possible, but one posting did mention that you could change the coding of the ALTER command like so:
ALTER TABLE the_table
CHANGE COLUMN email email VARCHAR(255) AFTER id;
, which was posted by VoteyDisciple in this posting: https://www.experts-exchange.com/Databases/Mysql/Q_22074916.html
I was wondering if this posting is considered correct, a mistake or does this code refer to another sql engine other than MS Access, because I can't seem to get the code to work on my database and I just wanted to know if this code could be altered to accomplish what I desire or if there existed another technique to accomplish what I want.