I actually prefer that instead of tablenameID. I typically don't like alliteration in my SQL queries or code function calls. I'd much rather invoke select * from users where id = ? instead of select * from users where userid=?
select * from users where id = ?
select * from users where userid=?
I find the first one more readable and understandable as well.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.