LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Running SQL on linux (https://www.linuxquestions.org/questions/linux-software-2/running-sql-on-linux-189639/)

digital bots 06-04-2004 09:11 AM

Running SQL on linux
 
I have mysql on my linux box and i am trying to pratice Oracle db admin stuff on it for class. But i found that some of the commands are different like number isnt the same as it is in mysql and the command to link a primary key and a foriegn key isnt the same either. So what i am really asking is what other versions of sql are there that i could load that works more closly to the Oracle db structure?

i hope this makes since.

digital bots 06-04-2004 12:14 PM

i found what i needed its called postgresql and can be found at postgresql.org for anyone that wants to know where to find this at.

kevinatkins 06-04-2004 03:16 PM

i've not tried postgresql but i believe it's somewhat more powerful than mysql - which i have used, and has been ok for what i wanted to do. i have a nagging feeling that mysql doesn't (or didn't) support foreign keys..

digital bots 06-04-2004 04:44 PM

Quote:

Originally posted by kevinatkins
i've not tried postgresql but i believe it's somewhat more powerful than mysql - which i have used, and has been ok for what i wanted to do. i have a nagging feeling that mysql doesn't (or didn't) support foreign keys..
yea i dont think it does either thats why i need a more powerful sql engine :D


All times are GMT -5. The time now is 07:24 AM.