On 16 dic, 17:48, Luke <[EMAIL PROTECTED]> wrote: > Bruno Desthuilliers wrote:
>> Err... Are you sure you want a new table here ? > > yes, thats the easier way i can think of for now since i am so new to SQL, > eventually im sure i will put all the characters into one larger table > though... but for now i just dont feal like figuring out how to scan the > table for the records i need based on name of character... ill save that > for later. (unless there is a very easy way to do it that doesnt require > re) re???? No. Just plain SQL, see below. As you wouldn't -in general- define a new class for each character, the same happens for the tables: you wouldn't create a new table for each character, as they all share the same set of attributes; just insert a new *row* of data into the table. BTW, it's similar to what you appear to be doing previously: appending a new row to Character.hro file, conceptually it's the same thing. Table names and column names are usually known when you define the application and remain fixed. And they can't be provided as parameters in the execute method: that's why Bruno split it in two steps, building a sql statement first (with the table name in it) and then executing it with the remaining parameters. So, I would create the table ONCE, with name Character, and a new column Account. To insert a new character: sql = """ INSERT INTO Character (account, name, gender, job, level, str, dex, intel, cha, luc) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)""" cursor.execute(sql, (CharAccount, CharName, CharGender, CharJob, CharLevel, Strength, Dexterity, Inteligence, Charm, Luck)) Retrieving a certain character is not harder: sql = """ SELECT name, gender, job, level, str, dex, intel, cha, luc FROM Character WHERE account = %s""" cursor.execute(sql, (CharAccount,)) CharName, CharGender, CharJob, CharLevel, Strength, Dexterity, Inteligence, Charm, Luck = cursor.fetchone() -- Gabriel Genellina -- http://mail.python.org/mailman/listinfo/python-list