get_column_names

Function get_column_names 

Source
pub async fn get_column_names(
    conn: &mut Conn,
    db_name: &str,
    table_name: &str,
) -> Result<Vec<String>>
Expand description

Get column names for a MySQL table

Queries INFORMATION_SCHEMA to get all column names for a table.

§Arguments

  • conn - MySQL connection
  • db_name - Database name
  • table_name - Table name

§Returns

Vector of column names in order

§Examples

let mut conn = connect_mysql("mysql://localhost:3306/mydb").await?;
let columns = get_column_names(&mut conn, "mydb", "users").await?;