LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-04-2004, 09:11 AM   #1
digital bots
Member
 
Registered: Feb 2002
Distribution: Slack 10.1
Posts: 215

Rep: Reputation: 30
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.
 
Old 06-04-2004, 12:14 PM   #2
digital bots
Member
 
Registered: Feb 2002
Distribution: Slack 10.1
Posts: 215

Original Poster
Rep: Reputation: 30
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.
 
Old 06-04-2004, 03:16 PM   #3
kevinatkins
Member
 
Registered: Jan 2004
Location: cheshire, uk
Distribution: Ubuntu Hoary
Posts: 605

Rep: Reputation: 33
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..
 
Old 06-04-2004, 04:44 PM   #4
digital bots
Member
 
Registered: Feb 2002
Distribution: Slack 10.1
Posts: 215

Original Poster
Rep: Reputation: 30
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 02:20 PM
Which SQL is suitable for EMbedded SQL on C? hk_michael Programming 4 01-10-2005 05:07 PM
linux version of sql*plus pitts68 Linux - Newbie 3 10-25-2004 01:24 PM
sql on linux juanb Linux - Software 1 08-10-2004 09:23 PM
how do i connect thru SQL Server Running on windows NT puru_09 Linux - Software 1 08-11-2002 10:05 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:35 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration