MySQL - 创建表

要通过 Node.js 程序在 MySQL 数据库中创建表，我们需要使用 mysql2 库中的 query() 函数执行 CREATE TABLE 语句，如下所示:-

sql = "CREATE TABLE table_name (column_name column_type)";
con.query(sql);

要通过 Java 程序在 MySQL 数据库中创建表，我们需要使用 JDBC 函数 executeUpdate() 执行 CREATE TABLE 语句，如下所示:-

String sql = "CREATE TABLE table_name (column_name column_type)";
statement.execute(sql);

要通过 Pyhton 程序在 MySQL 数据库中创建表，我们需要使用 MySQL Connector/Python 的 execute() 函数执行 CREATE TABLE 语句，如下所示:-

sql = "CREATE TABLE table_name (column_name column_type)";
cursorObj.execute(sql);

var mysql = require('mysql2');
var con = mysql.createConnection({
   host: "localhost",
   user: "root",
   password: "*****"
});
 //连接到 MySQL
  con.connect(function (err) {
  if (err) throw err;
  console.log("Connected!");
  console.log("--------------------------");
  
  //创建一个表
  sql = "CREATE TABLE tutorials_tbl(tutorial_id INT NOT NULL AUTO_INCREMENT,tutorial_title VARCHAR(100) NOT NULL,tutorial_author VARCHAR(40) NOT NULL,submission_date DATE,PRIMARY KEY ( tutorial_id ));"
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("The table tutorials_tbl is created successfully!");
  });
});

输出

生成的输出如下 -

Connected!
--------------------------
The table tutorials_tbl is created successfully!

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class CreateTable {
   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...!");
           //Create new table...!
            String sql = "CREATE TABLE tutorials_tbl (ID Int Auto_Increment not null, tutorial_title Varchar(50) Not Null, tutorial_author Varchar(30) Not Null, Primary Key(ID))";
            statement.executeUpdate(sql);
            System.out.println("Table created successfully...!");
           ResultSet resultSet = statement.executeQuery("DESCRIBE tutorials_tbl");
            while (resultSet.next()) {
                System.out.print(resultSet.getNString(1));
                System.out.println();
            }
            connection.close();
        } catch (Exception e) {
            System.out.println(e);
        }
    }
}

输出

获得的输出如下所示 -

Connected successfully...!
Table created successfully...!
ID
tutorial_title
tutorial_author

import mysql.connector
#建立连接
conn = mysql.connector.connect(
   user='root', password='password', host='localhost', database='tut'
)
#创建游标对象
cursor = conn.cursor()
#创建表
sql ='''CREATE TABLE tutorials_tbl(
   tutorial_id INT NOT NULL AUTO_INCREMENT,
   tutorial_title VARCHAR(100) NOT NULL,
   tutorial_author VARCHAR(40) NOT NULL,
   submission_date DATE,
   PRIMARY KEY ( tutorial_id )
)'''
cursor.execute(sql)
print ("The table tutorials_tbl is created successfully!")
#关闭连接
conn.close()

输出

以下是上述代码的输出 -

The table tutorials_tbl is created successfully!