MySQL - 重新命名檢視

要在透過 JavaScript 程式重新命名 MySQL 資料庫中的檢視，我們需要使用mysql2庫的query()函式執行 RENAME 語句，如下所示：

sql = "RENAME TABLE CUSTOMERS_VIEW TO VIEW_CUSTOMERS";
con.query(sql);  

要在透過 Java 程式重新命名 MySQL 資料庫中的檢視，我們需要使用名為executeQuery()的JDBC函式執行 RENAME 語句，如下所示：

String sql = "RENAME TABLE first_view TO tutorial_view";
st.executeQuery(sql);

要透過 Python 程式重新命名 MySQL 資料庫中的檢視，我們需要使用 **MySQL Connector/Python** 的 **execute()** 函式執行 RENAME 語句，如下所示：

rename_view_query = "RENAME TABLE tutorial_view TO new_tutorial_view"
cursorObj.execute(rename_view_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("--------------------------");

  sql = "create database TUTORIALS"
  con.query(sql);

  sql = "USE TUTORIALS"
  con.query(sql);

  sql = "CREATE TABLE CUSTOMERS (ID INT NOT NULL,NAME VARCHAR (20) NOT NULL,AGE INT NOT NULL,ADDRESS CHAR (25),SALARY DECIMAL (18, 2),PRIMARY KEY (ID));"
  con.query(sql);

  sql = "INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 ),(2, 'Khilan', 25, 'Delhi', 1500.00 ),(3, 'kaushik', 23, 'Kota', 2000.00 ),(4, 'Chaitali', 25, 'Mumbai', 6500.00 ),(5, 'Hardik', 27, 'Bhopal', 8500.00 ),(6, 'Komal' ,22, 'MP', 4500.00 ),(7, 'Muffy', 24, 'Indore', 10000.00 );"
  con.query(sql);

  //Creating View
  sql = "Create view CUSTOMERS_VIEW AS SELECT * FROM CUSTOMERS";
  con.query(sql);

  //Renaming View
  sql = "RENAME TABLE CUSTOMERS_VIEW TO VIEW_CUSTOMERS;"
  con.query(sql);

  //Displaying records from view
  sql = "SELECT * FROM VIEW_CUSTOMERS;"
  con.query(sql, function(err, result){
    if (err) throw err
    console.log("**Views after deleting:**");
    console.log(result);
  });

});   

輸出

生成的輸出如下所示：

Connected!
--------------------------
[
  {ID: 1, NAME: 'Ramesh', AGE: 32, ADDRESS: 'Ahmedabad', SALARY: '2000.00'},
  {ID: 2, NAME: 'Khilan', AGE: 25, ADDRESS: 'Delhi', SALARY: '1500.00'},
  {ID: 3, NAME: 'kaushik', AGE: 23, ADDRESS: 'Kota', SALARY: '2000.00'},
  {ID: 4, NAME: 'Chaitali', AGE: 25, ADDRESS: 'Mumbai', SALARY: '6500.00'},
  {ID: 5, NAME: 'Hardik', AGE: 27, ADDRESS: 'Bhopal', SALARY: '8500.00'},
  {ID: 6, NAME: 'Komal', AGE: 22, ADDRESS: 'MP', SALARY: '4500.00' },
  {ID: 7, NAME: 'Muffy', AGE: 24, ADDRESS: 'Indore', SALARY: '10000.00'}
]  

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

public class RenameView {
   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...!");

         //Rename Created View.....
         String sql = "RENAME TABLE first_view TO tutorial_view";
         statement.executeUpdate(sql);
         System.out.println("Renamed view Successfully...!");
         ResultSet resultSet = statement.executeQuery("SELECT * FROM tutorial_view");
         while (resultSet.next()) {
            System.out.print(resultSet.getInt(1)+" "+ resultSet.getString(2)+ " "+ resultSet.getString(3));
            System.out.println();
         }
         connection.close();
      } catch (Exception e) {
         System.out.println(e);
      }
   }
}  

輸出

獲得的輸出如下所示：

Connected successfully...!
Renamed view Successfully...!
1 Learn PHP John Paul  

import mysql.connector
#establishing the connection
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
cursorObj = connection.cursor()
rename_view_query = "RENAME TABLE tutorial_view TO new_tutorial_view"
cursorObj.execute(rename_view_query)
connection.commit()
print("View renamed successfully.")
cursorObj.close()
connection.close()                

輸出

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

View renamed successfully.