Skip to main content

​
Overview

Inserts a new month record into tab_meses with an auto-incremented ID.

​
Signature

fun_insert_meses(
    wname_mes VARCHAR
) RETURNS VARCHAR

​
Parameters

​
wname_mes
VARCHAR
required
Month name

​
Returns

  • 'todo bn' - Month inserted successfully
  • Other message - Insert failed

​
Example Usage

-- Insert a new month
SELECT fun_insert_meses('mayo');

-- Insert another month
SELECT fun_insert_meses('junio');

​
Validation Rules

  • Month name cannot be NULL
  • Month name should be unique

​
Source

source/func/meses/fun_insert_meses.sql

Build docs developers (and LLMs) love

Get started for freeTalk to us