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



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

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


chitra
how to use float datatype in mysql?
2 Answer(s)      6 years 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
 

 

 

DMCA.com