Please help with basic MySql Table

[pluto459]

Hey,

Thanks for taking the time to read this. I am trying to setup a db with the following info and I am not sure what fields or how to do it in phpmyadmin.

I have never created everythign from scratch so this is all new to me. I created the db and the went to create table and did for item but then all lost from there.

Below are the 2 steps and I would really aprreciate some help setting up.

--------------------------------------
Step 1.

Run the query below on your database to create the table required for the Cool Wall.


CREATE TABLE `coolwall` (
`item` varchar(50) NOT NULL default '',
`order` int(9) NOT NULL default '0',
`seriouslyuncool` int(9) NOT NULL default '0',
`uncool` int(9) NOT NULL default '0',
`cool` int(9) NOT NULL default '0',
`subzero` int(9) NOT NULL default '0',
`image` varchar(50) NOT NULL default '',

PRIMARY KEY (`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


Step 2.

Run the query below to populate the table with some sample data.

INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Porche', '0', '15', '8', '6', '8','porche.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Range Rover', '0', '5', '15', '6', '8','rangerover.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Lamborghini', '0', '9', '5', '12', '8','lambo.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Mercedes SLK', '0', '5', '3', '6', '8','slk.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Ferrari F430', '0', '5', '5', '6', '8','f430gt.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('BMW X5', '0', '5', '5', '22', '3','x5.jpg');


Thanks,
Kevin

 

[Eric]

Once you have created the db, login to phpMyAdmin. Once there, you should see a drop down with available databases on the left - choose the one you just made. Then, in the right frame, choose "SQL" - run the queries. That's it

 

[pluto459]

ok been there done that lol

i open the db and its blank. Usually i would import the file and be done.

What about step 1 creating allt he tables? Is that just one table for itme or each one needs a table created.

 

[Eric]

The "sample" data:

INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Porche', '0', '15', '8', '6', '8','porche.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Range Rover', '0', '5', '15', '6', '8','rangerover.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Lamborghini', '0', '9', '5', '12', '8','lambo.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Mercedes SLK', '0', '5', '3', '6', '8','slk.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('Ferrari F430', '0', '5', '5', '6', '8','f430gt.jpg');
INSERT INTO `coolwall` (`item` , `order` , `seriouslyuncool` , `uncool` , `cool` , `subzero` , `image` ) VALUES ('BMW X5', '0', '5', '5', '22', '3','x5.jpg');

Would all go into that table, so just run those like you ran the create table sql.

 

[pluto459]

think i got it
thanks