simple SQL help...please

BoB3rt · 15 Jan 2010 at 00:13

Doing coursework and on creating a table am stuck for what data type Hieght would be....

simply 'integer' or 'decimal[((precision[,scale]))]' or 'float'

any ideas?

NathanT · 15 Jan 2010 at 01:13

unsigned integer for creating a data range thats going to be a whole numeric.

smallint should be large enough

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

whitecrook · 15 Jan 2010 at 01:14

depends on the data and precision required?

BoB3rt · 15 Jan 2010 at 04:04

Ok seem to be ok with that...thanks

I have had a good route around but cant seem to find a solution for

Error Code : 1062
Duplicate entry 'P111' for key 1
(0 ms taken)

apparently it means i ave 2 entries under 1 primary key... but i dont?!
I have 'P111' (the data) as a primary for table X
and P111 is also data entered in another table (table y) but not under a primary key.

would this be the problem though... I am sorry if this is hard to understand bit of a beginner.

thanks