如何在insert statmen中指定将两列串联到新列中

Question

我在mysql中有这个表

`id`,`camera_id`,`image_id`,`name`,`plate`,`datetime`,`millisecs`,`nationality`,`image_name`,`image`,`checked`).

我想把id和camera_id连接成image_id，在这里我可以在这个脚本中指定concatenate。'Id'是具有自动增量的主键，camera\u Id是摄像机的Id

def insert_entry(self, camId, camName, vrm, entryDatetime, milliSecs, nationality, filename):
        myFilename = "/tmp/%s" % filename

        fullOldPlate = re.compile('^\D\d{3}\D{3}$')
        fullNewPlate = re.compile('^\D{2}[05]\d\D{3}$')

        tableName = "customer_1.%s_anpr_vega" % camName
        #os.chown(myFilename,116,123)
        #os.chmod(myFilename, 438)

        checked = 0
        if(fullOldPlate.match(vrm)):
            checked = 1
        elif(fullNewPlate.match(vrm)):
            checked = 1

        sql = """INSERT INTO %s (camera_id, name, plate, datetime, millisecs, nationality, image_name,checked)
        values ("%s", "%s", "%s", "%s", "%s", "%s", "%s", "%s") """ % (tableName,
                                                       camId,
                                                       camName,
                                                       vrm,
                                                       entryDatetime,
                                                       milliSecs,
                                                       nationality,
                                                       filename,
                                                       checked)
        # print sql
        retVal = self.cursor.execute(sql)

        # Now get the id of the entry we have just created
        sql = """SELECT id FROM %s ORDER BY id DESC""" % tableName
        self.cursor.execute(sql)
        tmp = self.cursor.fetchone()
        myId = tmp[0]

        sql = """UPDATE %s SET IMAGE=LOAD_FILE('%s') WHERE id = "%s" """ % (tableName,
            myFilename,
            myId)
        #self.cursor.execute(sql)
        # Remove the image file
        #os.remove(myFilename)

        return myId