Lazarus Database Tutorial/SampleListing
From Lazarus wiki
Jump to navigationJump to searchThe printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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...
