Arrays in MySQL Stored Procedures

mysql> select array_get_value_by_key(('mysql_array_name','index' );

mysql> select array_get_value_by_index('mysql_array_name','index' );

mysql> array_unshift('mysql_array_name', 'value'); --Inserts a value into mysql array

mysql> select array_shift('mysql_array_name'); --Deletes the last element in the mysql array

mysql> array_push('mysql_array_name', 'value'); --Inserts a value into mysql array at the end/top

mysql> array_po('mysql_array_name'); --returns the top/last_inserted element from the mysql array (Last in First out)

mysql> call array_show( 'mysql_array_name' );

mysql> call array_list(); --List of all arrays;

mysql> call array_full_list(); --List of all arrays;

• function array_create


• function array_copy_complete


• function array_grep_complete


• function array_grep


• function array_copy


• function array_append


• function array_sort_complete


• function array_sort


• function array_merge_complete


• function array_merge


• function array_from_list_complete


• function array_from_list


• function array_from_pair_list_complete


• function array_from_pair_list


• function array_set_value_by_key


• function array_unshift


• function array_push


• function array_set_key_by_index


• function array_set_value_by_index


• function array_set


• function array_setn


• function array_get_value_by_index


• function array_get_key_by_index


• function array_to_list_complete


• function array_to_list


• function array_to_pair_list_complete


• function array_to_pair_list


• function array_get_value_by_key


• function array_get


• function array_clear


• function array_drop


• function array_size


• function array_max_index


• function array_exists


• function array_pop


• function array_shift


• procedure array_create


• procedure array_copy_complete


• procedure array_grep_complete


• procedure array_grep


• procedure array_copy


• procedure array_append


• procedure array_sort_complete


• procedure array_sort


• procedure array_merge_complete


• procedure array_merge


• procedure array_from_list_complete


• procedure array_from_list


• procedure array_from_pair_list_complete


• procedure array_from_pair_list


• procedure array_set_value_by_key


• procedure array_unshift


• procedure array_push


• procedure array_set_key_by_index


• procedure array_set_value_by_index


• procedure array_set


• procedure array_list


• procedure array_show


• procedure array_full_list


• procedure array_clear


• procedure array_drop