Documentation Home
MySQL Internals Manual


MySQL Internals Manual  /  ...  /  ProtocolText::Resultset

14.12.2 ProtocolText::Resultset

A query like SELECT @@version_comment returns:

01 00 00 01 01|27 00 00    02 03 64 65 66 00 00 00    .....'....def...
11 40 40 76 65 72 73 69    6f 6e 5f 63 6f 6d 6d 65    .@@version_comme
6e 74 00 0c 08 00 1c 00    00 00 fd 00 00 1f 00 00|   nt..............
05 00 00 03 fe 00 00 02    00|1d 00 00 04 1c 4d 79    ..............My
53 51 4c 20 43 6f 6d 6d    75 6e 69 74 79 20 53 65    SQL Community Se
72 76 65 72 20 28 47 50    4c 29|05 00 00 05 fe 00    rver (GPL)......
00 02 00                                              ...
  • length = 01 00 00, sequence_id = 01

  • length = 27 00 00, sequence_id = 02

    • (Protocol::ColumnDefinition)

    • catalog = 03 64 65 66 ("def")

    • schema = 00 ("")

    • table = 00 ("")

    • org_table = 00 ("")

    • name = 11 40 40 76 65 72 73 69 6f 6e 5f 63 6f 6d 6d 65 6e 74 ("@@version_comment")

    • org_name = 00 ("")

    • filler_1 = 0c

    • character_set = 08 00 (latin1_swedish_ci)

    • column_length = 1c 00 00 00 (28)

    • column_type = fd (Protocol::MYSQL_TYPE_VAR_STRING)

    • flags = 00 00

    • decimals = 1f (127)

    • filler_2 00 00

  • length = 05 00 00, sequence_id = 03

  • length = 05 00 00, sequence_id = 04

    • (ProtocolText::ResultsetRow)

    • 1c 4d 79 53 51 4c 20 43 6f 6d 6d 75 6e 69 74 79 20 53 65 72 76 65 72 20 28 47 50 4c 29 (length = 28, string = "MySQL Community Server (GPL)")

  • length = 05 00 00, sequence_id = 05


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.