What are the Two data types in MySQL?

In MySQL, there are four different TEXT data types: MEDIUM TEXT LONG TEXT.

MySQL Database Management System > MySQL Data Types

MySQL - Numeric Datatypes

17.9k

Start a new search

To find content from modules and lessons

Suggested Topic: Latest Top

Topic		Like	Replies	Views	Activity
Loading...

All standard SQL numeric data types are supported by MySQL. These kinds contain exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as approximate numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC) ( FLOAT , REAL , and DOUBLE PRECISION ).

Numbers are stored in database columns as numeric data types. Exact numeric types, values where precision and scale must be retained are examples of these data types. INTEGER, BIGINT, DECIMAL, NUMERIC, NUMBER, and MONEY are the exact numeric kinds.

MySQL includes all of the necessary SQL numeric data types. These data types can be exact numeric data types (for example, integer, decimal, numeric, etc.) or approximate numeric data types (for example, integer, decimal, numeric, etc). (For example, float, real, and double precision). It also has a BIT datatype that can be used to hold bit values.

In MySQL, there are four different TEXT data types:

MEDIUM TEXT
LONG TEXT.

Learner's Ratings

4.5

Overall Rating

Reviews

ROBERT PHILIP

The course is designed very well and all concepts were explained properly with examples

DURGESH LAL KAVI

4 star

Omkar kiran shinde

good teaching

Ashihrii Phimu

wonderful to learn from all the teachers. keep up the good work. Thank you

Vinod Kumar Kulkarni

Very useful session for professionals and students.

Swapnil Chilwant

learnvern doing greate job...Thank you teacher's content team.

NAVNEET MAHESWARI

EASY TO UNDERSTAND IN OUR OWN LANGUAGE

shrutika jain

Thank you so much Meet Shah Sir , It was really great and easy to understand I had clear my doubts in your study. thanks' again ...

Abhijeet Anil Waghmare

This MySQL Database course is really helps you for beginner level. Almost all the basic concepts clear in that course in very simple ways. I strongly recommend this course.

Rohan Varshney

awesome

Recommended Courses

Free हिन्दी

PHP Course For Beginners

30787

4.2 Enroll For Free

Free हिन्दी

Core Java Course

61018

4.3 Enroll For Free

Free हिन्दी

Advanced PHP with MVC Programming with Practicals

33081

4.4 Enroll For Free

Free हिन्दी

Java Programming Advance Course

67430

4.2 Enroll For Free

MySQL - Numeric Datatypes

Start a new search

What is numeric data type in MySQL?

What is the purpose of numeric data type?

What is the use of data types in MySQL?

What are the Two data types in MySQL?

Learner's Ratings

Reviews

ROBERT PHILIP

DURGESH LAL KAVI

Omkar kiran shinde

Ashihrii Phimu

Vinod Kumar Kulkarni

Swapnil Chilwant

NAVNEET MAHESWARI

shrutika jain

Abhijeet Anil Waghmare

Rohan Varshney

Recommended Courses

PHP Course For Beginners

Core Java Course

Advanced PHP with MVC Programming with Practicals

Java Programming Advance Course

Course Content

Introduction to MySQL

MySQL Environment Setup

What is Data

What is Database

What is DBMS (Database Management System)

Introduction to SQL and its Query Types

MySQL - Numeric Datatypes

MySQL Constraints

MySQL - Create, Drop and Show Database

MySQL - Create Table Statement

MySQL - Insert and Select Statement With Like Clause

MySQL - Arithmetic and Logical Operators

MySQL - IN and NOT IN Clauses

MySQL - NULL and NOT NULL Clauses

MySQL - ORDER BY and LIMIT Clauses

MySQL - AS, CONCAT, DISTINCT, GROUP BY and HAVING Clauses with Aggregate Functions

MySQL - Update and Delete Statements

MySQL - Alter Table Statement

MySQL - Rename, Truncate and DROP Statements

MySQL - Foreign Key

MySQL - Joins

MySQL - View

MySQL - Function

MySQL - Stored Procedure

MySQL - Trigger

Database Normalization

Assignment : MySQL Database Management System

MySQL Interview Question Part 1

MySQL Interview Question Part 2

MySQL Interview Question Part 3

Course Summary