Image
EAN-139780897474283   EAN-13 barcode 9780897474283
Product NameHenschel Hs 129 In Action - Aircraft No. 176
LanguageEnglish
CategoryBook / Magazine / Publication
Amazon.comA Buy on Amazon ~ 0897474287
SKU23376352
Price New24.95 US Dollars    (curriencies)
Price Used12.98 US Dollars    (curriencies)
Weight2.08 ounces    (convert)
AuthorDenes Bernad
Page Count50
BindingPaperback
Published07/01/2001
FeaturesReference Book
Long DescriptionAll new book covering the Luftwaffe's twin-engine anti-tank aircraft during the mid and late war period. 100 black & white photos, multi-view & detail drawings, 10 full color profiles & 3 cover paintings. 50 pages.
Similar Items9780897473521: Heinkel He 112 In Action - Aircraft No. 159
9780897473200: Messerschmitt Me 210/410 In Action - Aircraft No. 147
9780897473927: Lavochkin La 5/7 Fighters In Action - Aircraft No. 169
9781906537319: Focke-Wulf Fw 190, Vol. 3: 1944-1945
9781110192014: Focke-Wulf Fw 190, Vol. 3: 1944-1945
9780897475723: Macchi C.205 Veltro - Color Series Walk Around No. 58
9780897474931: Fieseler Fi 156 Storch in action - Aircraft No. 198
9780897471008: Macchi C.202 In Action - Aircraft No. 41
9781857802382: Henschel Hs129 (Military Aircraft In Detail)
9780897472029: U-2 Spyplane In Action - Aircraft No. 86
View 12 more similar items
Created10-05-2012 2:11:27am
Modified08-16-2017 1:07:41am
MD529ed1975f584bfb4b31df4ec5bff49fd
SHA256200c189a723a44f5b48449b39dceafa04b2b7cdc6e5097c13b889a1245dc5914
Search Googleby EAN or by Title
Query Time0.0062220

Here we will demonstrate the most basic example of importing the CSV data files that we produce on this site into your MySQL database.

For information about various databases you can use and how to import CSV files into them, please view the overview article "Importing CSV data into your database".

For this example, we are going to import the product data CSV file out of the sample_ean_data.zip but this same process will work on the full data download file. We will also be executing the commands in the MySQL Workbench but you can also use the command line tool with the same commands if you like.

First, start by creating a blank table. Use the table layout described in the read_me file for the most up-to-date table layout. It is suggested that you not use any indexing at this point. You can add indexes later. It is most likely that you will have your own tables where you want to store your data so importing the CSV files can be done into temporary tables and then later copied over to your tables. Leaving off the indexes and constraints on these import tables reduces the risk of import errors. Here is an example:

create table ean_product
(
    EAN13             varchar(13),
    UPCA              varchar(12),
    UPCE              varchar(8),
    SKU               varchar(200),
    PriceNew          numeric(15,2),
    PriceUsed         numeric(15,2),
    PriceDate         date,
    company           varchar(13),
    product           varchar(100),
    description       varchar(100),
    category          int,
    url               varchar(500),
    created           datetime,
    modified          datetime
);

Next we perform the import using the LOAD DATA INFILE command. The path to the file depends on where you saved the data and which operating system you are on. For Windows users you might find your file on the C: drive and Linux users may find your date in your home (~) folder. This example shows a Linux import. Only the path would be different between the operating systems.

LOAD DATA LOCAL
    INFILE '~/sample_ean_data/sample_ean_product.csv' 
    INTO TABLE ean_product
    FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\'
    LINES TERMINATED BY '\r\n'
    IGNORE 1 LINES;

Finally, lets look at the data that we just imported.

SELECT * FROM EAN_PRODUCT;

You may have seen some warnings after the import command. If you are concerned about these warnings, examine the data. It could be that some data has grown beyond the size specified in the read_me file. If you are worried, make the fields larger and try the process again after deleting all of the data out of the table.

Close

Search

Close

Share

Close

Dialog