[DiscordArchive] when inserting into tables should I always specify all values or can I rely on the default values?
[DiscordArchive] when inserting into tables should I always specify all values or can I rely on the default values?
Archived author: sijink • Posted: 2021-05-16T10:30:35.759000+00:00
Original source
when inserting into tables should I always specify all values or can I rely on the default values?
Archived author: sijink • Posted: 2021-05-16T10:31:18.879000+00:00
Original source
the SQL standards section in the wiki does not mention this
Archived author: Kitzunu • Posted: 2021-05-16T10:33:02.940000+00:00
Original source
Personally I prefer to specify everything to make less mistakes. But it is fine to just rely on default values as well, as long as you specify all columns you use like (`col1`,`col2`) VALUES
Archived author: sijink • Posted: 2021-05-16T10:33:40.045000+00:00
Original source
mkay thanks