how to use float datatype in mysql?

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.









Related Tutorials/Questions & Answers:
how to use float datatype in mysql? - SQL
ModuleNotFoundError: No module named 'mysqlx-connector'
Advertisements
PHP MySQLi
PHP MySQLi Affected Rows
Hibernate 5 MySQL5 Dialect
Hibernate 5 MySQL5 Dialect
Hibernate 5 MySQL5 Dialect
PHP MySQLI Prep Statement
How to Store Float Value into Access Database - Java Beginners
Why not use Double or Float to represent currency?
PHP MySQLi Query
Datatype convertion
how to print float with 2 decimals python
How to clear a float buffer in java.
Maven dependency for com.bedatadriven - jackson-datatype-jts version 2.2 is released. Learn to use jackson-datatype-jts version 2.2 in Maven based Java projects
Maven dependency for com.bedatadriven - jackson-datatype-jts version 2.0 is released. Learn to use jackson-datatype-jts version 2.0 in Maven based Java projects
Maven dependency for com.bedatadriven - jackson-datatype-jts version 2.4 is released. Learn to use jackson-datatype-jts version 2.4 in Maven based Java projects
Maven dependency for com.bedatadriven - jackson-datatype-jts version 2.3 is released. Learn to use jackson-datatype-jts version 2.3 in Maven based Java projects
Maven dependency for com.github.joschi.jackson - jackson-datatype-threetenbp version 2.12.0 is released. Learn to use jackson-datatype-threetenbp version 2.12.0 in Maven based Java projects
Maven dependency for com.github.joschi.jackson - jackson-datatype-threetenbp version 2.11.4 is released. Learn to use jackson-datatype-threetenbp version 2.11.4 in Maven based Java projects
Maven dependency for com.github.joschi.jackson - jackson-datatype-threetenbp version 2.13.0-rc2 is released. Learn to use jackson-datatype-threetenbp version 2.13.0-rc2 in Maven based Java projects
Maven dependency for com.github.joschi.jackson - jackson-datatype-threetenbp version 2.12.5 is released. Learn to use jackson-datatype-threetenbp version 2.12.5 in Maven based Java projects
Maven dependency for com.github.joschi.jackson - jackson-datatype-threetenbp version 2.12.2 is released. Learn to use jackson-datatype-threetenbp version 2.12.2 in Maven based Java projects
Maven dependency for com.github.joschi.jackson - jackson-datatype-threetenbp version 2.12.1 is released. Learn to use jackson-datatype-threetenbp version 2.12.1 in Maven based Java projects
How to allocate a float buffer in java.
How to rewind float buffer in java.
Transfer the content of a float array into float buffer.
Transfer the content of a float buffer into float array.
Java Datatype
Boolean DataType
Define float in Java
ModuleNotFoundError: No module named 'datatype'
ModuleNotFoundError: No module named 'datatype'
Compare a float buffer with another float buffer.
string to float
Java Datatype
Write a float value into float buffer at given index.
Conversion from int to float
Conversion from short to float
ModuleNotFoundError: No module named 'datatype-tools'
ModuleNotFoundError: No module named 'datatype-tools'
Transfer the content of a float buffer into another float buffer.
Convert String to a float
div style float right
ModuleNotFoundError: No module named 'float'
ModuleNotFoundError: No module named 'float'
ModuleNotFoundError: No module named 'float'
NSString to float conversion
Conversion from String to float
Conversion from float to int

Ads