Image
EAN-139780870215247   EAN-13 barcode 9780870215247
Product NameAmerican Battleships, 1886-1923: Predreadnought Design and Construction
LanguageEnglish
CategoryBook / Magazine / Publication
Short DescriptionHardcover
Amazon.comA Buy on Amazon ~ 0870215248
Price New124.58 US Dollars    (curriencies)
Price Used64.80 US Dollars    (curriencies)
AuthorJohn C. Reilly Jr., Robert L. Scheina
Page Count259
BindingHardcover
Published11/01/1980
Long DescriptionFirst edition. Naval Institute Press. 1980.Illustrated in Black and White Photo`s.Fold outs perfect.
Similar Items9781557504111: U.S. Battleship Operations In World War I
9781906509491: The Imperial Russian Navy
9781782003861: Us Navy Dreadnoughts 1914-45 (New Vanguard)
9781591143253: German Capital Ships Of The Second World War
9780870210044: The Old Steam Navy: Frigates, Sloops and Gunboats, 1815-1885
9781840675306: Battlecruisers (Shipshape)
9781840675344: Birth Of The Battleship: British Capital Ship Design 1870-1881
9780760315576: "Old Hoodoo" The Battleship Texas: America's First Battleship 1895-1911
9781466248946: "Old Hoodoo" The Battleship Texas: America's First Battleship 1895-1911
9781146663823: "Old Hoodoo" The Battleship Texas: America's First Battleship 1895-1911
9781591141914: German Battlecruisers Of World War One: Their Design, Construction And Operations
9780870217142: U.S. Armored Cruisers: A Design and Operational History
9780870210990: Battleships: United States Battleships In World War Ii
9781557502131: Birth Of The Battleship: British Capital Ship Design 1870-1881
9780870212482: The American Steel Navy: A Photographic History Of The U.S. Navy From The Introduction Of The Steel Hull In 1883 To The Cruise Of The Great White Fleet, 1907-1909
Created07-11-2012 1:05:00am
Modified05-24-2017 3:22:17am
MD5d860d8c88e3df660ec277fad99ad42da
SHA2560d0365a768a92b3b81dbcf05062121d2f09dcc4a3c2ecb0981322a6f10247289
Search Googleby EAN or by Title
Query Time0.0509601

Article of interest

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