how to use float datatype in mysql?

Ads
 

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.

Ads









Related Tutorials/Questions & Answers:
how to use float datatype in mysql? - SQL
Why not use Double or Float to represent currency?
Advertisements
PHP MySQLi
PHP MySQLi Affected Rows
PHP MySQLI Prep Statement
How to Store Float Value into Access Database - Java Beginners
How to clear a float buffer in java.
How to allocate a float buffer in java.
How to rewind float buffer in java.
Datatype convertion
PHP MySQLi Query
Transfer the content of a float array into float buffer.
Transfer the content of a float buffer into float array.
How to use Servlet and Ajax?
Compare a float buffer with another float buffer.
Java Datatype
how to use calender in php
Define float in Java
How to use AT Commands with J2ME?
Boolean DataType
how to use mouse pressed
how to use button in array
How to Use Collections
how to use setAttribute
How to use dojoscript with jsf?
Write a float value into float buffer at given index.
how to use JOptionPane.YES_NO_OPTION
how to use an editable combobox
Java Datatype
How to use ajax in jsp?
Conversion from int to float

Ads