Hi, it's me RapidFire! I was wondering if someone could show me a good site/video/page that'd be good for me to go off of for learning SQL.
I'm wanting to get into SQL because I know it's better than using Text Data stuff and PData. But I don't know how, or where to start for it. I already have knowledge of lua, and the very basics to connecting to a database. Any help is really appreciated!
Are you the guy from Gmodstore who was asking about implementing MySQL into a custom addon that rewards user play time that I applied for?
It's a small world.
Sign up on Code Academy and do their SQL course. Free and takes about an hour if you have no previous knowledge. Just make sure you have some dedication otherwise you’ll waste your time, as with anything I guess.
PData uses sqlite and it's not that bad to use for a utime replacement. Or you can mess around with sqlite yourself.
I checked out how UTime did their Time Say, SQL Query stuff and went through and recreated the majority of it, didn't really like how the code was setup. :b *public functions, ect* I also looked on the older GMOD wiki as it showed SELECT, and what'not explaining what they did. I followed a few tutorials and found out a very simplistic method of how to use SQLLite. I have a slight idea now of how to do things. I was unaware that PData used SQLLite, but I hear the PData does it slower or something like so. I didn't know that page existed either, thanks!
I'll check it out
PData is a simple approach for someone who might not be the best at sql, if you're able to construct your own tables and use them efficiently then that is 100% better.
statements such as SELECT, UPDATE, REPLACE, etc are all very self explanatory.
SELECT value FROM table where this = that
UPDATE table SET this = that WHERE this = that
etc.
(SHHH)
I just use this and it works for me.
Sorry, you need to Log In to post a reply to this thread.
