Lazarus Database Tutorial/SampleListing

From Lazarus wiki
Revision as of 13:39, 19 March 2005 by Vincent (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search
kirkpatc@anglican:~/FreePascal/fpc/packages/base/mysql> ./trydb
 
Enter Hostname: localhost
Enter Username: kirkpatc
Enter Password: ****
Allocating Space...
Connecting to MySQL...Done.
Connection data:
Mysql_port      : 3306
Mysql_unix_port : /var/lib/mysql/mysql.sock
Host info       : Localhost via UNIX socket
Server info     : Uptime: 11505  Threads: 1  Questions: 11  Slow queries: 0  Opens: 7   Flush tables: 1  Open tables: 1  Queries per second avg: 0.001
Client info     : 4.0.15
Selecting Database testdb...
Enter SQL Query: select * from FPdev
Executing query : select * from FPdev...
Number of records returned  : 8
Number of fields per record : 3
(Id: 1, Name: Michael Van Canneyt, Email : Michael@tfdec1.fys.kuleuven.ac.be)
(Id: 2, Name: Florian Klaempfl, Email : ba2395@fen.baynet.de)
(Id: 3, Name: Carl-Eric Codere, Email : codc01@gel.usherb.ca)
(Id: 4, Name: Daniel Mantione, Email : d.s.p.mantione@twi.tudelft.nl)
(Id: 5, Name: Pierre Muller, Email : muller@europe.u-strasbg.fr)
(Id: 6, Name: Jonas Maebe, Email : jmaebe@mail.dma.be)
(Id: 7, Name: Peter Vreman, Email : pfv@worldonline.nl)
(Id: 8, Name: Gerry Dubois, Email : gerry@webworks.ml.org)
Enter SQL Query: select id, username from FPdev where id<6
Executing query : select id, username from FPdev where id<6...
Number of records returned  : 5
Number of fields per record : 2
(Id: 1, Name: Michael Van Canneyt, Email : )
(Id: 2, Name: Florian Klaempfl, Email : )
(Id: 3, Name: Carl-Eric Codere, Email : )
(Id: 4, Name: Daniel Mantione, Email : )
(Id: 5, Name: Pierre Muller, Email : )
Enter SQL Query: quit
Executing query : quit...