$ erl < ../priv/cmd.txt Eshell V5.9.1 (abort with ^G) 1> /home/alexei/eclipse/data/workspace-CPP/erl.mysql.client/ebin ok 2> true 3> ok 4> [client_options,connection,datasource,eof_packet, error_packet,field_metadata,metadata,mysql_decimal, mysql_error,mysql_time,ok_packet,ok_stmt_packet,packet, rs_header,server_info,server_status] 5> #datasource{name = undefined,host = "localhost",port = 3306, database = [],user = "root",password = "root", flags = #client_options{charset_number = 33, long_password = 1,found_rows = 0, long_flag = 1,connect_with_db = 1, no_schema = 0,compress = 0,odbc = 0, local_files = 0,ignore_space = 0, protocol_41 = 1,interactive = 1,ssl = 0, ignore_sigpipe = 0,transactions = 1, reserved = 0,secure_connection = 1, multi_statements = 1,multi_results = 1, trans_isolation_level = default}} 6> {ok,<0.47.0>} 7> <0.49.0> 8> #connection{ socket = #Port<0.787>,owner = <0.30.0>, ds_def = #datasource{ name = data_source,host = "localhost",port = 3306, database = [],user = "root",password = "root", flags = #client_options{ charset_number = 33,long_password = 1,found_rows = 0, long_flag = 1,connect_with_db = 1,no_schema = 0, compress = 0,odbc = 0,local_files = 0,ignore_space = 0, protocol_41 = 1,interactive = 1,ssl = 0, ignore_sigpipe = 0,transactions = 1,reserved = 0,...}}, server_info = #server_info{ protocol_version = 10,server_version = "5.1.60", thread_Id = 98, server_capabilities = #client_options{ charset_number = 8,long_password = 1,found_rows = 1, long_flag = 1,connect_with_db = 1,no_schema = 1, compress = 1,odbc = 1,local_files = 1,ignore_space = 1, protocol_41 = 1,interactive = 1,ssl = 0, ignore_sigpipe = 1,transactions = 1,reserved = 0, secure_connection = 1,multi_statements = 0,...}, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, scramble_buff = <<"Q`o.3T0/=$;;W&UYAy\\C">>}} 9> {#metadata{ field_count = 0,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [],param_metadata = []}, [#ok_packet{ affected_rows = 1,insert_id = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, warning_count = 0,message = []}]} 10> {#metadata{ field_count = 0,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [],param_metadata = []}, [#ok_packet{ affected_rows = 0,insert_id = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, warning_count = 0,message = []}]} 11> {#metadata{ field_count = 0,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [],param_metadata = []}, [#ok_packet{ affected_rows = 2,insert_id = 1, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, warning_count = 0, message = "&Records: 2 Duplicates: 0 Warnings: 0"}]} 12> {#metadata{ field_count = 4,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = true,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [#field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "id",origname = "id", charsetnr = 63,length = 20,type = 8, flags = <<3,66>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "name",origname = "name", charsetnr = 33,length = 135,type = 253, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "age",origname = "age", charsetnr = 63,length = 10,type = 3, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "longtext_col", origname = "longtext_col",charsetnr = 33, length = 4294967295,type = 252, flags = <<16,0>>, scale = 0,default = []}], param_metadata = []}, [[1,"Alex",21,null],[2,"John",21,null]]} 13> {#metadata{ field_count = 4,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = true,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [#field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "id",origname = "id", charsetnr = 63,length = 20,type = 8, flags = <<3,66>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "name",origname = "name", charsetnr = 33,length = 135,type = 253, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "age",origname = "age", charsetnr = 63,length = 10,type = 3, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "longtext_col", origname = "longtext_col",charsetnr = 33, length = 4294967295,type = 252, flags = <<16,0>>, scale = 0,default = []}], param_metadata = []}, [[1,"Alex",21,null],[2,"John",21,null]]} 14> [[1,"Alex",21,null],[2,"John",21,null]] 15> [[1,"Alex",21,null],[2,"John",21,null]] 16> [2,"John",21,null] 17> [2,"John",21,null] 18> "John" 19> {#metadata{ field_count = 4,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = true,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [#field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "id",origname = "id", charsetnr = 63,length = 20,type = 8, flags = <<3,66>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "name",origname = "name", charsetnr = 33,length = 135,type = 253, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "age",origname = "age", charsetnr = 63,length = 10,type = 3, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "longtext_col", origname = "longtext_col",charsetnr = 33, length = 4294967295,type = 252, flags = <<16,0>>, scale = 0,default = []}], param_metadata = []}, [[1,"Alex",21,null],[2,"John",21,null]]} 20> <0.66.0> 21> true 22> true 23> "Alex" 24> 21 25> true 26> "John" 27> ["Alex","John"] 28> 1 29> {#metadata{ field_count = 4,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [#field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "id",origname = "id", charsetnr = 63,length = 20,type = 8, flags = <<3,66>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "name",origname = "name", charsetnr = 33,length = 135,type = 253, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "age",origname = "age", charsetnr = 63,length = 10,type = 3, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "longtext_col", origname = "longtext_col",charsetnr = 33, length = 4294967295,type = 252, flags = <<16,0>>, scale = 0,default = []}], param_metadata = []}, [[1,"Alex",21,null]]} 30> [1,"Alex",21,null] 31> 2 32> 8 33> 1 34> {#metadata{ field_count = 4,param_count = 0,server_status = undefined, field_metadata = [#field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "id",origname = "id", charsetnr = 63,length = 20,type = 8, flags = <<1,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "name",origname = "name", charsetnr = 33,length = 135,type = 253, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "age",origname = "age", charsetnr = 63,length = 10,type = 3, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "longtext_col", origname = "longtext_col",charsetnr = 33, length = 4294967295,type = 252, flags = <<16,0>>, scale = 0,default = []}], param_metadata = []}, []} 35> {#metadata{ field_count = 4,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = true, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [#field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "id",origname = "id", charsetnr = 63,length = 20,type = 8, flags = <<1,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "name",origname = "name", charsetnr = 33,length = 135,type = 253, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "age",origname = "age", charsetnr = 63,length = 10,type = 3, flags = <<0,0>>, scale = 0,default = []}, #field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "longtext_col", origname = "longtext_col",charsetnr = 33, length = 4294967295,type = 252, flags = <<16,0>>, scale = 0,default = []}], param_metadata = []}, [[1,"Alex",21,null],[2,"John",21,null]]} 36> #Fun 37> {#metadata{ field_count = 0,param_count = 0, server_status = #server_status{ inTransaction = true,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [],param_metadata = []}, [#ok_packet{ affected_rows = 1,insert_id = 0, server_status = #server_status{ inTransaction = true,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, warning_count = 0, message = "(Rows matched: 1 Changed: 1 Warnings: 0"}]} 38> 3 39> ok 40> 251 41> {#metadata{ field_count = 0,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [],param_metadata = []}, [#ok_packet{ affected_rows = 1,insert_id = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, warning_count = 1, message = "(Rows matched: 1 Changed: 1 Warnings: 0"}]} 42> {#metadata{ field_count = 1,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = false, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [#field_metadata{ catalog = "def",schema = "testDB",table = "sample_table", origtable = "sample_table",name = "longtext_col", origname = "longtext_col",charsetnr = 33, length = 4294967295,type = 252, flags = <<16,0>>, scale = 0,default = []}], param_metadata = []}, [[[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|...]]]} 43> ok 44> #datasource{name = undefined,host = "localhost",port = 3306, database = "testDB",user = "root",password = "root", flags = #client_options{charset_number = 33, long_password = 1,found_rows = 0, long_flag = 1,connect_with_db = 1, no_schema = 0,compress = 1,odbc = 0, local_files = 0,ignore_space = 0, protocol_41 = 1,interactive = 1,ssl = 0, ignore_sigpipe = 0,transactions = 1, reserved = 0,secure_connection = 1, multi_statements = 1,multi_results = 1, trans_isolation_level = default}} 45> {ok,<0.93.0>} 46> <0.95.0> 47> {#metadata{ field_count = 0,param_count = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = true, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, field_metadata = [],param_metadata = []}, [#ok_packet{ affected_rows = 1,insert_id = 0, server_status = #server_status{ inTransaction = false,autocommit = true, moreResultExists = false,queryNoGoodIndexUsed = false, queryNoIndexUsed = false,cursorExists = false, lastRowSent = false,dbDropped = true, noBackSlashEscapes = false,metadataChanged = false, queryWasSlow = false,psOutParams = false}, warning_count = 0,message = []}]} 48> *** Terminating erlang (nonode@nohost)