MySQL - 布尔数据类型

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

要在MySQL表中执行布尔运算，我们需要使用此函数执行CREATE TABLE语句：

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

我们可以使用JDBC 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",
});

//Connecting to MySQL
con.connect(function (err) {
  if (err) throw err;
  console.log("Connected!");
  console.log("--------------------------");

  //Select database
  sql = "CREATE DATABASE TUTORIALS";
  con.query(sql);

  //Select database
  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...");
  });

  //Inserting Records
  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://127.0.0.1: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
# Establishing the connection
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
table_name = 'customer'
# Creating a cursor object 
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 data into the created table
insert_query = 'INSERT INTO CUSTOMER(ID, NAME, AVAILABILITY) VALUES (1, "Ramesh", TRUE);'
cursorObj.execute(insert_query)
print("Row inserted successfully.")
# Now display the table records
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)