Eihen

-- https://stackoverflow.com/questions/2250775/force-innodb-to-recheck-foreign-keys-on-a-table-tables
DELIMITER $$

DROP PROCEDURE IF EXISTS ANALYZE_INVALID_FOREIGN_KEYS$$

CREATE
    PROCEDURE `ANALYZE_INVALID_FOREIGN_KEYS`(
        checked_database_name VARCHAR(64), 
        checked_table_name VARCHAR(64), 
        temporary_result_table ENUM('Y', 'N'))

Eihen

#!/bin/bash

# REQUIREMENTS:
# 1) SSH Access to the remote server
# 2) Reading the whole script and understanding what it does before using it
#    	If you can't understand something, let me know and I'll be happy to help
# 3) Understanding that this script is provided as-is and I have no responsibility for whatever damage occurs
#    That said, if the script was strictly tested and no problems should arise if you use it without any modifications
#	of areas which not states that can be modified
#    Also if you find any problems let me know to see if I can help you (and/or fix the script)

Eihen

# REQUIREMENTS
# 1) Understanding that this script is provided as-is and I have no responsibility for whatever damage occurs
#    That said, if the script was strictly tested and no problems should arise if you use it without any modifications
#	of areas which not states that can be modified
#    Also if you find any problems let me know to see if I can help you (and/or fix the script)

# Put this at the end of your ~/.bashrc if you already have one or just throw it in your home directory if you don't
# Make sure there are no other scripts starting ssh-agents or adding keys

# This assumes you have https://github.com/magicmonty/bash-git-prompt in your home directory

Eihen

INSERT INTO alunos VALUES (
  ALUNO_TY (
    '55522214800',
    '1234567890',
    'Manuel',
    'Avenida Qualquer',
    'emaiu@serv.dot',
    '123456789',
    'Tramandai',
    'RS',

Eihen

using System.Collections.Generic;
using System.Data;

// Abstract class, can't be used directly, needs to be inherited in another class implementing the abstract methods

/// <summary>
/// Generic class for DataBase management implementing methods that doesn't depend on the DataBase used
/// </summary>
public abstract class Database
{