Image
EAN-130013388330195   EAN-13 barcode 0013388330195
UPC-A013388330195   UPC-A barcode 013388330195
Product NameLost Planet 2 - Xbox 360
CategoryElectronics / Photography: A/V Media: Video Game
Amazon.comA Buy on Amazon ~ B002DC8GEK
Model33019
Price New28.20 US Dollars    (curriencies)
Price Used0.99 US Dollars    (curriencies)
Genrefantasy_action_games
Width5.32 inches    (convert)
Height0.14 inches    (convert)
Length7.52 inches    (convert)
Weight27 hundredths pounds    (convert)
BindingVideo Game
Published04/30/2010
Features
  • Massive environments brought to life by an advanced game engine, a truly huge scale of enemies and a rewards system which rewards players for assisting teammates and contributing to the team's success against them.
  • An unbelievable variety of Vital Suits and new ways to use them. The new VS system will have a powerful impact on the way the player takes to the war zone in Lost Planet 2.
  • 4-player co-op and split-screen co-op locally allowing you to team up to battle the giant Akrid. Teamwork is the player's key to victory as team members are dependent on each other to succeed and survive.
  • Appearances by Marcus Fenix and Dominic Santiago from the Gears of War games.
  • RPG elements added to the game include character customization, experience points, evolution of the game based on players decisions and actions (single player).
Similar Items0013388330393: Lost Planet 3
0014633198119: Crysis 3 Le X360 (19811)
0047875841147: Prototype 2 - Xbox 360
0883929182862: F.E.A.R. 3
0883929127085: F.E.A.R. 3
0885370201215: Gears Of War 3
0885370429794: Gears Of War Judgment
0014633192070: Crysis 2
0013388330034: Lost Planet Extreme Conditions Colonies
0013388330027: Lost Planet Extreme Condition Xbox 360 Game
0882224054034: Gears Of War - Xbox 360
0882224386715: Gears Of War - Xbox 360
4901750412111: Unreal Tournament Iii - Xbox 360
9780307467119: Lost Planet 2: Prima Official Game Guide (Prima Official Game Guides)
Created11-19-2011 1:08:32pm
Modified09-05-2018 9:58:33pm
MD500ee19d6ee8db5358811dff75c61013a
SHA2562153351aeed2759a036bf5a1fc0e5f9a927e197f62ee57640219e61764e9140a
Search Googleby EAN or by Title
Search Amazonby EAN or by Title
Query Time0.0013509

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