line show column name

show columns

Copied mysql> SHOW COLUMNS FROM City;
+------------+----------+------+-----+---------+----------------+
| Field      | Type     | Null | Key | Default | Extra          |
+------------+----------+------+-----+---------+----------------+
| Id         | int(11)  | NO   | PRI | NULL    | auto_increment |
| Name       | char(35) | NO   |     |         |                |
| Country    | char(3)  | NO   | UNI |         |                |
| District   | char(20) | YES  | MUL |         |                |
| Population | int(11)  | NO   |     | 0       |                |
+------------+----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

Posted by: Guest on June-09-2020

Source

public static List<String> getColumnNames(){ List<String> columnList = new ArrayList<>(); try { ResultSetMetaData rsMetaData = rs.getMetaData(); for (int colNum = 1; colNum < getColumnCount() ; colNum++) { columnList.add(rsMetaData.getColumnLabel(colNum)); } } catch (SQLException e) { System.out.println("ERROR WHILE GETTING COLUMN NAMES "+ e.getMessage()); } return columnList; }

Code answers related to "line show column name"

Browse Popular Code Answers by Language

Answers for "line show column name"

Code answers related to "line show column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us