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
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.
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
Ads