how to use float datatype in mysql?

View Answers

September 26, 2008 at 7:10 PM

hi Chitra

this code help u

CREATE TABLE `paging` (
`Id` float(10,2) NOT NULL default '0.00',
`name` varchar(255) default NULL,
PRIMARY KEY (`Id`)
) TYPE=MyISAM;


Rajanikant

September 27, 2008 at 1:07 PM

Hi chitra,



CREATE TABLE `Student` (
`Id` float(11,2) NOT NULL default '0.00',
`name` varchar(255) default NULL,
PRIMARY KEY (`Id`)
) TYPE=MyISAM;

-----------------------

insert code,


INSERT INTO paging
(Id, name)VALUES(10.0, "amar");


----------------------------

Visit for more information.

http://www.roseindia.net/jdbc/

Thanks.

Amardeep.









Related Tutorials/Questions & Answers:
Advertisements

Questions by Category