MySQL - Boolean 布尔数据类型

MySQL NodeJS 连接器 mysql2 提供了一个名为 query() 的函数，用于在 MySQL 数据库中执行 SQL 查询。此函数接受一个字符串值作为参数，该参数表示要执行的查询。

要在 MySQL 表中执行布尔运算，我们需要使用此函数以如下方式执行 CREATE TABLE 语句:-

sql= "CREATE TABLE table_name ( Column_name BOOLEAN )";
con.query(sql);

我们可以使用 JDBC type 4 驱动程序通过 Java 与 MySQL 通信。它提供了一个名为 execute() 的函数，用于在 MySQL 数据库中执行 SQL 查询。此函数接受一个字符串值作为参数，表示要执行的查询。

要在 MySQL 表中执行布尔运算，我们需要使用此函数执行 CREATE TABLE 语句，如下所示:-

String sql = "CREATE TABLE table_name ( Column_name BOOLEAN )";
statement.execute(sql);

MySQL Connector/Python 提供了一个名为 execute() 的函数，用于在 MySQL 数据库中执行 SQL 查询。此函数接受一个字符串值作为参数，表示要执行的查询。

要在 MySQL 表中执行布尔运算，我们需要使用此函数执行 CREATE TABLE 语句，如下所示:-

query = "CREATE TABLE table_name (Column_name BOOLEAN)"
cursorObj.execute(query);

var mysql = require("mysql2");
var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "Nr5a0204@123",
});

//连接到 MySQL
con.connect(function (err) {
  if (err) throw err;
  console.log("Connected!");
  console.log("--------------------------");
 //选择数据库
  sql = "CREATE DATABASE TUTORIALS";
  con.query(sql);
 //选择数据库
  sql = "USE TUTORIALS";
  con.query(sql);
 //Creating CUSTOMERS table
  sql = "CREATE TABLE CUSTOMERS (ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, NAME VARCHAR(40), AVAILABILITY BOOLEAN);"
  con.query(sql , function(err){
    if (err) throw err;
    console.log("Table created Successfully...");
  });
 //插入记录
  sql = "INSERT INTO CUSTOMERS(ID, NAME, AVAILABILITY) VALUES (1, 'Ramesh', 0), (2, 'Khilan', 1), (4, 'Kaushik', NULL);"
  con.query(sql);
 //Displaying all the records of the CUSTOMERS table
  sql = "SELECT * FROM CUSTOMERS;"
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log(result);
  });
});    

输出

生成的输出如下 -

Connected!
--------------------------
Table created Successfully...
[
  { ID: 1, NAME: 'Ramesh', AVAILABILITY: 0 },
  { ID: 2, NAME: 'Khilan', AVAILABILITY: 1 },
  { ID: 4, NAME: 'Kaushik', AVAILABILITY: null }
]      

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class BooleanOperator {
  public static void main(String[] args) {
    String url = "jdbc:mysql://localhost:3306/TUTORIALS";
    String user = "root";
    String password = "password";
    ResultSet rs;
    try {
      Class.forName("com.mysql.cj.jdbc.Driver");
            Connection con = DriverManager.getConnection(url, user, password);
            Statement st = con.createStatement();
            //System.out.println("Database connected successfully...!");
            //create a table(having boolean field/column)
            String sql = "CREATE TABLE CUSTOMERS (ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,NAME VARCHAR(40),AVAILABILITY BOOLEAN)";
            st.execute(sql);
            System.out.println("Table created successfully...!");
            //now lets insert some records
            String sql1 = "INSERT INTO CUSTOMERS(ID, NAME, AVAILABILITY) VALUES (1, 'Ramesh', 0), (2, 'Khilan', 1), (4, 'Kaushik', NULL)";
            st.executeUpdate(sql1);
            System.out.println("Records inserted successfully...!");
            //lets display the records....
            String sql2 = "SELECT * FROM CUSTOMERS";
            rs = st.executeQuery(sql2);
            System.out.println("Table records are: ");
            while(rs.next()) {
              String id = rs.getString("Id");
              String name = rs.getString("Name");
              String is_available = rs.getString("AVAILABILITY");
              System.out.println("Id: " + id + ", Name: " + name + ", Is_available: " + is_available);
            }
    }catch(Exception e) {
      e.printStackTrace();
    }
  }
}                             

输出

获得的输出如下所示 -

Table created successfully...!
Records inserted successfully...!
Table records are: 
Id: 1, Name: Ramesh, Is_available: 0
Id: 2, Name: Khilan, Is_available: 1
Id: 4, Name: Kaushik, Is_available: null        

import mysql.connector
# 建立连接
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
table_name = 'customer'
# 创建游标对象 
cursorObj = connection.cursor()
# Create table with boolean column
sql = ''' CREATE TABLE CUSTOMER(
    ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    NAME VARCHAR(40),
    AVAILABILITY BOOLEAN)'''
cursorObj.execute(sql)
print("The table is created successfully!")
# 向创建的表中插入数据
insert_query = 'INSERT INTO CUSTOMER(ID, NAME, AVAILABILITY) VALUES (1, "Ramesh", TRUE);'
cursorObj.execute(insert_query)
print("Row inserted successfully.")
# 现在显示表记录
select_query = "SELECT * FROM CUSTOMER"
cursorObj.execute(select_query)
result = cursorObj.fetchall()
print("Tutorial Table Data:")
for row in result:
    print(row)
cursorObj.close()
connection.close()                                

输出

以下是上述代码的输出 -

The table is created successfully!
Row inserted successfully.
Tutorial Table Data:
(1, 'Ramesh', 1)