mysql_client

 $ 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<erl_eval.6.82930912>
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)