Wednesday, 24 March 2021

How can I interconnect with someone else's database in order to insert some values in his table?

I've written a script in python to create a table customers in MySQL database and insert some values within it. The script can insert values within the table errorlessly.

As I'm very new to play around with MySQL database, I can't understand how I can insert values in someone else's database, someone who is in different location. To be clearer, how can I interconnect with his database?

I've written so far:

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd = "",
  database="mydatabase"
)

mycursor = mydb.cursor()
mycursor.execute("CREATE TABLE if not exists customers (name VARCHAR(255), address VARCHAR(255))")
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = [
  ('Peter', 'Lowstreet 4'),
  ('Amy', 'Apple st 652'),
  ('Hannah', 'Mountain 21'),
  ('Michael', 'Valley 345'),
  ('Sandy', 'Ocean blvd 2'),
  ('Betty', 'Green Grass 1'),
  ('Richard', 'Sky st 331'),
  ('Susan', 'One way 98'),
  ('Vicky', 'Yellow Garden 2'),
  ('Ben', 'Park Lane 38'),
  ('William', 'Central st 954'),
  ('Chuck', 'Main Road 989'),
  ('Viola', 'Sideway 1633')
]

mycursor.executemany(sql, val)
mydb.commit()
mydb.close()

How can I interconnect with someone else's database in order to insert some values in his table?



from How can I interconnect with someone else's database in order to insert some values in his table?

No comments:

Post a Comment