Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL how to use float datatype in mysql?

Have Programming Question? Ask it here!
 
 
 


chitra
how to use float datatype in mysql?
2 Answer(s)      5 years and 10 months ago
Posted in : SQL



Advertisement
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
Advertisements
 

 

 

DMCA.com