Obtener los Triggers de una tabla MySQL
MySQL
Publicado el 18 de Marzo del 2020 por Katas (32 códigos)
1.839 visualizaciones desde el 18 de Marzo del 2020
Consulta SQL para devolver los nombre de los triggers de una tabla.
x=[["a", 5, 7], ["c", 3, 4], ["b", 1, 9]]
sortMatrix(x, 0) # [['a', 5, 7], ['b', 1, 9], ['c', 3, 4]]
sortMatrix(x, 0, True) # [['c', 3, 4], ['b', 1, 9], ['a', 5, 7]]
sortMatrix(x, 1) # [['b', 1, 9], ['c', 3, 4], ['a', 5, 7]]
sortMatrix(x, 1, True) # [['a', 5, 7], ['c', 3, 4], ['b', 1, 9]]
sortMatrix(x, 2) # [['c', 3, 4], ['a', 5, 7], ['b', 1, 9]]
sortMatrix(x, 2, True) # [['b', 1, 9], ['a', 5, 7], ['c', 3, 4]]
x = {1: 2, 3: 4, 4: 3, 2: 1, 0: 0}
sortDictionary(x, 0) # {0: 0, 1: 2, 2: 1, 3: 4, 4: 3}
sortDictionary(x, 0, True) # {4: 3, 3: 4, 2: 1, 1: 2, 0: 0}
sortDictionary(x, 1) # {0: 0, 2: 1, 1: 2, 4: 3, 3: 4}
sortDictionary(x, 1, True) # {3: 4, 4: 3, 1: 2, 2: 1, 0: 0}
reverseInParentheses("bar"); // "bar"
reverseInParentheses("(bar)"); // "rab"
reverseInParentheses("foo(bar)baz(blim)"); // "foorabbazmilb"
reverseInParentheses("foo(bar(baz))blim"); // "foobazrabblim"
reverseInParentheses("12(34(56))78(90)"); // "1256437809"
list_flat([1, 2, 3]) # [1, 2, 3]
list_flat([[1], [], 2, [3,[4, 5, 6]], 7]) # [1, 2, 3, 4, 5, 6, 7]
list_flat([[[], []], []]) # []
list_flat([1, [[], []], []]) # [1]
list_flat([1, [["a"], [[[[["e"]]]]]], [["i"]]]) # [1, 'a', 'e', 'i']
deep_flatten([[[1],2],3,[4,5]]) # [1, 2, 3, 4, 5]
deep_flatten([1, [2], [[3], 4], 5]) # [1, 2, 3, 4, 5]
deep_flatten([1, 2, 3]) # [1, 2, 3]
deep_flatten([[1], [], 2, [3,[4, 5, 6]], 7]) # [1, 2, 3, 4, 5, 6, 7]
deep_flatten([[[], []], []]) # []
deep_flatten([1, [[], []], []]) # [1]
reverse("the big house"); // esuoh gib eht