corvey wrote: |
I would also need to make an external program to be able to access planet data so that the statistics can be updated by a defined hour. |
Mine GO BOOM wrote: |
If you plan on using this data in anything other than just ASSS, I'd recommend using SQL over anything else internal. Depending on the language you use, SQL can be very simple or annoying to add into your code. |
Code: Show/Hide SHOW databases; USE database_name; // [E.X.: Use asss] SHOW tables; SELECT * FROM table_name; // Notice there will be an output of everything in that table or it will say it is empty. // Now find the names that come up with a list of data under it. SELECT what_you_found FROM table_name; SELECT * FROM table_name WHERE what_you_found = 'something'; // It will return empty or show you everything about that area. |
Code: Show/Hide // Here is an example mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | TCPBiller | | asss | | auth | | members | | mysql | | php | | tcpbiller | +--------------------+ 8 rows in set (0.00 sec) mysql> use auth Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------+ | Tables_in_auth | +----------------+ | user | +----------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM user; +-----------+----------------------------------+ | name | pass | +-----------+----------------------------------+ | brad | 958636f23559f431b8bd2e605fdbc2f5 | | wkbmarine | 323a57bff1764b0e680478bdb006682a | +-----------+----------------------------------+ 2 rows in set (0.02 sec) mysql> SELECT name FROM user; +-----------+ | name | +-----------+ | brad | | wkbmarine | +-----------+ 2 rows in set (0.00 sec) mysql> SELECT * FROM user where name = 'brad'; +------+----------------------------------+ | name | pass | +------+----------------------------------+ | brad | 958636f23559f431b8bd2e605fdbc2f5 | +------+----------------------------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM user where name = 'bra33d'; Empty set (0.00 sec) |
Doc Flabby wrote: |
GUI for mysql http://www.heidisql.com/ |
Dr Brain wrote: |
The fact that there's already a mysql module makes it a no-brainer. |
Dr Brain wrote: |
Uh, have you looked at the built in one I talked about in my post? Database:mysql? |
corvey wrote: |
Care to make a real reference statement? If this first post is what your talking about, I am not amused. |
BDwinsAlt wrote: |
Have you tried Alias.c (located in the same folder as mysql.c)?
That is a great example of how asss uses mysql. |