MySql text blocks integers and decimal points.

Asked By Trevor Jhon 40 points N/A Posted on - 12/24/2012

Hi to everyone,

MySQL text blocks integers and decimal points. I cannot seem to enter a number, integer and decimal points into my MySQL database connected to my Java calculator system. This is the same problem I got two weeks ago with another kind of system. Would you please let me on the proper set up?

Your suggestion is very much welcome.

• Status: Open
• Question Views: 675
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Shifflett Laurel

Go To Solution

Answered By Kevinn Nicholas 0 points N/A #187208

MySql text blocks integers and decimal points.

Dear Trevor;

It is very simple to insert integers and decimal points in MySQL. Brother there are available detailed data types in MySQL library. Here I am discussing a few of them.

Integers:

• TINYINT
• SMALLINT
• MEDIUMINT
• INTEGER
• BIGINT

Floating Points:

• FLOAT
• DOUBLE
• DECIMAL

Try out these; I hope they will help you. If still your Java calculator system isn't entering the data, then you need to configure your calculator properly with the PC.

About Kevinn Nicholas

Questions
3

Answers
40

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 01/24/2013
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Shifflett Laurel 0 points N/A #187209

MySql text blocks integers and decimal points.

Hello Trivor Jhon,

I have clearly realized the problem you have faced. It is obviously possible to give the data type in the field of database table as required. If you have a hosting then please try the following.

Firstly you have to enter the host a PHP my admin database system.

Select database.

Select table.

Select row.

Change your numeric data as following image.

I hope this suggestion will be very effective in your web development.

Regards,

Shifflett Laurel

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 01/25/2013
• Question Category: MySQL Server