首先放置主键,然后放置外键,最后放置所有其他列。如果表有任何的系统列(created_at、updated_at、is_deleted 等),将这些列放在最后。
created_at
updated_at
is_deleted
-- Good select id, name, created_at from users -- Bad select created_at, name, id, from users