'LinKin Posted March 15, 2015 Posted March 15, 2015 Hello, Can I declare Primary keys, Foreign keys with the SQL used by MTA? (executeSQLQuery)
Addlibs Posted March 15, 2015 Posted March 15, 2015 MTA's executeSQLQuery uses SQLite, I assume anything possible with SQLite is also possible with executeSQLQuery. However, as far as I know, the only primary key in MTA is predefined, 'rowid'.
JR10 Posted March 15, 2015 Posted March 15, 2015 First of all, do not use executeSQLQuery, it lacks support for callbacks and hangs the whole server till the data is selected. Use the newer db* functions. Primary and foreign keys should work just fine.
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