Image
EAN-139780790782768   EAN-13 barcode 9780790782768
Product NameThe Last Samurai (Two-Disc Special Edition)
LanguageEnglish
CategoryElectronics / Photography: A/V Media: Movie / TV
Short DescriptionWeight:0.01 pounds
Amazon.comA Buy on Amazon ~ B0001JXOVC
SKU085392838325
Price New4.50 US Dollars    (curriencies)
Price Used0.49 US Dollars    (curriencies)
RatingR - Restricted
IMDbIMDb Link
Run Time154 minutes
CastBilly Connolly, Ken Watanabe, Timothy Spall, Tom Cruise, Tony Goldwyn
GenreDrama
Run Time154 minutes
Width5.5 inches    (convert)
Height0.5 inches    (convert)
Length7.75 inches    (convert)
Weight32 hundredths pounds    (convert)
BindingDvd
FormatMultiple Formats, Anamorphic, Closed-captioned, Color, Dolby, DTS Surround Sound, Dubbed, NTSC, Subtitled, Widescreen
Run Time154 minutes
FeaturesCondition: New, Format: DVD, Anamorphic; Closed-captioned; Color; Dolby; DTS Surround Sound; Dubbed; DVD; Subtitled; Widescreen;
Long DescriptionEpic Action Drama. Set in Japan during the 1870s, The Last Samurai tells the story of Capt. Nathan Algren (Tom Cruise), a respected American military officer hired by the Emperor of Japan to train the country's first army in the art of modern warfare. As the Emperor attempts to eradicate the ancient Imperial Samurai warriors in preparation for more Westernized and trade-friendly government policies, Algren finds himself unexpectedly impressed and influenced by his encounters with the Samurai, which places him at the center of a struggle between two eras and two worlds, with only his own sense of honor to guide him.
Similar Items9780783233536: Saving Private Ryan
9780767858465: The Patriot (Special Edition)
0883929310685: Braveheart / Gladiator (DBFE)
0883904221760: Dances With Wolves
0667068443325: Saving Private Ryan
0075596139120: Patriot
0043396057319: Patriot
0032429257048: Gladiator
0032429256430: Braveheart
0025192107702: 47 Ronin
0025192037122: Robin Hood
0024543206408: Kingdom of Heaven
0024543010890: Last of the Mohicans
0002519203712: Robin Hood
Created11-28-2012 5:54:21am
Modified05-01-2020 1:46:47am
MD5a223dd95b3838bed5399bb3d91b54209
SHA2565a2de61bb4b384803ce95dfa03b56ee69a1f6dc187abce80dfe03753154c0da1
Search Googleby EAN or by Title
Query Time0.0201280

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