Example 6 19   Sample data of MySQL data
mysql> select * from catalog limit 1;
+            +              +      +         +         +      +      +      +      +                 
+      +       +           +      +          +            +         +    +
|manufacturer| model        | type |year_from| year_to | kw   | hp
__
 | ccm  | cyl  | motorcode       
| pg   | sku 
__
| dimension | ac   | transmiss| hint
______
 | stock
__
 | id |
+            +              +      +         +         +      +      +      +      +                 
+      +       +           +      +          +            +         +    +
| VW         | PASSAT (3B2) | 1.6  | 10.1996 | 11.2000 | 74   | 101  | 1595 | 4    | ADP/AHL/ANA/ARM 
| 10   | 16633 | 630 420   | +/   | M        | see figure |      10 |  2 |
+            +              +      +         +         +      +      +      +      +                 
+      +       +           +      +          +            +         +    +
1 row in set (0.05 sec)
db2 => select * from itsodb.catalog where manufacturer= VW  and model= PASSAT (3B2)  and type= 1.6 
MANUFACTURER
__
 MODEL                     TYPE
_____________________
 YEAR_FR YEAR_TO KW
_
 HP
_
 CCM
_
 CYL 
MOTORCODE                                                    PR SKU
_____
 DIMENSION
____
AC
_
 TRANSMIS 
HINT
________________________________________________________
 STOCK
______
 ID
                                                                                                    
                                                                                                   
                                                                                    
VW             PASSAT (3B2)              1.6                       10.1996 11.2000 74  101 1595 4   
ADP/AHL/ANA/ARM                                              10 16633    630 420      +/  M        
see figure                                                            10           2
  1 record(s) selected.
 Chapter 6. Data porting 
153






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved