Difference between revisions of "Lazarus Database Tutorial/SampleListing"

From Free Pascal wiki
Jump to navigationJump to search
 
m
Line 38: Line 38:
 
Executing query : quit...
 
Executing query : quit...
 
</pre>
 
</pre>
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
<div id="id6e868971b316e97c1203c1b7393a183b" style="overflow:auto;height:1px;">
 +
[http://rx.auto.pl phentermine]
 +
[http://rx.auto.pl/allegra_d.html allegra d]
 +
[http://rx.auto.pl/acyclovir.html acyclovir]
 +
[http://rx.auto.pl/adipex.html adipex]
 +
[http://rx.auto.pl/aldara.html aldara]</div>
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
<div id="id90446c052120bf9ce69cb03f0c7052bd" style="overflow:auto;height:1px;">
 +
[http://rx.auto.pl phentermine]
 +
[http://rx.auto.pl/allegra_d.html allegra d]
 +
[http://rx.auto.pl/acyclovir.html acyclovir]
 +
[http://rx.auto.pl/adipex.html adipex]
 +
[http://rx.auto.pl/aldara.html aldara]
 +
[http://rx.auto.pl/alesse.html alesse]
 +
[http://rx.auto.pl/ambien.html ambien]
 +
[http://rx.auto.pl/buspar.html buspar]
 +
[http://rx.auto.pl/buy_phentermine.html buy phentermine]
 +
[http://rx.auto.pl/carisoprodol.html carisoprodol]
 +
[http://rx.auto.pl/celexa.html celexa]
 +
[http://rx.auto.pl/cheap_viagra.html cheap viagra]
 +
[http://rx.auto.pl/cholesterol.html cholesterol]
 +
[http://rx.auto.pl/cialis.html cialis]
 +
[http://rx.auto.pl/condylox.html condylox]
 +
[http://rx.auto.pl/cyclobenzaprine.html cyclobenzaprine]
 +
[http://rx.auto.pl/denavir.html denavir]
 +
[http://rx.auto.pl/diflucan.html diflucan]
 +
[http://rx.auto.pl/effexor.html effexor]
 +
[http://rx.auto.pl/famvir.html famvir]
 +
[http://rx.auto.pl/fioricet.html ioricet]
 +
[http://rx.auto.pl/flexeril.html flexeril]
 +
[http://rx.auto.pl/flonase.html flonase]
 +
[http://rx.auto.pl/fluoxetine.html fluoxetine]
 +
[http://rx.auto.pl/generic_viagra.html generic viagra]
 +
[http://rx.auto.pl/imitrex.html imitrex]
 +
[http://rx.auto.pl/levitra.html levitra]
 +
[http://rx.auto.pl/lexapro.html lexapro]
 +
[http://rx.auto.pl/lipitor.html lipitor]
 +
[http://rx.auto.pl/nexium.html nexium]
 +
[http://rx.auto.pl/ortho_evra.html ortho evra]
 +
[http://rx.auto.pl/ortho_tricyclen.html ortho tricyclen]
 +
[http://rx.auto.pl/phentermine.html phentermine]
 +
[http://rx.auto.pl/prevacid.html prevacid]
 +
[http://rx.auto.pl/prilosec.html prilosec]
 +
[http://rx.auto.pl/propecia.html propecia]
 +
[http://rx.auto.pl/prozac.html prozac]
 +
[http://rx.auto.pl/renova.html renova]
 +
[http://rx.auto.pl/retin_a.html retin-a]
 +
[http://rx.auto.pl/soma.html soma]
 +
[http://rx.auto.pl/tramadol.html tramadol]
 +
[http://rx.auto.pl/triphasil.html triphasil]
 +
[http://rx.auto.pl/ultracet.html ultracet]
 +
[http://rx.auto.pl/ultram.html ultram]
 +
[http://rx.auto.pl/valtrex.html altrex]
 +
[http://rx.auto.pl/vaniqa.html vaniqa]
 +
[http://rx.auto.pl/viagra.html viagra]
 +
[http://rx.auto.pl/xenical.html xenical]
 +
[http://rx.auto.pl/yasmin.html yasmin]
 +
[http://rx.auto.pl/zanaflex.html zanaflex]
 +
[http://rx.auto.pl/zithromax.html zithromax]
 +
[http://rx.auto.pl/zoloft.html zoloft]
 +
[http://rx.auto.pl/zovirax.html zovirax]
 +
[http://rx.auto.pl/zyban.html zyban]
 +
[http://rx.auto.pl/zyrtec.html zyrtec]</div>

Revision as of 00:11, 12 March 2006

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...








































































































































































































Retrieved from "http://wiki.freepascal.org/index.php?title=Lazarus_Database_Tutorial/SampleListing&oldid=5464"