Disable All Advertising
Image
EAN-130025192162664   EAN-13 barcode 0025192162664
UPC-A025192162664   UPC-A barcode 025192162664
Product NameDefinitely, Maybe / Because I Said So / Love Actually / Notting Hill Four Feature Films
CategoryElectronics / Photography: A/V Media: Movie / TV
Amazon.comA Buy on Amazon ~ B008R65Y3C
Price New6.95 US Dollars    (curriencies)
Price Used2.13 US Dollars    (curriencies)
RatingR - Restricted
IMDbNot on IMDb
Run Time473 minutes
Aspect Ratio1.85:1
CastDiane Keaton, Hugh Grant, Julia Roberts, Mandy Moore, Ryan Reynolds
GenreRomance
Run Time473 minutes
Width5.25 inches    (convert)
Height0.5 inches    (convert)
Length7.5 inches    (convert)
Weight25 hundredths pounds    (convert)
BindingDvd
FormatMultiple Formats, Box set, Color, NTSC, Widescreen
Run Time473 minutes
Long DescriptionDefinitely, Maybe When Will (Ryan Reynolds) decides to tell his daughter (Abigail Breslin) the story of how he met her mother, he discovers that a second look at the past might also give him a second chance at the future.   Because I Said So Academy Award-winning actress Diane Keaton stars with Mandy Moore, Lauren Graham and Piper Perabo in this heartwarming comedy about mothers, daughters and cutting the apron strings.   Love Actually An all-star cast including Hugh Grant, Keira Knightly, Liam Neeson, Colin Firth and Emma Thompson will take you on a breathtaking tour of love’s delightful twists and turns.   Notting Hill When the world’s most famous movie star (Julia Roberts) falls for a bookstore owner (Hugh Grant), the couple comes to face the ultimate question: can two people fall in love with the whole world watching?
Similar Items0883929183135: 4 Film Favorites Nicholas Sparks
0883929145058: 4 Film Favorites Sandra Bullock
0883929109005: 4 Film Favorites Romantic Comedies
0883904320944: Moonstruck / When Harry Met Sally / The Princess Bride / Rain Man Quad Feature
0786936797770: The Proposal
0031398135234: Kate & Leopold / Serendipity
0025192396397: It's Complicated / Mamma Mia! The Movie / One True Thing / Prime 4-Movie Collection
0025192137938: 4 Movie Marathon Romantic Comedy Collection
0025192048340: Movie Marathon Collection Romantic Favorites
0024543990888: This Means War / 27 Dresses / What's Your Number / Bride Wars Quad Feature
Created10-13-2016 10:57:33pm
Modified06-01-2019 5:01:39am
MD5b14c7a719e19809b03de3c8e8d4a784f
SHA2561a0464fc50d29cfbe2dda0f632209e9347f3fb1157b48a41bf27f3db4c31da68
Search Googleby EAN or by Title
Query Time0.0281439

An article of interest

Making use of the tools we offer

Importing our data into your MySQL database

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.