COM_FIELD_LIST

Note

As of MySQL 5.7.11, COM_FIELD_LIST is deprecated and will be removed in a future version of MySQL. Instead, use COM_QUERY to execute a SHOW COLUMNS statement.

Payload

Type	Name	Description
int<1>	command	0x04: COM_FIELD_LIST
string<NUL>	table	the name of the table to return column information for (in the current database for the connection)
string<EOF>	wildcard	field wildcard

Returns

COM_FIELD_LIST Response

See also

mysql_list_fields, mysqld_list_fields

COM_FIELD_LIST Response

The response to COM_FIELD_LIST can be one of:

• ERR_Packet
• zero or more Column Definition
• a closing EOF_Packet

Warning

if CLIENT_OPTIONAL_RESULTSET_METADATA is on and the server side variable Sys_resultset_metadata is not set to RESULTSET_METADATA_FULL no rows will be sent, just an empty resultset.

31 00 00 01 03 64 65 66    04 74 65 73 74 09 66 69    1....def.test.fi
65 6c 64 6c 69 73 74 09    66 69 65 6c 64 6c 69 73    eldlist.fieldlis
74 02 69 64 02 69 64 0c    3f 00 0b 00 00 00 03 00    t.id.id.?.......
00 00 00 00 fb 05 00 00    02 fe 00 00 02 00          ..............

See also

mysql_list_fields, mysqld_list_fields, THD::send_result_metadata, dispatch_command, cli_list_fields