how to use float datatype in mysql?

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

QuestionAsk Questions?

chitra

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

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.

how to use float datatype in mysql? - SQL

PHP MySQLi

PHP MySQLI Prep Statement

Datatype convertion

PHP MySQLi Affected Rows

Define float in Java

How to Store Float Value into Access Database - Java Beginners

Java Datatype

div style float right

PHP MySQLi Query

Java - Identifier and primitive datatype in java

string to float

datatype - Java Beginners

Java String Datatype

Mysql Alter Column Datatype

Mysql Decimal Datatype

NSString to float conversion

Transfer the content of a float array into float buffer.

objective c define float

Transfer the content of a float buffer into float array.

Compare a float buffer with another float buffer.

Write a float value into float buffer at given index.

jdbc mysqll - JDBC

The float Keyword

Conversion from int to float

Transfer the content of a float buffer into another float buffer.

Conversion from short to float

How to clear a float buffer in java.

How to allocate a float buffer in java.

Convert String to a float

NSLog float example code

How to rewind float buffer in java.

Conversion from String to float

Data Type: bool

Conversion from float to String

Conversion from float to short

Conversion from float to long

Conversion from float to double

Conversion from float to char

Conversion from float to int

Conversion from float to byte

Conversion from byte to float

Conversion from float to boolean

Conversion from long to float

Conversion from double to float

Boolean DataType

Creates a read-only float buffer that shares the content of float buffer.

PHP Float Number Format

Creates a duplicate float buffer that shares the content of float buffer.

Java Datatype

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics