Question:

Help in database table structure(sql query)?

by  |  earlier

0 LIKES UnLike

my table is

CREATE TABLE hrp_poll (

hrp_id tinyind(4) NOT NULL auto_increment,

hrp_option1 tinyint(4) NOT NULL default '0',

hrp_option2 tinyint(4) NOT NULL default '0',

hrp_option3 tinyint(4) NOT NULL default '0',

hrp_total tinyint(4) NOT NULL default '0',

PRIMARY KEY (hrp_id)

) Type=MyISAM;

what is wrong with this table

Mysql gives erer in that

the erer is

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyind(4) NOT NULL auto_increment,

hrp_option1 tinyint(4) NOT

plz help me in corecting this

 Tags:

   Report

2 ANSWERS


  1. You misspelled tinyint.


  2. lol. Good eye

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.