Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 1.2Mb


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
Sign Up Login You must be logged in to post a comment.