Handling Decimal format

[thatos]

I have the following create statement

$query = "CREATE TABLE P(
 code int(2) NOT NULL,
 value decimal(3.6) NOT NULL,
 PRIMARY KEY(code)

";

but when I look at the data field using phpadmin, value is (3.0) , and when I insert a value say "123.123456 " this number gets converted to 123.

I just want to know how to represent a decimal in an sql statement for mysql

[johny10151981]

the correct syntax is value decimal(3,6) not 3.6

[thatos]

When I do that, the table is not created, look at the code below.

$Isotope = "CREATE TABLE Isotope (
	isotope_id int(2) NOT NULL auto_increment,
	isotope_name varchar(50) NOT NULL,
	state int(1) NOT NULL,
	unit varchar(10) NOT NULL,
	min_value decimal(3,6) NOT NULL,
	max_value decimal(3,6) NOT NULL,
	PRIMARY KEY (isotope_id)
)";
$results = mysql_query($Isotope);

[johny10151981]

Please read the syntax in the documentation
Syntax for Decimal

Name DECIMAL(M,D) // M>=D