Home » Web development

Web development

MySQL Auto Increment and reset

Auto Increment Column is a quite common requirement in the coding. Here are some of the ways to get that in MySQL . we will also check about MySQL Auto Increment reset Auto Increment Column MySQL database The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows Example use techdb; CREATE …

MySQL Auto Increment and reset Read More »

MySQL COALESCE and NULLIF Function

We will be discussing MySQL COALESCE and NULLIF Function in this post. We will also be showing  MySQL COALESCE  examples and NULLIF MySQL Function example MySQL COALESCE Function COALESCE  in MySQL is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent …

MySQL COALESCE and NULLIF Function Read More »

Scroll to Top