Скачать или смотреть How to use a Jupyter notebook to run MySQL Query?

Writing an SQL query in Jupyter Notebook when a connection to a database has been established involves a few steps. Here's a general outline of the process:
To run the code you provided, which uses the mysql.connector library to connect to a MySQL database, follow these steps:

Install mysql.connector:
If you haven't already, you need to install the mysql.connector library. You can do this by running the following command:
pip install mysql-connector-python

Update Code with Connection Details: Replace the placeholders in the code with your actual MySQL database connection details. Update the user, host, database, and
import mysql.connector
my_conn=mysql.connector.connect(
host='localhost',
user='root',
password = 'xxxxxxxx,
db='indra',
)

my_cursor = my_conn.cursor()
my_cursor.execute("SELECT * FROM id_1995_18")
my_result = my_cursor.fetchall()
print(my_result)
Disconnecting from the server
conn.close()" at jupyter

To run the provided code in a Jupyter Notebook, you can follow these steps:

Open Jupyter Notebook: Launch Jupyter Notebook by opening a terminal or command prompt and typing:
jupyter notebook
This will open the Jupyter Notebook interface in your web browser.

Create a New Notebook: In the Jupyter Notebook interface, click on the "New" button and select "Python 3" under "Notebooks" to create a new Python notebook.

Copy and Paste Code: In a notebook cell, copy and paste the provided code:
import mysql.connector
conn = mysql.connector.connect(
user='root',
host='localhost',
database='indra',
password='Indra@1976'
)
print(conn)

Disconnecting from the server
conn.close()
Run the Code: To run the code in the cell, you can either press the "Run" button in the toolbar at the top of the notebook or press Shift+Enter after selecting the cell. The code will be executed, and if the connection details are correct, you will see the connection object printed as output.

Remember that for this code to work, you need to have a MySQL server running on your local machine with the provided connection details. Make sure the MySQL server is accessible and that you have the mysql.connector library installed in the Jupyter environment.