MySQL - INT 資料型別

要透過 JavaScript 程式建立 INT 資料型別的列，我們需要使用mysql2庫的query()函式執行“CREATE TABLE”語句，如下所示：

sql = "CREATE TABLE students (Id INT AUTO_INCREMENT primary key not null, reg_No INT )";
con.query(sql);

要透過 Java 程式建立 INT 資料型別的列，我們需要使用JDBC函式execute()執行“CREATE TABLE”語句，如下所示：

String sql = "CREATE TABLE students(Id INT AUTO_INCREMENT primary key not null, reg_No INT)";
statement.execute(sql);

要透過 Python 程式建立 INT 資料型別的列，我們需要使用MySQL Connector/Python的execute()函式執行“CREATE TABLE”語句，如下所示：

sql = 'CREATE TABLE students (ID int auto_increment, NAME varchar(20), primary key (ID) )'    
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 students table, that accepts one column of int type.
   sql = "CREATE TABLE students (Id INT AUTO_INCREMENT primary key not null, reg_No INT )";
   con.query(sql);

   //insert data into created table
   sql = "INSERT INTO students (reg_No) VALUES (101), (102)";
   con.query(sql);

   //select datatypes of salary
   sql = `SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'students' AND COLUMN_NAME = 'reg_No'`;
   con.query(sql, function (err, result) {
      if (err) throw err;
      console.log(result);
   });
});  

輸出

產生的輸出如下所示：

[ { DATA_TYPE: 'int' } ]

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

public class Int {
   public static void main(String[] args) {
      String url = "jdbc:mysql://: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...!");

         //Int data types...!;
         String sql = "CREATE TABLE students(Id INT AUTO_INCREMENT primary key not null, reg_No INT)";
         statement.execute(sql);
         System.out.println("column of a INT type created successfully...!");
         ResultSet resultSet = statement.executeQuery("DESCRIBE students");
         while (resultSet.next()){
            System.out.println(resultSet.getString(1)+" "+resultSet.getString(2));
         }
         connection.close();
      } catch (Exception e) {
         System.out.println(e);
      }
   }
}  

輸出

獲得的輸出如下所示：

Connected successfully...!
column of a INT type created successfully...!
Id int
reg_No int  

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 int column
sql = '''CREATE TABLE students (
ID int auto_increment,
NAME varchar(20),
primary key (ID)
)'''
cursorObj.execute(sql)
print("The table is created successfully!")
# Data to be inserted
data_to_insert = [
    (1, 'Tilak'),
    (2, 'Akash'),
    (3, 'Surya'),
    (4, 'Deepak'),
    (15, 'Arjun'),
    (16, 'Dev')
]
# Insert data into the created table
insert_query = "INSERT INTO STUDENTS (ID, NAME) VALUES (%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 Students"
cursorObj.execute(select_query)
result = cursorObj.fetchall()
print("Table Data:")
for row in result:
    print(row)
cursorObj.close()
connection.close()  

輸出

以下是上述程式碼的輸出：

The table is created successfully!
Rows inserted successfully.
Table Data:
(1, 'Tilak')
(2, 'Akash')
(3, 'Surya')
(4, 'Deepak')
(15, 'Arjun')
(16, 'Dev')