Net::Wire10 1.08

Net::Wire10 is a Pure Perl connector that talks to Sphinx, MySQL and Drizzle servers.<br /><br />Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned servers without using an external client library such as for example libmysqlclient or libdrizzle.<br /><br />SYNOPSIS<br /><br /> use Net::Wire10;<br /><br /> my $wire = Net::Wire10->new(<br /> host => 'localhost',<br /> user => 'test',<br /> password => 'test',<br /> database => 'test'<br /> );<br /><br /> $wire->connect;<br /><br /> # CREATE TABLE example<br /> $wire->query(<br /> "CREATE TABLE foo (id INT, message TEXT)"<br /> );<br /><br /> # INSERT example<br /> $wire->query(<br /> "INSERT INTO foo (id, message) VALUES (1, 'Hello World')"<br /> );<br /> printf "Affected rows: %d\n", $wire->get_no_of_affected_rows;<br /><br /> # SELECT example<br /> my $results = $wire->query("SELECT * FROM foo");<br /> while (my $row = $results->next_hash) {<br /> printf<br /> "Id: %s, Message: %s\n",<br /> $row->{id},<br /> $row->{message}<br /> ;<br /> }<br /><br /> $wire->disconnect;

Requirements:	No special requirements
Platforms:	*nix, Linux
Keyword:	039hello,  Insert,  Message,  Mysql,  Net,  Net Wire,  Netwire,  Printf,  Protocol,  Quotaffected,  Quotcreate,  Quotinsert,  Squot,  Table,  Test,  Textquot,  Values,  Wire,  Wiregtget Affected Rows,  Wiregtquery,  World Quot
Users rating:	0/10