Difference between revisions of "Lazarus Database Tutorial/SampleListing"
From Lazarus wiki
Jump to navigationJump to searchJwdietrich (talk | contribs) (categorization) |
|||
| (3 intermediate revisions by 3 users not shown) | |||
| Line 18: | Line 18: | ||
Number of records returned : 8 | Number of records returned : 8 | ||
Number of fields per record : 3 | Number of fields per record : 3 | ||
| − | (Id: 1, Name: Michael Van Canneyt, Email : Michael | + | (Id: 1, Name: Michael Van Canneyt, Email : Michael...tfdec1.fys.kuleuven.ac.be) |
| − | (Id: 2, Name: Florian Klaempfl, Email : ba2395 | + | (Id: 2, Name: Florian Klaempfl, Email : ba2395...fen.baynet.de) |
| − | (Id: 3, Name: Carl-Eric Codere, Email : codc01 | + | (Id: 3, Name: Carl-Eric Codere, Email : codc01...gel.usherb.ca) |
| − | (Id: 4, Name: Daniel Mantione, Email : d.s.p.mantione | + | (Id: 4, Name: Daniel Mantione, Email : d.s.p.mantione...twi.tudelft.nl) |
| − | (Id: 5, Name: Pierre Muller, Email : muller | + | (Id: 5, Name: Pierre Muller, Email : muller...europe.u-strasbg.fr) |
| − | (Id: 6, Name: Jonas Maebe, Email : jmaebe | + | (Id: 6, Name: Jonas Maebe, Email : jmaebe...mail.dma.be) |
| − | (Id: 7, Name: Peter Vreman, Email : pfv | + | (Id: 7, Name: Peter Vreman, Email : pfv...worldonline.nl) |
| − | (Id: 8, Name: Gerry Dubois, Email : gerry | + | (Id: 8, Name: Gerry Dubois, Email : gerry...webworks.ml.org) |
Enter SQL Query: select id, username from FPdev where id<6 | Enter SQL Query: select id, username from FPdev where id<6 | ||
Executing query : select id, username from FPdev where id<6... | Executing query : select id, username from FPdev where id<6... | ||
| 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...
