I am currently migrating from MySQL to PostgreSQL in a Laravel application, and I noticed that when updatin, the row goes to the end of the table (bottom). In Mysql, it remains in the same position it occupied before the update. Is there any way to apply this function? Would it be a InnoDB feature? Using Navicat Premium 12.1 DBMS. I think this is just an aesthetic factor, but even so I would like to learn how to carry out this "permanent ordination". The database is in UTF-8 encoding and pt_BR.UTF8 collation and ctype. Following is the table:
CREATE TABLE properties
( id
int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, title
varchar(255) NOT NULL, description
text NOT NULL, name
varchar(255), rental_price
decimal(10, 2), sale_price
decimal(10, 2) );
Thank you all!
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire