Arsilex Posted November 9, 2012 Share Posted November 9, 2012 [lua]connect = dbConnect( "mysql", "dbname=Ilusion;host=instance31261.db.xeround.com;port=20197", "pekio123", "pekio19999", "share=1" ) if connect then outputChatBox ( "Connected", source ) base = executeSQLQuery("CREATE TABLE IF NOT EXISTS players (clothes_head_texture TEXT, clothes_head_model TEXT, name TEXT)") executeSQLQuery("CREATE TABLE IF NOT EXISTS `players` (`clothes_head_texture` TEXT, `clothes_head_model` TEXT, `name` TEXT)") if base and base2 then outputChatBox ( "Connected2", source ) end else outputChatBox ( "Error", source ) end [/lua] How i can user this to create tabla Players in mysql datebase? this not work put Connected2 and Connected but no create table Link to comment
TAPL Posted November 9, 2012 Share Posted November 9, 2012 What have executeSQLQuery to do with mysql? You need dbQuery not executeSQLQuery. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now