Skip to content
Roy Tutorials
You are here
  • Home
  • mysql function

Categories

  • Build Tool
    • Gradle
    • Jenkins
    • Maven
  • C
    • Array
    • Data Structure
    • Search Algorithm
    • Sort Algorithm
    • Structure
  • Cloud
    • Heroku
  • Database
    • HSQL
    • Liquibase
    • MongoDB
    • MySQL
    • PostgreSQL
    • SQLite
  • Docker
  • Email
  • File
    • Excel
    • File Download
    • File Upload
    • Word
  • Git
  • GraphQL
  • Java
    • Activiti
    • Code Quality
    • Cucumber
    • Design Pattern
    • Drools
    • Junit
    • Log4J
  • JMS
    • ActiveMQ
  • Kafka
  • Kotlin
  • Mosquitto
  • Mule ESB
  • ORM
    • Hibernate
    • JPA
  • PHP
    • Codeigniter
    • Wordpress
  • Python
    • Django
    • Flask
  • Security
    • htaccess
  • Siteminder
  • Spring
    • Spring AOP
    • Spring Batch
    • Spring Boot
    • Spring Cloud
    • Spring Core
    • Spring Email
    • Spring Integration
    • Spring JDBC
    • Spring JPA
    • Spring MVC
    • Spring REST
    • Spring Security
    • Spring SOAP
    • Spring Transaction
    • Spring WebFlux
  • Twitter4j
  • Unix
  • Web Tech
    • JavaScript
      • AJAX
      • Angular
      • Bootstrap
      • jQuery
      • NodeJS
      • React JS
    • JSF
    • JSP
    • Microservices
    • Reactive Programming
    • Selenium
    • Server
    • Servlet
    • Struts
    • Web Services
      • REST
        • Rest Assured
        • Swagger
      • SOAP
    • WebSocket
  • XAMPP

Tag: mysql function

MySQL Function to Capitalize the First Letter of Words in a String

24th Jun, 201924th Jun, 2019 Soumitra

The below MySQL function will show how to capitalize first letter of each word in a string.

Continue
MySQLmysql functionLeave a comment

Generate Zero-fill Auto-incremented Id in MySQL

24th Aug, 202024th Aug, 2020 Soumitra

Introduction This tutorial shows how to generate zero-fill auto-incremented unique identifier in MySQL. Sometimes you may need to generate such keys which are used in some part of the application for business logic. Below example shows how to generate zero-fill auto-incremented id in MySQL table.

Continue
MySQLmysql function, UniqueLeave a comment

Custom regex function to replace characters in MySQL

21st Jun, 201921st Jun, 2019 Soumitra

This tutorial shows how to replace the characters in a string or text using regular expression in MySQL function. There is no built-in function available to replace any character in a string or text in MySQL so here I am creating a custom function.

Continue
MySQLmysql function, Regex, Validation3 Comments
Subscribe for Email Updates

Copyright © 2014 - 2021

Privacy | Terms & Conditions