MySQL - FLOAT

To create a column of Float datatype through a JavaScript program, we need to execute the "CREATE TABLE" statement using the query() function of mysql2 library as follows −

sql = "CREATE TABLE temp(Id INT AUTO_INCREMENT, Celsius FLOAT, Fahrenheit FLOAT, PRIMARY KEY(Id))";
con.query(sql);

To create a column of Float datatype through a Java program, we need to execute the "CREATE TABLE" statement using the JDBC function execute() as follows −

String sql = "CREATE TABLE temp(Id INT AUTO_INCREMENT, Celsius FLOAT, Fahrenheit FLOAT, PRIMARY KEY(Id))";
statement.execute(sql);

To create a column of Float datatype through a python program, we need to execute the "CREATE TABLE" statement using the execute() function of the MySQL Connector/Python as follows −

sql = 'CREATE TABLE datatype_demo(ID INT, NAME VARCHAR(50), HEIGHT FLOAT, WEIGHT FLOAT)'' 
cursorObj.execute(sql)

var mysql = require("mysql2");
var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "password",
}); //Connecting to MySQL

con.connect(function (err) {
  if (err) throw err;
  //   console.log("Connected successfully...!");
  //   console.log("--------------------------");
  sql = "USE TUTORIALS";
  con.query(sql);

  //create a student table, that accepts one column of float type.
  sql =
    "CREATE TABLE temp(Id INT AUTO_INCREMENT, Celsius FLOAT, Fahrenheit FLOAT, PRIMARY KEY(Id))";
  con.query(sql);

  //insert data into created table
  sql =
    "INSERT INTO temp(Celsius, Fahrenheit) VALUES ( 36.2, 97.16), ( 35.8, 96.44), ( 37.32, 99.17), ( 35.89, 96.602)";
  con.query(sql);
  //select datatypes of salary
  sql = `SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'temp' AND COLUMN_NAME = 'Celsius'`;
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log(result);
  });
});       

Output

The output produced is as follows −

[ { DATA_TYPE: 'float' } ]

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Float {
   public static void main(String[] args) {
      String url = "jdbc:mysql://localhost:3306/TUTORIALS";
      String username = "root";
      String password = "password";
      try {
         Class.forName("com.mysql.cj.jdbc.Driver");
         Connection connection = DriverManager.getConnection(url, username, password);
         Statement statement = connection.createStatement();
         System.out.println("Connected successfully...!");

         //Float data types...!;
         String sql = "CREATE TABLE temp(Id INT AUTO_INCREMENT, Celsius FLOAT, Fahrenheit FLOAT, PRIMARY KEY(Id))";
         statement.execute(sql);
         System.out.println("column of a Float type created successfully...!");
         ResultSet resultSet = statement.executeQuery("DESCRIBE temp");
         while (resultSet.next()){
            System.out.println(resultSet.getString(1)+" "+resultSet.getString(2));
         }
         connection.close();
      } catch (Exception e) {
         System.out.println(e);
      }
   }
}    

Output

The output obtained is as shown below −

Connected successfully...!
column of a Float type created successfully...!
Id int
Celsius float
Fahrenheit float

import mysql.connector
# Establishing the connection
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
# Creating a cursor object
cursorObj = connection.cursor()
# Create table with float column
sql = '''
CREATE TABLE datatype_demo(ID INT, 
NAME VARCHAR(50), 
HEIGHT FLOAT,
WEIGHT FLOAT
)
'''
cursorObj.execute(sql)
print("The table is created successfully!")
# Data to be inserted
data_to_insert = [
    (1, 'John', 171.3, 65.7),
    (2, 'Rob', 45, 75),
    (3, 'Salman', 12.74839, 54.262),
    (4, 'Arush', None, None),
]
# Insert data into the created table
insert_query = "INSERT INTO datatype_demo (ID, NAME, HEIGHT, WEIGHT) VALUES (%s, %s, %s, %s)"
cursorObj.executemany(insert_query, data_to_insert)
# Commit the changes after the insert operation
connection.commit()
print("Rows inserted successfully.")
# Now display the table records
select_query = "SELECT * FROM datatype_demo"
cursorObj.execute(select_query)
result = cursorObj.fetchall()
print("Table Data:")
for row in result:
    print(row)
cursorObj.close()
connection.close()    

Output

Following is the output of the above code −

The table is created successfully!
Rows inserted successfully.
Table Data:
(1, 'John', 171.3, 65.7)
(2, 'Rob', 45.0, 75.0)
(3, 'Salman', 12.7484, 54.262)
(4, 'Arush', None, None)