Amiga.org
The "Not Quite Amiga but still computer related category" => Alternative Operating Systems => Topic started by: TheMagicM on January 30, 2005, 12:28:21 AM
-
I guess I'm confused as to where to start.. I want to setup a db on my comp and mess with different things like querying it via C/Java and various other things. I dont know where to really start other then I know I have a few mysql items on my system installed but not the actual db server itself I dont think.
-Alex
-
Using MySQL is a snap, but setting it up isn't. I'd check to see if MySQL Control Center is on your computer, and if not, get it here: http://www.mysql.com/products/mysqlcc/
One nice thing about it is that when you change tables and stuff, it will print out the code needed to create the content, making it a lot easier to learn how the database syntax works. You can also just cut-and-paste the generated code into your applications.
I use the Win32 version of MySQL, though, which auto-installs it as a service. I know nothing about initializing if from the command line.
-
mysqlcc is installed.. .I guess my problem is that when I do 'mysql start' it starts then exits..otherwise I'd pretty much be able to figure everything else out.
in the meantime I did get SQLite 3 working.. it has C commands to access a database you create with it.. creates a db in a single file.. pretty interesting.
-Alex