help to create a database with wamp server

[amareshrajaratnam]

crse_id e.g : IT000(varchar 5)
crse_name e.g: Certificate in Web Development (varchar 50)
start_date e.g: 16.sep.2011 date(dd.mm.yyyy)
crse_fee e.g: Rs.12000(int 5)
crse_duration e.g: 36 hrs (varchar 5)
crse_modules e.g: PHP, MySQL(varchar 100)

have to create a database same like this. i went through PHPMyAdmin and couldn’t understand to make a database for this… Please help me to solve this!?

[sergo_bero]

run this query , hope this helps

CREATE DATABASE `New` ;

CREATE TABLE `New`.`table` (
`crse_id` VARCHAR( 5 ) NOT NULL ,
`crse_name` VARCHAR( 50 ) NOT NULL ,
`start_date` DATE NOT NULL ,
`crse_fee` INT( 5 ) NOT NULL ,
`crse_duration` VARCHAR( 5 ) NOT NULL ,
`crse_modules` VARCHAR( 100 ) NOT NULL
) ENGINE = InnoDB;