The SELECT clause has more uses than just returning those columns you specify in your query. Want to see a handy use for it? Need to populate a table with values from another table? But don’t want to do it by hand? You are in luck…
[Want to know how? Keep reading…]
Want to ensure no duplicate values are stored in your database table columns? Certain requirements often dictate that all values for a particular column (or columns) should not be identical and remain individually unique. But how do you ensure this is handled in the database, without your required, immediate intervention? The UNIQUE constraint. In this blog post, we will see how by example…
ENUM data types are an interesting lot to me. I have previously blogged – in a high-level sense – on incorporating them with a TRIGGER for a sort of check constraint, which MySQL does not have. But what exactly is an ENUM? What are its advantages and disadvantages over other string data types? When would you use it and why? Join me and we will learn together…
We have seen in previous blog posts, 2 uses of the MySQL SELECT INTO syntax. Yet, there is a third use to know and learn about which we will explore in this blog post.
Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…
On this website we use first or third-party tools that store small files (cookie) on your device. Cookies are normally used to allow the site to run properly (technical cookies), to generate navigation usage reports (statistics cookies) and to suitable advertise our services/products (profiling cookies). We can directly use technical cookies, but you have the right to choose whether or not to enable statistical and profiling cookies. Enabling these cookies, you help us to offer you a better experience.