If you've ever dealt with databases, you've almost certainly come across the term - primary key (PK). And if you're following this series to learn about databases, this piece should help you understand what the PK is all about. Even if you're a database specialist, you could learn something new or improve your skills. So sit back, relax, and let's get started with the PKs.
Blog to learn about SQL, database, Oracle, SQL Server, MySQL, PostgreSQL concepts and much more.
Sunday, February 27, 2022
Sunday, February 20, 2022
How to use WHERE , LIKE, and BETWEEN in SQL for Filtering Rows? Example Tutorial
You may be thinking why is the filtering of data needed? Because you utilize the WHERE clause when changing data with DELETE and UPDATE statements, if you've been following these Database Fundamentals posts, you've already seen it. It's also been used to restrict the values returned from a SELECT operation multiple times in this series.
Subscribe to:
Posts (Atom)