• Ask a Question
  • Create a Poll
150
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel

      sql how can i insert a list or a array of data into a column

      sql how can i insert a list or a array of data into a column? e.g. python codes below

      in database a table named questionnaire initialized, name varchar(255) option varchar(255)

      name = "David" list_of_options = ["Java", "C++", "Python"] sql = "INSERT INTO questionnaire VALUES (%s, %s)" record = (name, list_of_options) mycursor.execute(sql, record) mydb.commit() 

      it doesn’t work, how can i solve this

      Asked by Aldenmarisophia on September 1, 2020 in Mysql.
      0 Answers