Inserindo e removendo uma coluna no banco de dados

Inserindo e removendo uma coluna no banco de dados

Inserindo a coluna:

    try {
        Statement stmt = connection.createStatement();
    
        // Prepare a statement to insert a record
        String sql = "INSERT INTO minha_tabela (col_string) VALUES('a string')";
    
        // Execute the insert statement
        stmt.executeUpdate(sql);
    } catch (SQLException e) {
    }

Removendo a coluna:

    try {
        // Create a statement
        Statement stmt = connection.createStatement();
    
        // Prepare a statement to insert a record
        String sql = "DELETE FROM minha_tabela WHERE col_string='a string'";
    
        // Execute the delete statement
        int deleteCount = stmt.executeUpdate(sql);
        // deleteCount contains the number of deleted rows
    
        // Use a prepared statement to delete
    
        // Prepare a statement to delete a record
        sql = "DELETE FROM minha_tabela WHERE col_string=?";
        PreparedStatement pstmt = connection.prepareStatement(sql);
        // Set the value
        pstmt.setString(1, "a string");
        deleteCount = pstmt.executeUpdate();
        System.err.println(e.getMessage());
    } catch (SQLException e) {
    }