Image
EAN-139780792844044   EAN-13 barcode 9780792844044
Product NameRichard III
CategoryElectronics / Photography: A/V Media: Movie
Short DescriptionWeight:0.25 pounds
Amazon.comA Buy on Amazon ~ 0792844041
Price New42.95 US Dollars    (curriencies)
Price Used20.08 US Dollars    (curriencies)
RatingR - Restricted
IMDbIMDb Link
Run Time104 minutes
Aspect Ratio2.35:1
CastAnnette Bening, Ian McKellen, Jim Broadbent, Nigel Hawthorne, Robert Downey Jr.
DirectorRichard Loncraine
GenreDrama
Run Time104 minutes
Width5.38 inches    (convert)
Height0.6 inches    (convert)
Length7.5 inches    (convert)
Weight25 hundredths pounds    (convert)
BindingDvd
Release Year1995
FormatClosed-captioned, Color, Full Screen, Letterboxed, NTSC, Widescreen
Published02/29/2000
Run Time104 minutes
Long DescriptionShakespeare's immortal tale of ambition, lust and murderous treachery is brilliantly updated and brought to life in this riveting, 20th-century masterpiece. Boasting breathtaking performances, unforgettable imagery and two OscarÂ(r) nominations*, this astounding wartime spectacle is mesmerizing...it will rivet you and shock you (Jeffrey Lyons, 'sneak Previews ). In 1930s Britain, a savage, civil war between two royal families has just concluded. But even as the newly installed King Edward (John Wood) takes the reins of power, his ruthless, younger brother Richard (Ian McKellen) sets in motion a monstrous scheme to claim the crown for himself. Enlisting the aid of equally duplicitous allies in the court, Richard embarks on a merciless, single-minded campaign of betrayal, seduction and cold-blooded murder to achieve the goal that has obsessed him all of his tortured life: to beking...at any price. *1995: Costume Design, Art Direction
Similar Items9780767068109: Macbeth / McKellen, Dench
0733961714241: Macbeth / McKellen, Dench
0053939268324: William Shakespeare's Hamlet
9780792846154: Henry V
0013132472195: Coriolanus
0841887013338: Great Performances Macbeth
0715515047210: Essential Art House: Richard Iii
0841887010672: King Lear (Royal Shakespeare Company)
0024543233640: Titus
9780879516857: Richard Iii
View 8 more similar items
Created09-25-2012 9:06:07am
Modified06-05-2019 5:12:01pm
MD54f543794006c639dd1f0be1480429f57
SHA2569e16114a37efeaf9710f35e189bdd6f44b3660246a50e15b88db84175c34f776
Search Googleby EAN or by Title
Query Time0.0022981

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