Difference between revisions of "Lazarus Database Tutorial/SampleListing"
From Free Pascal wiki
Jump to navigationJump to searchm (scrambled (mostly outdated) email addresses for spambots) |
Jwdietrich (talk | contribs) (categorization) |
||
Line 38: | Line 38: | ||
Executing query : quit... | Executing query : quit... | ||
</pre> | </pre> | ||
+ | |||
+ | [[Category:Code]] |
Latest revision as of 19:41, 26 December 2013
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...