Changes between Version 10 and Version 11 of Docs/Prog/Manual/ApplicationLibraries/Database/MySQLclient

Timestamp:

02/05/13 21:51:33 (13 years ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/Database/MySQLclient

@@ -101 +101 @@
 
 This example runs from the command line and if no arguments are specified assumes server at 192.168.1.106 user name "pi" password "raspberry" database named "test" and query to show all records of the database table "abc".
+
+
+{{{
+$ ./mysqltest 192.168.1.106 pi raspberry test "select * from abc;"
+**srv [192.168.1.106] user [pi] pass [raspberry] db [test] q [select * from abc;]
+***
+affected -1
+P_Id,LastName,FirstName,Address,City,
+2,Hancock,(null),(null),Chicago,
+$
+}}}
+
+{{{
+$ ./mysqltest 192.168.1.106 pi raspberry test "insert into abc (P_Id,LastName,FirstName,Address,City) values (5,'ZZZZZ','ABCD','123 Oak st','Somewhere');"
+**srv [192.168.1.106] user [pi] pass [raspberry] db [test] q [insert into abc (P_Id,LastName,FirstName,Address,City) values (5,'ZZZZZ','ABCD','123 Oak st','Somewhere');]
+***
+affected 1
+$  $ ./mysqltest 192.168.1.106 pi raspberry test "select * from abc;"
+**srv [192.168.1.106] user [pi] pass [raspberry] db [test] q [select * from abc;]
+***
+affected -1
+P_Id,LastName,FirstName,Address,City,
+2,Hancock,(null),(null),Chicago,
+5,ZZZZZ,ABCD,123 Oak st,Somewhere,
+$
+
+}}}