Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- cursor.execute("SELECT id FROM keywords WHERE name = '%s', " % (channel_name))
- import pymysql
- name = input('Введите что то:n')
- with pymysql.connect(
- host=host,
- port=3306,
- user=user,
- password=password,
- db="base",
- charset='utf8',
- autocommit=True) as cur:
- cur.execute("INSERT INTO Twiss (real_name_test) VALUES (%s)", (name,))
- cur.execute("SELECT ID FROM Twiss WHERE real_name_test LIKE %s", (name,))
- row = cur.fetchall()
- print('ID которое заполнилось = {}'.format(row[0][0]))
- Введите что то:
- Данный для заполнения SQL
- ID которое заполнилось = 65
Add Comment
Please, Sign In to add comment