写一个python代码电脑每200ms读取串口数据上传数据库

Sure, here's a basic Python code for reading serial data from the computer every 200ms and uploading it to a database:

import serial
import time
import pymysql

# connect to the serial port and database
ser = serial.Serial('COM3', baudrate=9600, timeout=10)
conn = pymysql.connect(host='localhost', user='root', password='password', database='mydatabase')
cursor = conn.cursor()

# loop indefinitely
while True:
    # read the serial data
    data = ser.readline().decode().strip()
    
    # insert the data into the database
    query = "INSERT INTO mytable (data) VALUES ('{}')".format(data)
    cursor.execute(query)
    conn.commit()
    
    # wait for 200ms before reading the next data
    time.sleep(0.2)

# close the serial port and database connection
ser.close()
cursor.close()
conn.close()

Please note that you need to modify the COM port and database settings according to your configuration. Also, this code assumes that you have already created a table named 'mytable' in your database.