callimuc is correct, it is not a good idea to delve into sql while not being completely familiar with the language syntax
there are at least 4 problems with what you are attempting to do -
- for creating the table, the table name does not need to be within quotes and there is no primary key (index) which is a really good idea to include, it is also not a good idea to use spaces within table or column names, a correct example would be - CREATE TABLE loginList (pID INTEGER PRIMARY KEY, account VARCHAR NOT NULL)
- the players account isnt being concatenated into the insert query string correctly, in gs2 this is what '@' is for, for example - temp.string = "test_" @ player.account @ "_test2";
- you have player.account wrapped within " " quotes when it is a variable, which if the concatenation was correct it would literally use the text 'player.account' as opposed to the actual account of the player object
- the table column name is not being set within ( ) brackets
if you ever encounter sql within a live environment you should never tamper with it unless you are completely sure about how it works and how to use it