What are the datatypes used in MYSQL?

-

 Some of the datatypes used in SQL are listed below:

Numeric Data Types:

  1. TINYINT:

    • Size: 1 byte
    • Range: -128 to 127

  2. SMALLINT:

    • Size: 2 bytes
    • Range: -32,768 to 32,767

  3. INTEGER or INT:

    • Size: 4 bytes
    • Range: -2,147,483,648 to 2,147,483,647

  1. MEDIUM INT:

    • Size: 8 bytes
    • Range: -8388608 to 8388607

  2. BIG INT:

  3. Size: 8 bytes

  4. Range: -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

  1. DECIMAL or NUMERIC:

    • Precision: Up to 65 digits
    • Scale: Up to 30 digits

  2. FLOAT:

    • Size: 4 bytes
    • Precision: 7 digits

  3. REAL:

    • Size: 4 bytes
    • Precision: 7 digits

  4. DOUBLE or DOUBLE PRECISION:

    • Size: 8 bytes
    • Precision: 15 digits

Character String Data Types:

  1. CHAR(n):

    • Size: Fixed length of n characters.

  2. VARCHAR(n):

    • Size: Variable length up to n characters.
    • Range: 1 to 65,535 bytes.

  3. TEXT:

  • Size: Variable length.
  • Range: 1 to 65,535 bytes.

Date and Time Data Types:

  1. DATE:

    • Size: 3 bytes

  2. TIME:

    • Size: 3 bytes

  3. DATETIME:

    • Size: 8 bytes

  4. TIMESTAMP:

    • Size: 4 bytes

Boolean Data Type:

  1. BOOLEAN or BOOL:
    • Values: TRUE, FALSE, or NULL

Binary Data Types:

  1. BINARY(n):

    • Size: Fixed length of n bytes.

  2. VARBINARY(n):

    • Size: Variable length up to n bytes.
    • Range: 1 to 65,535 bytes.

  3. BLOB:

    • Size: Variable length.
    • Range: 1 to 65,535 bytes.

Miscellaneous Data Types:

  1. ENUM:

    • Size: 1 or 2 bytes, depending on the number of enumeration values.

  2. SET:

    • Size: 1, 2, 3, 4, or 8 bytes, depending on the number of set members.

  3. JSON:

    • Size: Variable length.
Previous
Next

Comments

Post a Comment

Popular posts from this blog

Python program to sum up the Salary when the Name and Age matches with subsequent rows.

-
I have a .txt file as per below content with 4 fields as Name, Age, Salary and Date of Salary received Vijay,35,6000,29-12-2023 Manoj,32,12000,29-7-2023 Vinoth,31,11000,29-12-2023 Vijay,32,10000,29-10-2023 Vijay,32,7000,29-12-2023 Manoj,30,10000,29-11-2023 Vinoth,32,10000,29-10-2023 Vijay,32,10000,29-4-2023 Mano,32,1000,29-12-2023 Vijay,32,3000,29-8-2023 I wish to write a python program to sum up the Salary when the Name and Age matches with subsequent rows. Will you able to do the code ? Certainly! You can achieve this by reading the contents of the file, parsing each line to extract the relevant information (Name, Age, Salary), and then using a dictionary to store the sum of salaries for each unique combination of Name and Age. Here's a Python program that accomplishes this: def read_file(file_path): data = [] with open(file_path, 'r') as file: for line in file: line = line.strip() if line: name, age, salary, _ = l...
Read more

Automation using selenium and python/java interview question to order a product in e commerce website.

-
Image
 1. Open the browser  2.  Go to the address bar and type  "https://www.flipkart.com/"          3. Select the search bar and enter "poco c65 mobiles" 4. Select the desired mobile by clicking on it. 5. Click on add to cart button. 6. Click  the place order button. 7.Enter mobile number and click continue. 8.Enter the OTP and click sign up. 9. After entering multiple wrong OTP the  system throws an error All the above steps should be automated.
Read more