[dkwnm] MySQLで指定されたカラム名を持つテーブルを検索する (2019/12/13) [2020/05/18]
<<< Add a column in the Table >>>
String url = "jdbc:mysql://" + Server + ":"+myport+"/" + Musicdatabase;
Connection conn = DriverManager.getConnection(url, MasterUser, MasterPassword);
statement = conn.createStatement();
String ColumnName1 = "NoOfAlbum VARCHAR(5) Default '' NOT NULL ";
statement.executeUpdate("ALTER TABLE `" + ArtistTbname + "` add " + ColumnName1 + " ;");
statement.executeUpdate("FLUSH PRIVILEGES;");
statement.close();
conn.close();