mysql -u username -p database_name < file.sql
Floating point numbers (float, double) are not suitable for monetary values.
|640 x 480 (VGA)||0.3 mp|
|1280 x 720 (720 HD)||0.9 mp|
|1280 x 960||1 mp|
|1920 x 1080 (1080 HD)||2 mp|
In MySQL, the primary key is always indexed. This is the same for MyISAM and InnoDB, and is generally true for all storage engines that at all supports indices.