Naming your users and specifying their host does not have to be permanent. However, to implement any changes to those two fields, it is better to use the RENAME USER command as opposed to directly updating MySQL system tables. Read on to learn about this command with me…
Oftentimes, those less-than-obvious gems of programming go unnoticed. Some things are in place for us to utilize, yet we never think about them. In this blog post, I will cover how you can use the integer data type itself, as a sort of validation constraint for data coming into your table(s). Of course, all situations are unique, so this is not a one-size-fits-all solution. However, under the right circumstances, it could be a handy little trick to have up your sleeve.
[Head this way for more great MySQL blogging >>>]Conditional logic is integral for just about any application. Most programming languages support some form of if/else construct. MySQL is a dialect of SQL, which is a declarative language. But, it also includes support for conditional flow as do other languages such as Python, PHP, and Java. In this blog post, I will look at the IF() Function for similar if/else type of functionality.
[Head this way for more great MySQL blogging >>>]Having recently upgraded my learning/development environment to MySQL 8 from version 5.7, I thought to start blogging on a couple of the (many) new fantastic features included in this latest version. With this blog post, I will begin what I plan to be a multi-part series on Common Table Expressions as I learn, explore, and use them…
[Head this way for more great MySQL blogging >>>]DML or Data Manipulation Commands should be handled with utmost care in SQL for the simple reason they modify the targeted data in some way. Typically, this is via UPDATE or DELETE statements. In this blog post, we will learn how to better protect the data (and ourselves) when running these types of commands by utilizing a SAVEPOINT within a TRANSACTION.
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.